EmergencyEMERGENCY? Get 24/7 Help Now!

Should you move from MyISAM to Innodb ?

 | January 12, 2009 |  Posted In: Insight for DBAs

There is significant portion of customers which are still using MyISAM when they come to us, so one of the big questions is when it is feasible to move to Innodb and when staying on MyISAM is preferred ? I generally prefer to see Innodb as the main storage engine because it makes life much […]

Read More

AUTO_INCREMENT and MERGE TABLES

 | September 11, 2008 |  Posted In: Insight for DBAs

How would you expect AUTO_INCREMENT to work with MERGE tables ? Assuming INSERT_METHOD=LAST is used I would expect it to work same as in case insertion happens to the last table… which does not seems to be the case. Alternatively I would expect AUTO_INCREMENT to be based off the maximum value across all tables, respecting […]

Read More

Can you Trust CHECK TABLE ?

 | September 11, 2008 |  Posted In: Insight for DBAs

Take a look at this:

The sort order is obviously wrong while CHECK TABLE is not reporting any error

Read More

ANALYZE: MyISAM vs Innodb

 | September 3, 2008 |  Posted In: Insight for DBAs

Following up on my Previous Post I decided to do little test to see how accurate stats we can get for for Index Stats created by ANALYZE TABLE for MyISAM and Innodb. But before we go into that I wanted to highlight about using ANALYZE TABLE in production as some people seems to be thinking […]

Read More

Beware of MyISAM Key Cache mutex contention

 | August 12, 2008 |  Posted In: Insight for DBAs

Today I was working with the client loading data to MyISAM tables at very high rate. Hundreds of millions rows are loaded daily into single MySQL instance with bursts up to 100K of records/sec which need to be inserted (in the table with few indexes). It was good not all records had to go to […]

Read More

Concurrent inserts on MyISAM and the binary log

 | May 14, 2008 |  Posted In: Insight for DBAs

Recently I had an interesting surprise with concurrent inserts into a MyISAM table. The inserts were not happening concurrently with SELECT statements; they were blocking and the process list was filling up with queries in Locked status. My first thought was that the customer had deleted from the table, which leaves “holes” in the middle […]

Read More

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

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

Enum Fields VS Varchar VS Int + Joined table: What is Faster?

 | January 24, 2008 |  Posted In: Benchmarks

Really often in customers’ application we can see a huge tables with varchar/char fields, with small sets of possible values. These are “state”, “gender”, “status”, “weapon_type”, etc, etc. Frequently we suggest to change such fields to use ENUM column type, but is it really necessary (from performance standpoint)? In this post I’d like to present […]

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.