Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

If I'm optimizing a database that will be delivering multiple Drupal 7 websites, all using InnoDB, do I need to worry about [myisamchk] & [isamchk] sections, or can I just worry about the stuff within [mysqld]?

I'm assuming if I delete these sections, that the defaults will just kick in if they are needed.

I'm trying to document, outline my.conf best practices here http://groups.drupal.org/node/289613

share|improve this question
add comment

1 Answer

The other group headers have no bearing on InnoDB whatsoever. [mysqld] is all you really need.

With regard to InnoDB itself, you will need to tune InnoDB in many aspects

System Tablespace / Individual Tablespaces

Buffer Pool

Transaction Logs

Multiple CPU / Multiple Core Engagament

Epilogue

There are so many other aspects I have no time to write about because I probably have written it already. Please see all my posts on InnoDB.

What is also worth noting is that you should be using the latest version of MySQL

On a side note, did you know the StackExchange has a Drupal Q&A site ? I have posted answers there as well.

share|improve this answer
    
Thanks RolandoMySQLDBA - this is a useful list. I wanted to post to the DBA list as I figured it would be a better place to get feedback like this. It's useful to get this direction. –  Mike Gifford Mar 28 '13 at 15:20
    
I'm not clear from the issue on innodb_file_per_table if it is needed as it seems to be defined that way by default. Also, it's unclear if innodb_file_per_table or innodb_file_per_table=1 are the same. –  Mike Gifford Apr 3 '13 at 18:47
    
Don't worry. Setting innodb_file_per_table or innodb_file_per_table=1 is synonymous. The default for innodb_file_per_table is 1 for MySQL 5.6 GA (dev.mysql.com/doc/refman/5.6/en/…) and 0 for MySQL 5.5 GA (dev.mysql.com/doc/refman/5.5/en/…) –  RolandoMySQLDBA Apr 3 '13 at 19:11
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.