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 only takes a minute to sign up.
Sign up to join this community
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
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
Sep 26, 2012 : How do I shrink the innodb file ibdata1 without dumping all databases?Jul 05, 2012 : Move ibdata1, set innodb_data_file_pathApr 19, 2012 : MySql - Clean ibdata1Apr 01, 2012 : Is innodb_file_per_table advisable?Oct 22, 2012 : How much memory do I need for innodb buffer pool?Jun 13, 2012 : What to set innodb_buffer_pool and why..?Jan 17, 2013 : MySQL 5.5 - Innodb - innodb_log_file_size higher than 4GB combined?Feb 16, 2011 : How to safely change MySQL innodb variable 'innodb_log_file_size'?May 21, 2012 : MySQL - Installing InnoDB PluginMar 16, 2012 : Using multiple cores for single MySQL queries on DebianNov 24, 2011 : Why mysql 5.5 slower than 5.1 (linux,using mysqlslap)Sep 20, 2011 : Multi cores and MySQL PerformanceSep 12, 2011 : Possible to make MySQL use more than one core?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.
innodb_file_per_table or innodb_file_per_table=1 are the same.
Apr 3, 2013 at 18:47
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/…)
Apr 3, 2013 at 19:11