MySQL Performance Optimizations

You might be wondering what's been happening with MySQL performance since Sun arrived on the scene. The good news is that we haven't been idle. There's been general recognition that MySQL could benefit from some performance and scalability enhancements, and Sun assembled a cross-organizational team immediately after the acquisition to get started on it. We've enjoyed excellent cooperation between the engineers from both organizations.

This kind of effort is not new for Sun - we've been working with proprietary database companies on performance for years, with source code for each of the major databases on site to help the process. In this case, the fact that the MySQL engineers are working for the same company certainly simplifies a lot of things.

If you'd like to get some insight into what's been happening, a video has just been posted online that features brief interviews with some of the engineers involved in various aspects of the exercise.

There are also screencasts available that offer a brief Introduction to MySQL Deployments, some basic pointers on Tuning and Monitoring MySQL, and a bit of a look at Future Directions for MySQL Performance. Other videos that might be of interest are also available at http://www.sun.com/software/.

The obvious question is when customers are going to see performance improvements in shipping releases. Actually, it's already happened. One example is a bug fix that made it into MySQL 5.1.28 and 6.0.7. The fix makes a noticeable difference to peak throughput and scalability with InnoDB. And that's only the beginning. You can expect to see a lot more in the not-too-distant future. Watch this space!

Comments:

Great news, but I would rather read than watch. Can we get written descriptions in place of videos?

Posted by Mark Callaghan on November 06, 2008 at 03:47 AM PST #

Hi Mark,
I take your point. We need to blog more than we have been. Check out the
following:
http://blogs.sun.com/dlutz/entry/toward_a_more_scalable_mysql
http://blogs.sun.com/realneel/entry/introduction_to_the_innodb_io
http://blogs.sun.com/rainy/entry/why_isn_t_mysql_using
http://blogs.sun.com/wizard/entry/olio_performance_on_t5220
It's a start.
Regards,
Allan

Posted by Allan Packer on November 06, 2008 at 12:38 PM PST #

Don't forget the huge amount of (at first, volunteer) work that Sun employees Brian Aker, Jay Pipes and Monty Taylor have been putting into Drizzle -- which started by taking MySQL 6.0 and patching it by removing and changing and refactoring the code.

It's very highly performant, though not yet available as a release.

Posted by Sheeri K. Cabral on November 07, 2008 at 06:51 AM PST #

@Sheeri -- where are the dbt2 or sysbench results for Drizzle to show the performance improvements? What bottlenecks have been fixed in Drizzle?

@Allan -- I just done like video when text will do. I greatly appreciate the work of the PAE team. I had a huge crisis during our upgrade to MySQL 5.0 when we discovered that one workload was 33% slower in MySQL 5.0 compared to 4.0. The problem was in the parser and no one caught this by 5.0.37. This was followed by a few weeks of intense work to fix the parser. Such problems are no longer possible. Things get caught and fixed quickly now.

Posted by Mark Callaghan on November 07, 2008 at 10:24 AM PST #

Post a Comment:
Comments are closed for this entry.
About

I'm a Principal Engineer in the Performance Technologies group at Sun. My current role is team lead for the MySQL Performance & Scalability Project.

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today