Buy Percona ServicesBuy Now!

Innodb Performance Optimization Basics

 | November 1, 2007 |  Posted In: Insight for DBAs

Note: There is an updated post on this topic here. Interviewing people for our Job Openings I like to ask them a basic question – if you have a server with 16GB of RAM which will be dedicated for MySQL with large Innodb database using typical Web workload what settings you would adjust and interestingly […]

Read More

Managing Slave Lag with MySQL Replication

 | October 12, 2007 |  Posted In: Insight for DBAs

The question I often get is how far MySQL may fall behind and how to keep replication from lagging. The lag you will see will vary a lot from application to the application and from load to load. Plus what is the most important within same application the lag will likely have spikes – most […]

Read More

MySQL Quality of old and new features

 | October 4, 2007 |  Posted In: Insight for DBAs

Recent couple of days our team was pointed to number of bugs in MySQL 5.0 which again seriously shakes the confidence in both MySQL Quality Control and bug fix promptness. Let me just take couple of bugs as examples: Triggers broken with auto-increment columns for Innodb tables (bug 26316). As you can see this bug […]

Read More

Innodb usability and ease of use.

 | September 28, 2007 |  Posted In: Insight for DBAs

It always surprised me how little Innodb team seems to think about product usability/ease of use, when it comes to settings, performance management etc. I could understand many things 5 years ago, like a lot of information being available only in hard to parse SHOW INNODB STATUS output or even uglier hacks with creating tables […]

Read More

InnoDB auto-inc scalability fixed

 | September 26, 2007 |  Posted In: Insight for DBAs

There was long played scalability issue with InnoDB auto-increment field. For details check Bug 16979. In short words the problem is in case of insert into table with auto-increment column the special AUTO_INC table level lock is obtained, instead of usual row-level locks. With many concurrent inserted threads this causes serious scalability problems, and in […]

Read More

MySQL: what read_buffer_size value is optimal ?

 | September 17, 2007 |  Posted In: Benchmarks, Insight for DBAs

The more I work with MySQL Performance Optimization and Optimization for other applications the better I understand I have to less believe in common sense or common sense of documentation writers and do more benchmarks and performance research. I just recently wrote about rather surprising results with sort performance and today I’ve discovered even read_buffer_size […]

Read More

InnoDB in self-compiled MySQL 5.1

 | September 13, 2007 |  Posted In: Insight for DBAs

If you like to compile MySQL from sources by yourself, for different needs, like debugging, testing etc, you probably can face this issue. What I usually do to fast compile and test is

and then, for example, load the dump of InnoDB from previous version:

I bet you will not notice all your […]

Read More