Jennifer Glore

Yesterday was the official product launch for MySQL 5.1, which was a follow-up to the actual GA of MySQL 5.1 that released on November 26th.  The official product launch brought updated websites, documentation, interviews, and other items to help people come up to speed with the new release. 

For those that don't know, MySQL 5.1 includes new enterprise features and enhancements that will allow DBAs to manage very large data sets and increase performance of their large-scale enterprise applications.  This version of the software now includes:

• table and index partitioning to help boost performance and simplify data management
• row-based and hyrbid replication for safe and quick replication options
• MySQL Event Scheduler to schedule and automate SQL tasks

Additionally, Query Analyzer, which was released in the MySQL Enterprise Fall 2008 Release, helps DBAs monitor MySQL performance using MySQL Enterprise Monitor.  The Query Analyzer identifies and analyzes problem SQL code across all servers in an environment -- providing more information than the slow query log and aggregating all the data in one central location.  With the collected information, developers and DBAs can analyze performance problems and optimize / tune the database and applications accordingly.  See my earlier blog post on the subject, which has a link to a Query Analyzer demo. Also, you can listen to Rob Young's radio interview here on Query Analyzer.  This is a very cool tool that will dramatically help DBAs with performance issues.

Info about MySQL 5.1 is now live at dev.mysql.com, also:

• MySQL 5.1 Whitepaper - www.mysql.com/quicklinks/whitepapers/whatsnew_51.html
• MySQL 5.1 On-Demand Webinar - ww.mysql.com/quicklinks/webinars/mysql-51.html

Info on Query Analyzer is available at http://www.mysql.com/products/enterprise/query.html.

Additionally, register for the December 11th webinar "MySQL 5.1 - Partitioning, Row-based Replication and more" here.