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?
Sorry if this is a stupid question...just not sure.
Thanks.
-- Jason
On 7/20/01 10:01 AM, Basil Hussain was heard saying:
> Hi,
>
>> Thank you very much for the detailed analysis! One question:
>> where did he get all this data from?
>
> You can show all of MySQL's status and configuration parameters by issuing
> these statements:
>
> SHOW STATUS;
> SHOW VARIABLES;
>
> Also, the following can come in handy if you want to see info about your
> tables:
>
> SHOW TABLE STATUS;
>
> The one piece of data that is particularly of relevance to performance
> tuning with the output from this is Data_free. This shows how much space has
> been allocated in the table but not used. If it is high, then it's time to
> run OPTIMIZE TABLE on that particular table to consolidate empty gaps.
>
> 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
>
---------------------------------------------------------------------
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
