Oracle has released a new version of MySQL Enterprise, an offering of production support, monitoring tools, and MySQL database software.
The new offering includes MySQL Enterprise Monitor 2.2 that delivers enhanced query performance monitoring, improved security and time-saving integration with MySQL Support. It also helps organisations manage MySQL servers and reduce downtime by identifying problems, the company said.
Oracle said that MySQL Enterprise Monitor 2.2 provides enhancements for collecting, searching and viewing query performance data, allowing developers to filter and analyse patterns that may hinder key system resources.
According to Oracle, new features of MySQL Enterprise Monitor 2.2 include, Query Analyser Execution Notices that pinpoint problem queries allowing DBAs and developers to find and fix performance problems; and MySQL Enterprise Connector Plug-ins to an application’s existing connector. It allows users to gather and send SQL and related performance data to the query analyser.
The company said that users can also track SQL errors and warnings; end user response times; query execution times and counts; and with a single click go directly to the offending query in the source code, the company said.
In addition, the new offering includes enhancements such as, integration with existing LDAP authentication and commonly accepted security models; integration with MySQL support; usability enhancements; and advisor rules and graphs.
Tomas Ulin, director of MySQL development at Oracle, said: MySQL Enterprise Spring 2010 Release offers powerful tools for query performance monitoring, improved security and an enhanced administration experience – all of which help alleviate many common pain points DBAs and developers face when building, maintaining and scaling web applications.”
