Re: Is there any Performance Improvement / Tuning Software for MySQL?

[Brent Baisley]

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 around. It's all part of being a DBA, there is no holy grail 
where you can just push a button and magically have the best settings. 
Oracle and IBM (DB2) are just now coming out with self-tuning systems.

So, you would need a program to analyze your query logs (over say a few 
weeks), analyze you current settings, compare them against the hardware 
it's running on (which will dictates the limits) and come up with a 
recommendation. Usage patterns may vary throughout the day, so the 
program would need to take into account important times, otherwise your 
backup may run very well, but everything else would be slow. A design 
change in the database could then completely change the usage patterns, 
so you would then need to start your analysis over. But then, a lack of 
an index on a field could be the one thing that's killing your 
performance, not your settings.

Almost no settings would help a poorly designed database or poor query 
syntax.

I know I didn't really help you, but I don't think what you are looking 
for exists. Best advice I could give is to look at your slow query log 
to see what's getting bogged down.

On Jul 23, 2004, at 3:52 AM, Terence wrote:
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 archives: http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/[EMAIL PROTECTED]


--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]