How to optimize a Drupal website hosted on a dedicated solution?

The global MySQL settings on a dedicated solution can be modified to achieve better performance for your website. If you are on a dedicated server with root access to your server, you will be able to make these changes yourself.

The recommended settings should be applied in the /etc/my.cnf file. For a Drupal-based website they are as follows:

max_connections = 800
max_user_connections = 800
key_buffer = 36M
myisam_sort_buffer_size = 64M
join_buffer_size = 2M
read_buffer_size = 2M
sort_buffer_size = 3M
table_cache = 1024
thread_cache_size = 286
interactive_timeout = 25
wait_timeout = 1800
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 999999
query_cache_limit = 1M
query_cache_size = 16M
query_cache_type = 1
tmp_table_size = 16M

Save your /etc/my.cnf file and restart the MySQL server. This can be done via your WHM panel > Restart Services > SQL Server. The new settings should be active after that.

You find this article useful? Click here to learn more about SiteGround web hosting experts and what else we can do for you!