Hi,
I'm using Plesk Onyx with MySQL 5.5.53 for hosting a news site based on wordpress with WP Super Cache on a dedicated server with 32GB RAM and 2x250GB SSD RAID1. Can you give some advice for my.cnf for best performance? I have this settings for now:
and after running mysqltuner I get these results:
I'm using Plesk Onyx with MySQL 5.5.53 for hosting a news site based on wordpress with WP Super Cache on a dedicated server with 32GB RAM and 2x250GB SSD RAID1. Can you give some advice for my.cnf for best performance? I have this settings for now:
Code:
join_buffer_size = 2M
tmp_table_size = 64M
max_heap_table_size = 64M
innodb_buffer_pool_size = 8G
innodb_log_buffer_size = 8M
key_buffer = 32M
max_allowed_packet = 32M
thread_stack = 192K
thread_cache_size = 8
myisam-recover = BACKUP
max_connections = 800
query_cache_limit = 8M
query_cache_size = 64M
and after running mysqltuner I get these results:
Code:
Variables to adjust:
query_cache_type (=0)
query_cache_size (> 64M)
join_buffer_size (> 2.0M, or always use indexes with joins)
tmp_table_size (> 64M)
max_heap_table_size (> 64M)
table_open_cache (> 400)
innodb_file_per_table=ON
innodb_log_file_size should be equals to 1/4 of buffer pool size (=2G) if possible.
innodb_buffer_pool_instances(=8)