How to optimize a Drupal website hosted on a VPS/Dedicated server?

Knowledge Base Article

How to optimize a Drupal website hosted on a VPS/Dedicated server?

The global MySQL settings on a VPS/Dedicated server 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 VPS, please post a support ticket to have our support team make the necessary changes for you.

Rating

rating :	3.3 from 5
views :	105
votes :	3