Címlap » Blogok » York's blog
           MySQL tuning drupalhoz           
York, p, 2009-10-02 15:44

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