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