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.