This is a discussion on myisamchk and empty spaces within the MySQL forums, part of the Database Server Software category; --> Could someone explain if I used myisamchk correctly? --- SNIP --- `myisamchk -i weirdtable.MYI` Checking MyISAM file: weirdtable.MYI Data ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| Could someone explain if I used myisamchk correctly? --- SNIP --- `myisamchk -i weirdtable.MYI` Checking MyISAM file: weirdtable.MYI Data records: 1 Deleted blocks: 14 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 Key: 1: Keyblocks used: 0% Packed: 0% Max levels: 1 Total: Keyblocks used: 0% Packed: 0% - check record links Records: 1 M.recordlength: 197 Packed: 73% Recordspace used: 93% Empty space: 2045% Blocks/ Record: 1.00 Record blocks: 1 Delete blocks: 14 Record data: 197 Deleted data: 4096 --- SNIP --- I'm assuming "Empty Space", Delete blocks and Deleted data are bad things, especially when Empty Space reaches 2045%. I looked around and assumed I fixed it with this: `mysql> optimize table weirdtable;` because the next time I ran `myisamchk -i weirdtable.MYI`, the Empty Space is at 0%, Deleted data is 0, and Delete blocks is 0. So, did I do this right? Did I just royally screw up the table? And hey, does it even matter? Thanks for your time in reading this. |