issues

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.

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.

The roadmap needs to be created. As of now,

• Look at trunk/mk-audit/TODO and pull items out of it, create issues, and list them here.

Note: A customer sent Baron some PHP code that is supposed to parse SQL statements. It is in trunk/misc/QuerySplitter.php. The provenance and functionality are unknown. It might be useful to look at it. It might also be useful to look at what's been done in the QOT tools