How do I optimize Drupal hosted on a dedicated or virtual server?

When running your own dedicated or virtual server, you have the opportunity to customize the MySQL configuration to achieve better performance results for your Drupal website. Please see our suggested configuration. Additionally, please note that your my.cnf file is located within the /etc/my.cnf directory.

Please note, we don’t advise making these changes unless you are familiar with the editors used on your Linux server such as nano, vi, pico or any other.

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       

Once you have made the above changes, you will need to restart your MySQL configuration, and you may do so by running the following command listed below:

# /etc/mysqld restart

If you have any further questions regarding Drupal, please feel free to get in contact with our web hosting support team and they will be glad to assist you.