Buy Percona ServicesBuy Now!

Webinar: MyISAM to InnoDB migration

 | November 8, 2010 |  Posted In: Events and Announcements, MySQL

Register now for a free Percona webinar about migrating your MyISAM databases to InnoDB. Save the date: Dec 1, 2010 at 9:00 AM PST (California) time. Update: the date was originally listed as December 2nd, but that was a mistake. It’s December 1st. We know that not everyone can attend expensive conferences that require travel. […]

Read More

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

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

MyISAM Scalability and Innodb, Falcon Benchmarks

 | October 12, 2007 | 

We many times wrote about InnoDB scalability problems, this time We are faced with one for MyISAM tables. We saw that several times in synthetic benchmarks but never in production, that’s why we did not escalate MyISAM scalability question. This time working on the customer system we figured out that box with 1 CPU Core […]

Read More

InnoDB vs MyISAM vs Falcon benchmarks – part 1

 | January 8, 2007 |  Posted In: Benchmarks

Several days ago MySQL AB made new storage engine Falcon available for wide auditory. We cannot miss this event and executed several benchmarks to see how Falcon performs in comparison to InnoDB and MyISAM. The second goal of benchmark was a popular myth that MyISAM is faster than InnoDB in reads, as InnoDB is transactional, […]

Read More

Join performance of MyISAM and Innodb

 | May 29, 2006 |  Posted In: Benchmarks

We had discussion today which involved benchmarks of Join speed for MyISAM and Innodb storage engines for CPU bound workload, this is when data size is small enough to fit in memory and so buffer pool. I tested very simple table, having with about 20.000 rows in it on 32bit Linux. The columns “id” “i” […]

Read More

MySQL 8.0: The end of MyISAM

 | October 11, 2016 |  Posted In: MySQL

MySQL 8.0 innodb_dedicated_server

This blog discusses the gradual end of MyISAM in MySQL. The story that started 20 years ago is coming to its end. I’m talking about the old MyISAM storage engine that was the only storage provided by MySQL in 1995, and was available in MySQL for 20+ years. Actually, part of my job as a MySQL consultant […]

Read More