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.

The recommended settings in the /etc/my.cnf file for a Drupal-based website are:

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 = 1M
max_connect_errors = 999999
query_cache_limit = 1M
query_cache_size = 16M
query_cache_type = 1
tmp_table_size = 16M

If you are on a dedicated server with root access to your server and you will be able to make these changes yourself.

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