MySQL Newsletter May 2011

Articles in this newsletter:


New Product Releases

Hints & Tips



Developer Interview: MySQL 5.5: Pluggable Authentication API: Interview with Georgi "Joro" Kodinov

Alex Roedling

In this interview, Georgi "Joro" Kodinov shared the latest enhancements around the Pluggable Authentication API and its benefits.

Read the Interview »

Seminar: Scalability and High Availability with MySQL - EMEA

In this seminar we will explain enhanced features and performance improvements introduced in MySQL 5.5 with benchmark data. We will also cover the new features you can expect in the upcoming MySQL 5.6 release.

Register for the German Seminar in Zürich, Switzerland on May 25 »

Register for the English Seminar in Cambridge, UK on June 10 »

Live Webinar: MySQL Essentials Part 9: Essentials to Securing MySQL

Wednesday, May 25, 2011 - 9:00am PT

In Part 9 of the MySQL Essentials webinar series, you'll learn how to secure your MySQL deployments. Craig Sylvester, Principal Systems Consultant for MySQL, will explore general security issues and present common practices to help you make your MySQL installation more secure against attacks or misuse. Join us for this technical webinar to learn the configurations, setup and tools recommended by the MySQL expert to better secure your MySQL databases!

Register for this Webinar »

Live Webinar: MySQL Cluster: Scaling Web Databases with Auto-Partitioning and SQL/NoSQL

Thursday, May 26, 2011 - 9:00am PT

This webinar will discuss best practices in scaling services on-demand for high volumes of reads and writes, and provide insight on the range of NoSQL and SQL access methods available to developers, specifically covering automatic partitioning (sharding) for high scalability, on-line scaling of the cluster across commodity hardware, as well as SQL and NoSQL interfaces.

Register for this Webinar »

New Product Releases

New Release of MySQL Community Server 5.5.12 (GA)

MySQL 5.5.12 is a new version of the 5.5 production release of the world's most popular open source database. MySQL 5.5.12 is recommended for use on production systems.

MySQL 5.5 includes several high-impact enhancements to improve the performance and scalability of the MySQL Database, taking advantage of the latest multi-CPU and multi-core hardware and operating systems. In addition, with MySQL 5.5, InnoDB is now the default storage engine, delivering ACID transactions, referential integrity and crash recovery by default.

View the Complete List of Changes »

Download Now »

New Release of MySQL Community Server 5.1.57 (GA)

MySQL Community Server 5.1.57, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.57 is recommended for use on production systems.

View the Complete List of Changes »

Download Now »

New Release of MySQL Connector/Net 6.4.0 (Alpha)

MySQL Connector/Net 6.4.0, a new version of the all-managed .NET driver for MySQL has been released. This release is of Alpha quality and is intended for testing and exposure to new features. Version 6.4.0 is intended for use with MySQL versions from 5.0 to 5.5.

Read the Documentation »

Download Now »

Hints & Tips

White Paper: What's New in MySQL 5.5

This white paper provides a look at what's new in MySQL 5.5, including greatly improved performance, scalability, and usability specifically on today's modern, multi-processing hardware, software, and middleware architectures. Sysbench benchmarks demonstrate performance improvements of up to 370% and 540% faster performance on Linux and Windows respectively. Also, new Semi-synchronous Replications and MySQL Performance Schema provide developers and DBAs with improved tools for building high performance, scalable applications.

Read this White Paper » (

White Paper: MySQL Replication - Enhancing Scalability and Availability with MySQL 5.5

MySQL Replication has been widely deployed by some of the leading properties on the web and in the enterprise to deliver extreme levels of database scalability. It provides a simple mechanism for users to rapidly create multiple replicas of their database to elastically scale-out beyond the capacity constraints of a single instance, enabling them to serve rapidly growing database workloads.

Read this White Paper » (

PlanetMySQL Blog Posts

The following blog posts are from PlanetMySQL. PlanetMySQL is an aggregation of blogs and news from MySQL developers, users and employees. It is an excellent source of all things about MySQL, including technical tips and best practices.

Visit PlanetMySQL »

Submit Your Blog Feed »

PlanetMySQL Blog: Partitioning the WordPress Comments Table

Gary Pendergast

WordPress sites can get big. Really big. When you're looking at a site of Cheezburger, Engadget or Techcrunch properties, you get hundreds of comments per post, on dozens of posts per day, which adds up to millions of comments per year.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Benchmark MySQL 5.5.9 on Oracle Sun X7140 M2

Ivan Tu

My colleagues from the Oracle System Practice are very interested in MySQL performance on Oracle Sun x86 servers, so with the help from our VAD partner, we got a Sun X7140 M2 installed in our data center. Thanks for the endeavor form my colleague Cano Lai, the server was setup and ready for testing very soon.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL Development Milestone 5.6.2: Taking MySQL Replication to the Next Level

Mat Keep

A number of significant replication enhancements were released as part of the MySQL 5.5 GA just a few months ago. We are always listening to our customers and the community. And, based on their input, the MySQL engineering team has continued to rapidly evolve replication functionality - enabling new classes of applications to rely on MySQL for their fastest growing and most dynamic web services.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Using MySQL 5.6 to find queries creating disk temporary tables

Alexander Rubin

In MySQL 5.6, we can use new performance_schema table events_statements_history or events_statements_history_long to find all performance metrics for all queries including created disk/memory tables, use of index, etc. WOW! This is what I have been waiting for a long time!

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: InnoDB Persistent Statistics Save the Day

Øystein Grøvlen

In my previous blog posting, I explained how I was able to get more stable query execution times by increasing the amount of sampling used to by InnoDB to calculate statistics. However, for my example query, Query 8 of the DBT-3 benchmark, the MySQL Optimizer still toggled between three different indexes to use when accessing one of the 8 tables.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Feature Preview: The Multi-Threaded Slave

Luis Soares

The MySQL replication team has come up with a feature that looks very promising for improving slave scalability.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Crash-Safe Slaves

Mats Kindahl

A common request is to have replication crash-safe in the sense that the replication progress information always is in sync with what has actually been applied to the database, even in the event of a crash. Although transactions are not lost if the server crashes, it could require some tweaking to bring the slaves up again.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Memcached Server for MySQL Cluster ... When to Cache

John David Duncan

I had a great time introducing the new memcached API for MySQL Cluster in April. There is an interesting question about how you might use the new API: should you turn the cache off, so that the memcached server is just an easy-to-use, high performance NoSQL gateway to the data stored in the cluster? Or should you enable caching in memcached? The memcached server - actually the NDB engine plugin in the server - allows either. In fact you can tune this on the basis of a key prefix, so that some keys are cached and others are not. But how would you make the choice?

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: MySQL Cluster Benchmark

Mikael Ronstrom

We had the opportunity to use a fair amount of machines to run a benchmark to see what throughput MySQL Cluster can achieve on a bit bigger clusters. The benchmark we use is a benchmark we developed for internal testing many years ago and shows very well the performance aspects of MySQL Cluster.

Read the PlanetMySQL BlogPost »

Read the Result - MySQL Cluster doing 6.82M reads per second »

Read the Result - MySQL Cluster running 2.46M updates per second »

PlanetMySQL Blog: MySQL Performance: 5.6.2 and Performance Schema

Dimitri Kravtchuk

Last year I've published a post about Performance Schema overhead which involved many e-mail discussions and finally resulted in a massive code improvements in MySQL Performance Schema (P_S) released by Marc Alff. Marc made an enormous work to redesign P_S code and made P_S overhead "manageable" by user.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: EVENTs - The hidden MySQL 5.1+ feature

Anders Karlsson

MySQL 5.1 and up has EVENTs, but this features seems to be little used. I started using them some time ago, and once I was using them, I found them more and more useful.

Read the PlanetMySQL BlogPost »

PlanetMySQL Blog: Replication and load balancing mysqlnd plugin for all PHP MySQL extensions released

Ulf Wendel

Replication is as old as life on earth. No life without replication. MySQL replication is as old as MySQL, almost. No MySQL without replication. The PECL/mysqlnd_ms 1.0.0 alpha release is brand new. My dream: no PHP without the mysqlnd library replication and load balancing plugin, which works with all the PHP MySQL extensions (mysql, mysqli, PDO_MySQL)!

Read the PlanetMySQL BlogPost »


Live Webinar: Delivering Scalable and Highly Available Session Management with MySQL Cluster

Tuesday, May 31, 2011 - 9:00am PT

As organizations seek to enhance their users' web experience through personalization based on historic browsing and buying behaviors, session data is becoming more critical. Larger volumes of session data need to be managed and persisted in real-time, and so session management has become increasingly performance-intensive, while also demanding very high levels of availability to ensure a seamless customer experience. In these scenarios, it makes sense to evaluate the MySQL Cluster database. This is a practical session and we will demonstrate how to manage PHP session data with MySQL Cluster.

Register for this Webinar »

On-Demand Webinar: MySQL Essentials Part 8: MySQL Server and SQL Performance Tuning

In this webinar, you'll gain tips and tricks to optimally architect your database for highest performance. You'll learn from the MySQL performance pros what they do, step by step, to design and optimize a database server for maximal performance and scalability. We will discuss the main performance optimization possibilities and practices, including index selection and tuning, SQL code techniques, schema optimization, and more.

Register for this Webinar »

On-Demand Webinar: MySQL Enterprise Hot Backup for Your Products

Online backup has consistently been one of the most requested features for MySQL by ISVs and OEMs. With MySQL Enterprise Backup, your developers and customers now have tools to safely and rapidly backup and restore MySQL Embedded database without interrupting your application. In this technical webinar we will review and compare MySQL Enterprise Backup's full, incremental, partial, and compressed backups that allow you to perform consistent Point-in-Time Recovery.

Register for this Webinar »

More free MySQL webinars are scheduled and added between each Newsletter edition, so visit our website frequently for the most updated information.

View the full list of webinars »

Want to receive the latest MySQL updates and interact with the MySQL community?

Read Oracle's MySQL Blog »

Join MySQL on Facebook »

Follow MySQL on Twitter »

Want to evaluate the advanced capabilities in the MySQL Enterprise Edition?

Try Now with MySQL Enterprise Edition Trial »