MySQL configuration
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
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
Re: MySQL configuration
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
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