mysqltuner recommendations

sahostking

• January 19, 2016 12:48

Hi We host cpanel servers with 8GB of memory and use litespeed. When we switch to apache it seems that server keeps randomly having high load. IS this due to possibly mysql as whren I run iotop mysql is using 99% constantly under io column Now I run mysql tuner and it gives me this: query_cache_size (> 256M) [see warning above] join_buffer_size (> 1.0M, or always use indexes with joins) table_open_cache (> 4096) innodb_buffer_pool_size (>= 5G) if possible. innodb_buffer_pool_instances (=1) innodb_buffer_pool_size (>= 5G) if possible. IS that not very high for 500 sites on a server or should I just do as it sais? and make it 5GB? Will it help alot?

• 

  cPanelMichael

  • January 19, 2016 19:31

  Hello :) Could you verify if you let MySQL run for at least 24 hours before running the tuner script? Also, these third-party forum posts are helpful: Best Mysql cache settings for 8gb RAM dedicated mysql server using only Innodb (5gb database) What are the main differences between InnoDB and MyISAM? Thank you.

  0

Please sign in to leave a comment.