mysql my.conf

millinux
(usa Red Hat)

Enviado em 26/12/2014 - 18:06h

Senhores,

Apos minha vez de contribuir uma conf e uma duvida.

1 servidor debian 7.7 64 mysql 3GB de RAM
1 Servidor centos 6.5 64 zabbix server
1 Servidor centos 6.5 64 zabbix frontend

Fiz uma conf para o servidor, porém gostaria da opinião dos dbas quando a conf para alta performance (tunning) 1 usuário vai usar todas as conexões, servidor db dedicado ao zabbix.


[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld]
back_log = 75
#skip-innodb
max_connections = 512
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 7200
connect_timeout = 120
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 1000
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 5M
query_cache_size = 1M
query_cache_type = 1
query_prealloc_size = 65536
query_alloc_block_size = 131072

#Slow query
long_query_time = 1
slow_query_log = 8
slow_query_log_file = /var/log/mysql/slowquery.log
log_queries_not_using_indexes = 1
general_log = on
general_log_file=/var/log/mysql/general.log

[mysqld_safe]
log_error=/var/log/mysqld.log
pid_file=/var/run/mysqld/mysqld.pid
bind address = 127.0.0.1
nice = -5
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 128M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M

# Split Tables
#innodb_file_per_table = 1
key_buffer_size = 32M
table_open_cache = 200
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M