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
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.