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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
