Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've been using MyISAM exclusively for several years now and know the ins-and-outs pretty well of how to optimize it, but I've just recently started using InnoDB for some of my tables and don't know that much about it. What are some general tips to help improve the performance of these InnoDB tables (they were converted from MyISAM and have anywhere from 100k - 2M rows and most won't use transactions).

share|improve this question
up vote 0 down vote accepted

Applicable to either engine is your table design. Make sure that you have your indexes setup correctly for example.

Start by taking at look at the following

You may also want to grab MySQLTuner ( and run it to see what you get back. It does not change your system but also may give you some ideas where to start looking

DB tuning starts at the server level, goes to MySQL server setup, database design and onwards to query design and up to the application level. I have had clients who did some nasty things to databases with their application design, e.g. connection pooling, long-running transactions, etc.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.