Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

1 Answer

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 http://dev.mysql.com/doc/refman/5.0/en/innodb-tuning.html

You may also want to grab MySQLTuner (http://blog.mysqltuner.com/) 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
add comment

Your Answer

 
discard

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.