On Tue, February 23, 2010 1:28 pm, Cantwell, Bryan wrote:
> Is there still no such thing anywhere for Mysql as an index analyser?
> Many others have such a thing that will sit and monitor db activity over a
> poeriod of time and suggest the exact indexes on each table based on what
> it has seen to improve performance.... Anyone got that for MySQL?
>
I know of no daemon/service-style analyzer, but are you aware of the
ANALYZE/OPTIMIZE commands?
http://dev.mysql.com/doc/refman/5.0/en/table-maintenance-sql.html
You could set up a scheduled job to run an ANALYZE during periods of low
activity, for example Saturday nights 11pm.
To examine performance of an individual SELECT query, there is the EXPLAIN
command.
http://dev.mysql.com/doc/refman/5.0/en/explain.html
Also the optimization section may be of use:
http://dev.mysql.com/doc/refman/5.0/en/optimization.html
(you can replace 5.0 with 5.1, 4.1, etc. depending on your version).
- steve edberg
