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
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
Also the optimization section may be of use:
(you can replace 5.0 with 5.1, 4.1, etc. depending on your version).
- steve edberg