Recently, MySQL introduced the MySQL Query Analyzer tool, which can help DBAs resolve performance problems in their SQL code. The tool monitors query
performance and shows SQL code that is causing a slow
down without relying on the slow query log. DBAs can take this information and use it to further tune their environment to achieve better performance. You can watch a small demo here to see the product. Note that the Query Analyzer tool is available with MySQL Enterprise. A trial version of MySQL Enterprise can be downloaded for 30 days at http://www.mysql.com/trials/.
- All
- Personal
- PlanetMySQL
- Sun
I'm very disappointed at the licensing scheme for this product. I have purchased Enterprise Gold support for 4 servers @ $3k each. I use Network Monitor on them and really appreciate its value. However, when it comes to analyzing queries, it makes much more sense to do that during the development and staging processes. I don't intend to pay for Enterprise Support for "throw away" servers. I'm a I have chosen MySQL over its competitors to avoid the licensing issues that get in the way of an agile workflow. I'm very uneasy with the direction I feel this is going.
Posted by Richard Bronosky on March 10, 2009 at 11:43 AM PDT #
@Richard: I have passed this feedback on to product management.
Posted by Jennifer Glore on March 16, 2009 at 02:26 PM PDT #