Is there any kind of performance / tuning guide software for MySQL?
I am looking for something which can look at the SHOW VARIABLES and SHOW
STATUS commands, do some calculations and give some tips on how to
improve the system?
Any such product available?
--
MySQL General Mailing List
For list
Your settings need to be based upon usage patterns. Some systems have
lots of inserts, others are mostly selects, some have lots of joins,
others don't. All these would have different settings. There are even
cases where you would want a table to be InnoDB instead of ISAM or the
other way