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
