mysql
Drupal: PostgreSQL vs MySQL
angch — Thu, 26/03/2009 - 19:11
Let's get this out of the way first: MySQL beats PostgreSQL for Drupal sites in terms of raw performance. See this benchmark
But the real question is the how and why, and also how to make sites even faster and more scalable?
mysql tuning
angch — Wed, 05/11/2008 - 16:13
Random note, Ubuntu Hardy, mysql/innodb tuning (more like frobbing).
[mysqld] query_cache_limit = 2M; was 1M query_cache_size = 32M; was 16M innodb_file_per_table innodb_buffer_pool_size=128M innodb_log_file_size=32M innodb_log_buffer_size=12M default-table-type=innodb
Dump/restore required, nuke the orig log file first before restarting
