Another Look at MySQL 5.1's SQL Diagnostic Tools

Monday Jan 26th 2009 by DatabaseJournal.com Staff

Prior to MySQL 5.1, it wasn’t all that easy to find the worst running SQL on a MySQL instance. And truth be told, MySQL still has a ways to go before it’s an effortless process. But, the good news is there are some new aids in MySQL 5.1 and MySQL Enterprise that do make it more efficient to find and troubleshoot bad SQL code that’s hiding inside a MySQL instance. Let’s take a quick tour through these new features and see what help they provide.

[From MySQL AB]

No matter what they say, I don’t think it’s true. Database ‘experts’ say that 80-90% of a database’s overall performance comes from the SQL code that’s running against it. And I just don’t buy it. Instead, I think that most of a database’s performance comes from optimal design, and after that SQL code comes next. If you properly design your database, then you’re way ahead of the game in terms of performance issues. That’s when well-written SQL code can glide along your design like butter on a hot skillet.

The article continues at http://dev.mysql.com/tech-resources/articles/mysql_51_diagnostic_tools.html

Mobile Site | Full Site