File di configurazione MySQL (my.cnf) per HyFax/Hylafax
[mysqld]
skip-innodb
skip-bdb
max_connections = 2500
socket = /var/lib/mysql/mysql.sock
key_buffer = 4096M
table_cache = 36272
open_files_limit = 16344
join_buffer_size = 32M
read_buffer_size = 32M
sort_buffer_size = 32M
tmp_table_size = 1024M
read_rnd_buffer_size = 32M
max_heap_table_size = 512M
myisam_sort_buffer_size = 1024M
thread_cache_size = 1024
thread_cache = 8192
query_cache_type = 1
query_cache_limit = 512M
query_cache_size = 2048M
#thread_concurrency = 16
# Try number of CPU’s*2 for thread_concurrency
thread_concurrency = 8
wait_timeout = 3000
connect_timeout = 1200
interactive_timeout = 1200
long_query_time = 1
max_allowed_packet = 256M
log-slow-queries = /var/log/mysql-slow.log
long_query_time = 5
log-queries-not-using-indexes
[mysqldump]
quick
max_allowed_packet = 1600M
BoB
No trackbacks yet.