Knowledgebase

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, you will have root access to your server and you will be able to make these changes yourself.

If you are on a Cloud hosting solution (VDS), please post a support ticket to have our support team make the necessary changes for you.