Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2012

    Unanswered: mysql allocating big sizes for tables in mysql db

    i found that mysql has been allocating big size for the following tables.
    Well, ls -l and ls -s returns different value, so i am not sure whether it's something wrong with my machine,
    or mysql actually allocate 512M for the tables.
    Any parameter which i set wrongly will lead to the following result in mysql, let's say the block size of the table?
    Other files in the unix system shows proper size with ls -s except for mysql files, so i am wondering if this has to do with the mysql setting itself.

    512M -rw-rw---- 1 mysql mysql  20K  7月  3 22:39 2012 /mysql/help_topic.MYI
    512M -rw-rw---- 1 mysql mysql  19K  7月  3 22:39 2012 /mysql/help_relation.MYI
    512M -rw-rw---- 1 mysql mysql  16K  7月  3 22:39 2012 /mysql/help_keyword.MYI
    512M -rw-rw---- 1 mysql mysql 5.0K  7月  9 15:30 2012 /mysql/db.MYI
    Thank you.

  2. #2
    Join Date
    Sep 2009
    San Sebastian, Spain
    This indeed looks very strange. What flavour of UNIX are you using? By default in programs like ls the default block size is 1024 bytes. This may be changed using environment variables such as BLOCK_SIZE. Can you make sure that this is not set in your environment when using ls? If this is set to 512M then this might explain your result.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    Follow me on Twitter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts