MySQL Performance Blog

Recently I have had a chance to check out MySQL Performance on “Memory Appliance” by Violin Memory which can be used as extremely high speed storage system.

I helped Violin Memory to optimize MySQL for customer workload and Violin memory and also had a chance to do some benchmarks on my own. 2*Quad Core Xeon running CentOS5 was tested using ext2 filesystem and SysBench tool.

Using 16K read sizes (matches Innodb page size) I could get 1.2GB/sec (80K req/sec) for reads and about 500MB/sec writes with 16 concurrent threads. Things scaled well and with 256 threads I got even a bit better performance.

Interesting enough utilization in iostat never went over few percents and load was mostly CPU bound.
[read more...]

Few months ago, I wrote about a faster way to do certain table modifications online. It works well when all you want is to remove auto_increment or change ENUM values. When it comes to changes that really require table to be rebuilt - adding/dropping columns or indexes, changing data type, converting data to different character set - MySQL master-master replication especially accompanied by MMM can be very handy to do the changes with virtually no downtime.
[read more...]

As you may have seen from his blog, Baron Schwartz is joining our consulting company - Percona in less than a week. This is exciting news for us as Baron is renowned MySQL community member, blogger, co-author of High Performance MySQL second edition book, author of Maatkit and Innotop and just a great guy.

Welcome Baron - We’re proud to have you onboard.

So if you always wanted to hire Baron to take a look at your system and help you with high availability scaling optimization or other needs you can do it now by filling out our consulting request form

Reading Martens interview we see the quite:

“As soon as the deal closed we immediately secured a big deal with a major European national police agency,” said Mickos, now SVP database products at Sun. “Key to them choosing MySQL was that we are now part of a much larger public corporation. The deal wouldn’t have happened when we were private.”

Cool stuff! But I’m wondering how much the opposite applies as well - this would leave small companies to seek for other ways to get the service they need ?
[read more...]

MySQL made some tasks from their internal task tracking tool - Worklog a while back. I just have not look at it besides checking Maria related tasks until couple of days ago as Jay announced new Forge going live.
Check it out - there are a lot of nice ideas out where. I can find a lot of things I originally submitted something like 5 years ago out there

I contributed most ideas during my first years at MySQL, some on my own some reformed customer suggestions from Sales/Support/Consulting engagements I was on. Later I practically stopped because there were not much attention to those small little convenience things - MySQL was on the road to take over enterprise market and all resources were focused on big things which allow to sell things to these customers.
[read more...]

Last week I played with queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, as there is a lot of new changes in optimizer, which should affect execution plan of TPC-H queries. In reality only two queries (from 22) have significantly better execution time (about them in next posts), but I want to write about is queries that execute slower in new MySQL 6.0 version.
[read more...]

Few days ago I wrote about testing writing to many files and seeing how this affects sequential read performance. I was very interested to see how it shows itself with real tables so I’ve got the script and ran tests for MyISAM and Innodb tables on ext3 filesystem. Here is what I found:

[read more...]

During the recent days we had few announcements of people leaving Sun/MySQL - few days ago I’ve seen announcement by Ronald Bradford and now I see Antony Curtis followed. I know bunch of other guys which are considering to leave or stay.

I do not surprising - how much “better” Sun is compared to Microsoft or Oracle it is still huge corporation and some people just do not like to be small wheels spinning in the huge engine. As for me MySQL became too big couple of years ago so I left MySQL early.
[read more...]

MySQL Users Conference is coming and with it my presentation about Innodb Scalability limits. We did bunch of tests but we surely could get benefit of some extra hardware for testing, so if you could provide us with dedicated remote access for benchmarks it would be great.

Here is what we’re looking for in particular:

- More than Dual Core Opteron systems. Would be good to see how they scale
- More than 8 core systems
- Non x86 based systems (Niagara etc)
- Fancy IO subsystem - more than 8 hard drives
- SSD based storage.

If you have something of this sort available let me know.

Commenting on my previous post on MySQL Query Cache Gerry pokes me as I’m all wrong and both comments and whitespace are fixed in MySQL 5.0. This was not what I remember seeing in production so I decided to do some tests on the matter:

[read more...]