Recently, I had some performance problems with my Drupal site, and I have discovered that one important part is to optimize your MySQL configurations according with the dimensions of the site.
What would be the best MySQL configuration for a Drupal site?
I am more interested in InnoDB tables than in MyISAM.
Here is how I configured
/etc/mysql/my.cnf so far:
[client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] user = mysql socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp skip-external-locking key_buffer = 16M max_allowed_packet = 16M thread_stack = 192K thread_cache_size = 8 myisam-recover = BACKUP query_cache_limit = 1M query_cache_size = 16M log_error = /var/log/mysql/error.log expire_logs_days = 10 max_binlog_size = 100M innodb_flush_log_at_trx_commit=0 [mysqldump] quick quote-names max_allowed_packet = 16M [mysql] [isamchk] key_buffer = 16M
UPDATE: I need more opinions and configurations related to this question.