Query Analysis

Databases MySQL

Optimizing SQL Performance – The Art of Elimination

Ronald Bradford
July 8, 2010

The most efficient performance optimization of a SQL statement is to eliminate it. Cary Millsap’s recent Kaleidoscope presentation again highlighted that improving performance is function of code path. Removing code will improve performance.

Databases Drizzle General MySQL MySQL Proxy Open Source

SQL Analysis with MySQL Proxy – Part 2

Ronald Bradford
September 3, 2009

As I outlined in Part 1 MySQL Proxy can be one tool for performing SQL analysis. The impact with any monitoring is the art of monitoring will affect the results, in this case the performance.

Databases Linux MySQL MySQL Proxy Open Source

SQL query analysis with MySQL Proxy

Ronald Bradford
September 3, 2009

Long before there was the official Query Analyzer (QUAN), a component of MySQL Enterprise, SQL analysis was possible using MySQL Proxy . The following is an introduction to logging and query analysis with MySQL Proxy.