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.