Bluehost.com Web Hosting $6.95

myisamchk and empty spaces

This is a discussion on myisamchk and empty spaces within the MySQL Database forums, part of the Database Forums category; Could someone explain if I used myisamchk correctly? --- SNIP --- `myisamchk -i weirdtable.MYI` Checking MyISAM file: weirdtable.MYI Data records: ...


Go Back   Usenet Forums > Database Forums > MySQL Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-23-2007
Paul
 
Posts: n/a
Default myisamchk and empty spaces

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.

Reply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




All times are GMT +1. The time now is 03:09 AM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0