My favorites | Sign in
Project Home Downloads Wiki Issues Source
Roadmap and vision for mk-query-advisor
Updated Feb 7, 2010 by baron.schwartz


This tool does not exist. Its purpose is to do static analysis of queries by examining patterns within the SQL, and optionally to do dynamic analysis by connecting to a server and examining EXPLAIN, looking at samples of data, examining cardinality, and so on. The initial issue report is  issue 861 .

An example is to look for queries that have IN() or NOT IN() subqueries, which are poorly optimized in current versions of MySQL. These can be recognized simply by looking at the SQL.

Powered by Google Project Hosting