You are here

MySQL Performance Blog

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

Subscribe to MySQL Performance Blog

Percona Team presentations from MySQL Users Conference 2008 published

MySQL Performance Blog - Thu, 01/05/2008 - 3:08am

If you’ve missed our presentations on MySQL Users Conference you can catch up now by taking a look at the slides, which are now published in presentations section of our company web site. You can also find a lot of old presentations in the same location.

Enjoy !

Entry posted by peter | No comment

MySQL Replication vs DRBD Battles

MySQL Performance Blog - Tue, 29/04/2008 - 3:50am

Well these days we see a lot of post for and against (more, more) using of MySQL and DRBD as a high availability practice.

The MySQL optimizer, the OS cache, and sequential versus random I/O

MySQL Performance Blog - Tue, 29/04/2008 - 2:18am

In my post on estimating query completion time, I wrote about how I measured the performance on a join between a few tables in a typical star schema data warehousing scenario.

In short, a query that could take several days to run with one join order takes an hour with another, and the optimizer chose the poorer of the two join orders. Why is one join order so much slower than the other, and why did the optimizer not choose the faster one? That's what this post is about.

How multiple disks can benefit for single client workload ?

MySQL Performance Blog - Sun, 27/04/2008 - 6:01am

Let us talk few more about disks. You might have read my previous post and Matt’s Reply and it looks like there are few more things to clarify and explain.

Is disk Everything for MySQL Performance ?

MySQL Performance Blog - Fri, 25/04/2008 - 7:20am

I read very nice post by Matt today and it has many good insights though I can’t say I agree on all points.

MySQL Architecture meeting at Google

MySQL Performance Blog - Fri, 25/04/2008 - 6:20am

Friday after MySQL Users Conference we had a smaller meeting at Google campus to talk about MySQL architecture mainly focusing on storage engine vendors and other extension areas.

MySQL extensions for hosting

MySQL Performance Blog - Thu, 24/04/2008 - 10:59am

A few weeks ago I was asked to isolate some functionalities from Mark Callaghan’s MySQL patch bundle. They were extensions adding per-user and per-table accounting to the database, accessible with a new set of commands such as SHOW TABLE_STATISTICS, SHOW INDEX_STATISTICS and SHOW USER_STATISTICS. The first two can interest anyone to periodically check what data or which index are the most active or which are not being used at all and could be candidates for dropping.

Efficient Boolean value storage for Innodb Tables

MySQL Performance Blog - Thu, 24/04/2008 - 6:25am

Sometimes you have the task of storing multiple of boolean values (yes/now or something similar) in the table and if you get many columns and many rows you may want to store them as efficient way as possible.
For MyISAM tables you could use BIT(1) fields which get combined together for efficient storage:

Conference for MySQL Users

MySQL Performance Blog - Thu, 24/04/2008 - 5:28am

If you're following PlanetMySQL you've already seen Baron's post about MySQL Conference which many of us just have returned from.

Real-Life Use Case for “Barracuda” InnoDB File Format

MySQL Performance Blog - Wed, 23/04/2008 - 9:28pm

In one of his recent posts Vadim already gave some information about possible benefits from using new InnoDB file format but in this post I’d like to share some real-life example how compression in InnoDB plugin could be useful for large warehousing tasks.

Testing InnoDB “Barracuda” format with compression

MySQL Performance Blog - Wed, 23/04/2008 - 4:53pm

New features of InnoDB - compression format and fast index creation sound so promising so I spent some time to research time and sizes on data we have on our production. The schema of one of shards is

How to estimate query completion time in MySQL

MySQL Performance Blog - Wed, 23/04/2008 - 1:41am

Have you ever run a query in MySQL and wondered how long it'll take to complete? Many people have had this experience. It's not a big deal until the query has been running for an hour. Or a day and a half. Just when IS that query going to finish, anyway?

There are actually a few ways to estimate how long it'll take for the query to complete, depending on what the query is. One of the simplest is to estimate how many rows the query needs to examine, measure how fast it's working, and do the math.

MySQL and plugin binaries

MySQL Performance Blog - Mon, 21/04/2008 - 6:05am

It seems there is interesting problem with compatibility of MySQL binaries and binaries of third-party plugins.

I personally found and there is confirmation from InnoDB team that current InnoDB-plugin binaries do not work with lastest 5.1.24-rc binaries. It was very charming move from MySQL side to release new incompatible binary on the second day after the announce of InnoDB plugin. I do not think it was intentional, but still looks funny and shows broken communication between teams.

Updated msl (microslow) patch, installation walk-through!

MySQL Performance Blog - Sun, 20/04/2008 - 12:38pm

For a couple of months there have been no updates to our msl patch, however recently I managed some time to change this. The functionality was extended a little bit and what’s even more important the patch is available for all the recent MySQL releases.

Idea: Couple of more string types

MySQL Performance Blog - Fri, 18/04/2008 - 11:43pm

MySQL has a lot of string data types - CHAR, VARCHAR, BLOB, TEXT, ENUM and bunch of variants such as VARBINARY but I think it is not enough :)

All thouse new MySQL Storage Engines

MySQL Performance Blog - Thu, 17/04/2008 - 6:09pm

MySQL Users Conference 2008 has number of Storage Engines presented which claim to Kick Ass. Walking in exhibition hall you could see KickFire, Infobright, Tokutek, ScaleDB. I have not seen NitroDB in the exhibition call this year but they are also worth to mention.
It is interesting to see all of them showing benchmarks with great numbers and glossy marketing materials explaining why they are better.

A note about Pythian

MySQL Performance Blog - Thu, 17/04/2008 - 4:22pm

On Monday I had a chance to have a chat with Paul Vallee from Pythian. This was quite an enlightening talk, and I was very impressed by Paul openness and willing to share with me a lot of internal operations details. I wish there would be more people out where as open and helpful even when it comes to somewhat competing businesses. Though he is of course right - for small companies as we are there is much more business out where which is neither ours nor theirs and by being helpful to each other we can increase part of the pie to share.

Future InnoDB File Formats

MySQL Performance Blog - Wed, 16/04/2008 - 6:59am

Looking into InnoDB docs I found list of names of future InnoDB file formats: Antelope, Barracuda, Cheetah, Dragon, Elk, Fox, Gazelle, Hornet, Impala, Jaguar, Kangaroo, Leopard, Moose, Nautilus, Ocelot, Porpoise, Quail, Rabbit, Shark, Tiger, Urchin, Viper, Whale, X, Y and Zebra.

Aren’t there animals starting on X and Y?

Interested to learn about New Innodb Plugin Performance ?

MySQL Performance Blog - Tue, 15/04/2008 - 6:21pm

As you probably have already heard Innodb Announced new Plugin version for MySQL 5.1 So now you can see Heikki and the Team were not just doing only bug fixes for last two years, but rather kept very quite.

Partially OpenSourced

MySQL Performance Blog - Tue, 15/04/2008 - 9:54am

Reading evening news and rss feeds I found interesting next sequence:

Jeremy’s post “MySQL to launch new features only in MySQL Enterprise

basically about some new features of MySQL will be available only for paid customers

MySQL Optimizer team comments on TPC-H Results

MySQL Performance Blog - Mon, 14/04/2008 - 7:00pm

Yesterday I had a chance to speak to Igor - head of MySQL optimizer team and Timur - both of them expressed concern with TPC-H run results I posted and notes about little gains in MySQL 6.0.

MySQL Community Dinner

MySQL Performance Blog - Mon, 14/04/2008 - 6:02pm

Yesterday we started the conference early with MySQL Community Dinner which was quite a success with about 30-50 people showing up (hard to count as people come and go) even though it was conflicting with Silicon Valley MySQL Meetup and which at least prevented Jeremy and his team showing up.

Meet MySQL Performance Blog guys on MySQL Users Conference

MySQL Performance Blog - Mon, 14/04/2008 - 4:53pm

Percona, the company maintaining MySQL Performance Blog has a good presence on the conference this year. We have me (Peter), Vadim, Aurimas, Baron and Andrew attending the show.

TPC-H Run on MySQL 5.1 and 6.0

MySQL Performance Blog - Thu, 10/04/2008 - 10:22pm

We were doing MySQL Performance evaluation on TPC-H queries for the client and they kindly allowed us to publish results which are very interesting.
This is obviously not audited TPC-H run, and it can’t be because we used MyISAM tables which are not ACID complaint. Plus we only measured Power to keep things simple.

State of MySQL Market and will Replication live ?

MySQL Performance Blog - Thu, 10/04/2008 - 6:58am

There are interesting posts these day about future of MySQL Replication by Brian Frank and Arjen.


Subscribe to MySQL Performance Blog