A Drupal.hu forumán Paal hívta fel a figyelmem erre az oldalra: http://drupal.org/node/259580 és itt is találunk hasznos információkat http://drupal.org/node/85768 .
MySQL tuningolás drupal alá, gondoltam teszek egy próbát:
[mysqld] max_connections = 150 max_user_connections = 150 key_buffer = 384M myisam_sort_buffer_size = 64M join_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 64M sort_buffer_size = 3M table_cache = 4096 thread_stack = 128K thread_cache_size = 286 interactive_timeout = 25 wait_timeout = 1800 connect_timeout = 10 max_allowed_packet = 64M max_connect_errors = 1000 query_cache_limit = 1M query_cache_size = 32M query_cache_type = 1 tmp_table_size = 16M
Nevergone mysql
Nevergone mysql konfiguracioja:
[mysqld]
max_connections = 150
max_user_connections = 150
key_buffer = 1024M
myisam_sort_buffer_size = 128M
join_buffer_size = 16M
read_buffer_size = 16M
sort_buffer_size = 16M
table_cache = 1024
thread_cache_size = 286
interactive_timeout = 25
wait_timeout = 1800
connect_timeout = 10
max_allowed_packet = 64M
max_connect_errors = 1000
query_cache_limit = 1M
query_cache_size = 16M
query_cache_type = 1
tmp_table_size = 16M
[innodb]
innodb_buffer_pool_size = 1024M
innodb_additional_mem_pool_size = 20M
innodb_log_file_size = 10M
innodb_log_buffer_size = 64M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 180