Sun has added a query analysis tool to MySQL Enterprise, its subscription-based service for the open-source MySQL database. The new tool will aid users in tracking and fixing problematic code and performance issues.

The tool allows users to perform real-time analysis of "all queries across all servers," as well as search and sort them according to metrics such as content, date/time and query type, according to Sun.

MySQL users can already investigate poor query performance through the database's "slow query" log, but the new tool makes the process much more efficient, said Rob Young, senior product manager for MySQL Enterprise.

One analyst said the tool is a welcome addition to the service, but not groundbreaking.

"MySQL Query Analyzer is just one of many ways in which MySQL is playing catch-up with more mature DBMS products," said Curt Monash, founder of Monash Research. "It should be helpful to smaller enterprises that do their reporting on MySQL."

The tool has been integrated with MySQL Enterprise Monitor, which helps database administrators track the health of their servers.

Subscribers to the MySQL Enterprise service get monthly software updates, service packs each quarter and "emergency hot fix builds," as well as 24-7 support.

The updated service is scheduled to be available within a month. Pricing ranges from US$599(£370) to $4,999(£3,070) per server per year, or as an "unlimited site-wide agreement" that starts at $40,000 per year. Sun is also offering free 30-day trial subscriptions.

Sun, which announced it was laying off up to 6,000 employees last week, is banking increasingly on software assets like MySQL as its high-end server business continues to struggle.