mysql

angch's picture

Drupal: PostgreSQL vs MySQL

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?

angch's picture

mysql tuning

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

Syndicate content