Unix Technical Forum

myisamchk and empty spaces

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


Go Back   Unix Technical Forum > Database Server Software > MySQL

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 09:14 AM
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.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:58 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com