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
Last activity: Sep 4, 2015, 04:37 PM