( igor | 2014. 10. 13., h – 16:05 )

Ha vannak MyISAM tábláid is, akkor a query-cache-size miért 0?

thread-cache-size = cpu szám x 2 (ez jelenleg nálad 50!)
thread_concurrency = cpu szám x 2
query_cache_limit = 1048756
query_cache_size = 512M
query_cache_type = 1

innodb_buffer_pool_size = 2048M
innodb_additional_mem_pool_size = 8M
innodb_lock_wait_timeout = 50
innodb_file_per_table
innodb_flush_log_at_trx_commit = 0
innodb_thread_concurrency = cpu szám x 2
innodb_flush_method = O_DIRECT

sort_buffer_size = 8M
read_buffer_size = 8M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 8M
join_buffer_size = 8M

Valamint 1300 adatbázishoz szerintem kevés a max-connections=150