MySQL boosts performance with Query Analyzer

Sun's MySQL is adding a query analyser tool

MySQL, the open source database branch of Sun Microsystems, has unveiled a new addition to its subscription service known as Query Analyzer.

The tool will allow administrators and developers to review database code for possible errors which could hamper performance.

Rob Young, a senior product manager at MySQL, told vnunet.com that the new tool fixes one of MySQL's more significant shortcomings.

"MySQL is a great database [platform], but it is a bit of a black box when it comes to reporting issues," he explained.

"This is going to be a significant improvement to MySQL to allow developers to identify and tune code."

In order to use the new tool, customers will need to be subscribed to the MySQL service at the gold level or higher. Young said that the new feature will not change the price of any of the subscription services.

Early tests on the system have seen considerable performance increases among beta testers, according to Young.

"Internally we have seen a 30 per cent improvement. It helps people find problematic code in minutes, and eliminates [that] code during the development process," he said.

The latest update to MySQL comes as the company nears the end of its first year under Sun's aegis, and on the eve of what many think could be an increased role for the project.

Young was unable to comment on any matters regarding Sun's recently announced reorganisation, but Sun chief executive Jonathan Schwartz said recently that MySQL is among a handful of open source projects that Sun will be concentrating on.