Sun unveils MySQL query analyzer tool

PARIS, FRANCE: Sun Microsystems, Inc. has announced a major new version of its MySQL Enterprise subscription service to help corporate users dramatically improve the speed and uptime of their MySQL database applications.

MySQL Enterprise subscribers now have access to Sun's new MySQL Query Analyzer tool for monitoring query performance to accurately pinpoint and correct problem SQL code, in addition to MySQL Enterprise's regular software updates and 24x7 production technical support.

"With the MySQL Query Analyzer, we were able to identify and analyze problematic SQL code, and triple our database performance," said Keith Souhrada, software development engineer for Big Fish Games. "More importantly, we were able to accomplish this in three days, rather than taking weeks."

"The new MySQL Query Analyzer is a turbo boost for MySQL applications," said Marten Mickos, SVP Database Group, Sun Microsystems. "It allows DBAs and developers to identify, within minutes, database queries that could be run faster and more efficiently. They can then pro-actively tune their code before it causes any slowdown that could negatively impact their business."

MySQL Query Analyzer

The MySQL Query Analyzer saves time and effort in finding and fixing problem queries by providing:

* Aggregated view into query execution counts, run time, result sets across all MySQL servers with no dependence on MySQL logs or SHOW PROCESSLIST

* Sortable views by all monitored statistics

* Searchable and sortable queries by query type, content, server, database, date/time, interval range, and "when first seen"

* Historical and real-time analysis of all queries across all servers

* Drill downs into sampled query execution statistics, fully qualified with variable substitutions, and EXPLAIN results

The new MySQL Query Analyzer tool is integrated into the MySQL Enterprise Monitor, a key component of Sun's MySQL Enterprise subscription offering.