MySQL Enterprise major update add query analysis tool

BKJIA comprehensive report] Sun announced a major version update for the MySQL Enterprise subscription service. Sun has added a Query and analysis tool MySQL Query Analyzer for the MySQL Enterprise Edition to help track and analyze problem codes, solve performance problems and help users significantly increase the speed and running time of MySQL database applications.

The latest MySQL Query Analyzer is a powerful Propeller for MySQL applications. It allows DBAs and developers to locate a problematic database Query in a matter of minutes and actively adjust the program code, avoid slowing down the system performance. This tool allows you to perform real-time analysis on all queries on the server. According to Sun, the analysis is like executing a query, sort the date, time, and query type.

Features of MySQL Query Analyzer include: centralized view of the number of queries executed by multiple MySQL systems, execution time, and Result Set; classified view of all monitoring statistics; the user can query data based on the type, content, server, database, date/time, interval, and "time of first view". Historical and real-time analysis of all queries on each server; you can thoroughly view the selected query statistics, assign all variable replacement values, and explain the results.

Although MySQL users can now use the "slow query)" log to find queries with poor performance, this new tool makes searching for slow SQL more efficient, said Rob Young, senior product consultant for MySQL Enterprise.

"MySQL query analyzer is just one of the strategies MySQL plans to catch up with mature RDBMS products, it should be very helpful for small enterprises to make reports on MySQL ".

This tool has been integrated into MySQL Enterprise Monitor, which helps database administrators track the health status of databases. The purchaser of the MySQL Enterprise Service can obtain the software upgrade service once a month, and it also supports hours.

According to the plan, the upgrade service will be available within one month. The execution price ranges from 599 to 4999 USD/server per year. If you want a full-site service, the lowest price is 40000 USD per year, sun also provides a 30-day free trial reservation.

1. Sun introduces a new MySQL System and Storage Solution
2. Sun announced the launch of server-specific MySQL Solutions
3. Sun's split dilemma insiders said they would not give up MySQL