EmergencyEMERGENCY? Get 24/7 Help Now!

MySQL Performance on Memory Appliance

 | March 31, 2008 |  Posted In: Benchmarks

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 […]

Read More

Using MMM to ALTER huge tables

 | March 27, 2008 |  Posted In: Insight for DBAs

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 […]

Read More

Welcome to the team, Baron

 | March 26, 2008 |  Posted In: Events and Announcements

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 […]

Read More

MySQL 6.0 vs 5.1 in TPC-H queries

 | March 25, 2008 |  Posted In: Benchmarks

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), […]

Read More

MySQL File System Fragmentation Benchmarks

 | March 21, 2008 |  Posted In: Benchmarks

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

How many people will leave MySQL now ?

 | March 21, 2008 |  Posted In: Events and Announcements

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 […]

Read More

Big Iron for tests anyone ?

 | March 20, 2008 | 

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: […]

Read More

Percona’s widely read Percona Data Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.