Hi,
> Quick question about the SHOW TABLE STATUS command and the
> Data_free info in
> particular.
>
> You say: "If it is high, then it's time to run OPTIMIZE TABLE..."
>
> What is considered high? As I'm looking at my output, I see that
> most of my
> tables show a value of 0, however, some have a value around 300
> and some go
> WAY high. Is 300 considered high?
What you need to do is take a look at the Data_free figure in relation to
the size of the table's data file itself, indicated by the Data_length
figure.
Let's take an example (extract of SHOW TABLE STATUS output edited for
brevity):
Data_length: 97128
Max_data_length: 25769803775
Index_length: 175104
Data_free: 234
If we take the Data_free figure (234 bytes) and divide it by the Data_length
(97128 bytes) and work out a percentage value, then we can get a good idea
of how much space is being wasted. In this case, it's:
(234 / 97128) * 100 = 0.24%
This is way less than one percent, so in this case it's no problem. But, I
reckon that if you have more than several percent free space (say 10%) then
you definitely need to optimise.
Regards,
Basil Hussain
---------------------------------------
Internet Developer, Kodak Weddings
E-Mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
