Moodle in English: MySQL configuration

Hardware and performance

MySQL configuration

This discussion has been locked because a year has elapsed since the last post. Please start a new discussion topic.

What do you think about this mysql configuration?

[mysqld]
default-character-set=utf8
server-id=1
set-variable=max_connections=1000
set-variable=query_cache_wlock_invalidate=True
table_cache=1024

innodb_buffer_pool_size = 5G
innodb_flush_method = O_DIRECT
innodb_flush_log_at_trx_commit = 0
innodb_additional_mem_pool_size = 16M
innodb_log_buffer_size = 8M
innodb_file_per_table = True

join_buffer_size = 1M
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 2M
thread_cache_size = 64
thread_concurrency = 8
query_cache_size = 96M
query_cache_limit = 16K
query_cache_type = 2
tmp_table_size = 64M
max_heap_table_size = 64M
wait_timeout = 60

This is my server: http://www.ovh.es/productos/eg_best_of.xml (8 GB RAM...)
with Debian 5.0 "Lenny" 64bit

Thanks

Have you ever run the MySQL tuner on your DB Server?

It makes excellent recommendations based on your Hardware. Remember to have backups of all configs before making any major changes to production servers!

http://blog.mysqltuner.com/

The tuning primer shellscript is also a great tool.
http://www.day32.com/MySQL/

Hope this helps.

Cheers,
-n