Effective MySQL New York

Reasons to use MySQL 5.5

June 24, 2011 · 6:30 PM
Meetup.com Offices

Presentation:

This month we will be discussing both the reasons to consider upgrading MySQL to the current GA release and the techniques for a successful upgrade.
There are a number of significant new features in MySQL 5.5 including semi-synchronous replication, SIGNAL and RESIGNAL, the PERFORMANCE_SCHEMA, additional STATUS variables, new partitioning options, different default storage engine, better UTF8 support and removal of deprecated functions just to list key considerations.

However some of the performance improvements are worth the investment of time. For a high concurrency InnoDB environment one new configuration alone can provide a 50% improvement in performance. Other settings can help in the reduction of downward spikes in performance due to internal InnoDB disk management. Some new configuration settings are off by default. See the actual benefits of these new features and what you should be using to maximize your database performance.

Agenda:

6:30 - Arrive to Meetup HQ, meet other members

6:35 - Beer and Pizza courtesy of Meetup.com

6:45 - Event starts
7:00 - Presentation Starts
8:00 - Q&A
8:30 - Open Discussion, Networking

Join or login to comment.

Sergey Chernyshev

Ronald was amazing as always and network discussion was great too.

0 · June 27, 2011
Joe Kondel

Great speaker, knowledgeable crowd, and as usual intereting discussions post-talk.

0 · June 25, 2011