Sample Header Ad - 728x90

Optimization of variables in my.cnf (mysql) for Drupal

0 votes
2 answers
1228 views
I just get a Dedicated Server running UBUNTU and I need to optimize the variables in my.cnf for **Drupal 7**. I understand that this is tailed job. Then **Is there any tool to help me to do this?** I am a newby at this. I found this article (which seems a little outdated). It shows some values for a server with 500mb of RAM. My server has 16Gb of RAM. I guess is not as ease as to multiply those values by 32...? I use InnoDB tables. For a setup with 500mb of RAM your my.cnf file may look like this: [mysqld] max_connections = 150 max_user_connections = 150 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 = 1000 query_cache_limit = 1M query_cache_size = 16M query_cache_type = 1 tmp_table_size = 16M innodb-flush-log-at-trx-commit=2
Asked by chefnelone (185 rep)
Sep 4, 2015, 07:58 AM
Last activity: Sep 4, 2015, 04:37 PM