You are here

MySQL Performance Blog

MySQL Performance Blog
Checked: 2 hours 19 min ago
Updated: 2 hours 19 min ago
Update every: 2 hours

Subscribe to MySQL Performance Blog

Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB

MySQL Performance Blog - Wed, 17/12/2008 - 2:34am

Today we officially announce our new storage engine, "Percona XtraDB", which is based on the InnoDB storage engine. It's 100% backwards-compatible with standard InnoDB, so you can use it as a drop-in replacement in your current environment. It is designed to scale better on modern hardware, and includes a variety of other features useful in high performance environments.

SHOW OPEN TABLES - what is in your table cache

MySQL Performance Blog - Sun, 14/12/2008 - 11:54pm

One command, which few people realize exists is SHOW OPEN TABLES - it allows you to examine what tables do you have open right now:

Looking for MySQL 4.0 Support post EOL ?

MySQL Performance Blog - Sun, 14/12/2008 - 8:07pm

As Giuseppe just reminded MySQL 4.0 is reaching its end of life in about 2 weeks from now. When it becomes unsupported by MySQL together with 3.23 version.

At Percona we do not have such restriction and we will continue to support your environment even if you’re still on MySQL 4 or 3.23 (we indeed do have customers which are still using 3.23 now)

MySQL QA Team Benchmarks for MySQL 5.1.30

MySQL Performance Blog - Sun, 14/12/2008 - 6:16am

As you might have seen MySQL QA Team has published their benchmarks for MySQL 5.0.72 and 5.1.30.

It is interesting to compare with results I posted previously

The quote from the results mentioned above:

MySQL Binaries Percona build10

MySQL Performance Blog - Fri, 12/12/2008 - 3:31am

We made new binaries for MySQL 5.0.67 build 10 which include next fixes:

  • We addressed concerns about potential logging and statistics overhead, so now you can fully turn on / off query statistics for microslow patch and user statistics in runtime.

Next variables were added:

7 Reasons why MySQL Quality will never be the same

MySQL Performance Blog - Thu, 11/12/2008 - 3:34am

I had a call with Monty the other day and I told him why I think MySQL Server Quality will never be the same again. I’ve been thinking a bit more about it and here is the extended list.

MySQL 5.1 went to GA. Was it a good move ?

MySQL Performance Blog - Thu, 11/12/2008 - 1:39am

MySQL 5.1 release as “GA” seems to be the most controversial to date. It had very negative response from Monty, original MySQL Founder and controversial responses in community including another beating by Kevin Burton.

There is also very interesting reading on MySQL 5.1 open bugs

Reading MySQL Enterprise future…

MySQL Performance Blog - Tue, 09/12/2008 - 7:35am

Well, actually it is not reading future, but just mysql-5.1.30.rhel4.spec file from MySQL RedHat 4 SRPM.

I found there few MySQL Enterprise Editions, namely:

MySQL Enterprise Server - Advanced Edition
MySQL Enterprise Server - Pro Edition
MySQL Enterprise Server - Classic Edition

What is difference ? Let’s see.

For MySQL Enterprise Server - Advanced Edition:
%define INNODB_BUILD 1

Percona team at Turkey

MySQL Performance Blog - Mon, 08/12/2008 - 7:26am

Being completely distributed team, meetings are very important for us and this time we went to the Turkey in the end of October (yes, yes I could be faster with sharing photos)

Percona, Turkey 2008

This went we went to Turkey, Antalya region, which is a destination which is very easy to reach from Europe as well as offering great all inclusive deals in the end of the season.

When to use Hardware upgrade instead of Software Optimization

MySQL Performance Blog - Fri, 05/12/2008 - 10:25pm

One typical question which frequently pops up is whenever it is better to use hardware upgrade or optimize software more. I already wrote about it, for example here.

Today I’ll look at the same topic from the consultants view. When consultant should suggest hardware upgrade and when it is not in a simple checklist form.

Tom Basil (formerly MySQL’s Director of Support) Joins Percona

MySQL Performance Blog - Thu, 04/12/2008 - 4:41pm

Percona has a new Chief Operating Officer! It is Tom Basil, who was Employee #11 at MySQL and led the Support organization there for almost eight years. He was the founding Director of Support at MySQL, and built it into a team of about 60 people all across the world. Tom was legendary as a manager at MySQL, and we’re really looking forward to his experience at Percona.

MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency

MySQL Performance Blog - Thu, 04/12/2008 - 6:00am

We’ve recently done benchmarks comparing different MySQL versions in terms of their CPU efficiently in TPC-C like Workload. We did it couple of weeks ago so MySQL 5.0.67, MySQL 5.1.29 and Innodb Plugin 1.0.1 were used which are not very recent, though we do not think results will differ a lot with today versions.

Results are as follows:

MySQL 5.0, 5.1, Innodb Plugin, TPC-C

Computing 95 percentile in MySQL

MySQL Performance Blog - Sat, 29/11/2008 - 6:21am

When doing performance analyzes you often would want to see 95 percentile, 99 percentile and similar values. The "average" is the evil of performance optimization and often as helpful as "average patient temperature in the hospital".

Lets set you have 10000 page views or queries and have average response time of 1 second. What does it mean ? Really nothing - may be one page view was 10000 seconds and the rest was in low milliseconds or may be you had every single page view taking 1 second, which are completely different.

MySQL for Hosting Providers - how do they manage ?

MySQL Performance Blog - Fri, 28/11/2008 - 10:24pm

Working with number of hosting providers I always wonder how do they manage to keep things up given MySQL gives you so little ways to really restrict how much resources single user can consume. I have written over a year ago about 10+ ways to crash or overload MySQL and since that people have come to me and suggested more ways to do the same.

A quick way to get memcached status

MySQL Performance Blog - Thu, 27/11/2008 - 2:32am

There are all sorts of different interfaces to memcached, but you don't need any of them to make requests from the command line, because its protocol is so simple. Try this, assuming it's running on the usual port on the local machine:

Thanks Giving Challenge: How to detect replication context

MySQL Performance Blog - Thu, 27/11/2008 - 1:31am

Happy Thanksgiving and little holiday challenge for you.
Say you have a trigger on the slave which you would like to work differently, depending on whenever update is executed via replication thread vs updating table locally ? This can be helpful for example for auditing updates which were done directly instead of coming from the master and some other cases.
Suggest how you would do it by commenting :)

Using Multiple Key Caches for MyISAM Scalability

MySQL Performance Blog - Wed, 26/11/2008 - 8:19am

I have written before - MyISAM Does Not Scale, or it does quite well - two main things stopping you is table locks and global mutex on the KeyCache.

How Percona does a MySQL Performance Audit

MySQL Performance Blog - Tue, 25/11/2008 - 4:42am

Our customers or prospective customers often ask us how we do a performance audit (it's our most popular service). I thought I should write a blog post that will both answer their question, so I can just reply "read all about it at this URL" and share our methodology with readers a little bit. This fits well with our philosophy of openness. It also shocks people sometimes -- "you're giving away the golden goose!" Not really. What you hire us for is our experience, not a recipe that anyone can follow.

Using INFORMATION_SCHEMA instead of shell scripting

MySQL Performance Blog - Tue, 25/11/2008 - 4:16am

INFORMATION_SCHEMA, in particular by favorite TABLES table is not only helpful to understand tables you have on the system, but I have also found it to be very helpful as a scripting language for variety of database administration tasks. It can be more straightforward compared to using shell or Perl when the operation is database specific.

For example if you would like to MySQLDump only Innodb table in one file per database you can do the following:

How to calculate a good InnoDB log file size

MySQL Performance Blog - Fri, 21/11/2008 - 2:52pm

Peter write a post a while ago about choosing a good InnoDB log file size.  Not to pick on Peter, but the post actually kind of talks about a lot of things and then doesn't tell you how to choose a good log file size!  So I thought I'd clarify it a little.

The patches are going to Launchpad

MySQL Performance Blog - Wed, 19/11/2008 - 6:42pm

After some discussions on the OpenSQLCamp 2008 conference we decided to move our development to Launchpad, to be in stream with other MySQL related projects.

We published our patches there, it is supposed to be main repository for the patches.

We advise to use Launchpad bug system to report bugs and also for feature requests.

Adaptive checkpointing

MySQL Performance Blog - Thu, 13/11/2008 - 1:50pm

Do you know that there are two limits about dirty (modified but not flushed to disk) blocks of InnoDB buffer pool? One is the limit of “amount”. The other is the limit of “age”.

– limit of “amount” –

New SpecJAppServer results at MySQL and Sun.

MySQL Performance Blog - Thu, 13/11/2008 - 5:04am

As you likely have seen Sun has posted the new SpecJAppServer Results More information from Tom Daly can be found here These results are quite interesting for me as I worked on some of the previous SpecJAppServer Benchmarks several years ago while being employed by MySQL.


Subscribe to MySQL Performance Blog