Duvida my.cnf

fbocosta
(usa Ubuntu)

Enviado em 18/12/2014 - 17:30h

Tenho uma vps no azure com a seguinte configuração:


4 Núcleos e 14 gb de ram + SSD

minha configuração de my.cnf atual esta assim :

[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

[mysqld_safe]
nice = 0
socket = /var/run/mysqld/mysqld.sock

[mysqld]
basedir = /usr
bind-address = 0.0.0.0
binlog_format = ROW
character_set_server = utf8
collation_server = utf8_general_ci
datadir = /var/lib/mysql
default-storage-engine = InnoDB
expire_logs_days = 30
innodb_autoinc_lock_mode = 2
innodb_buffer_pool_size = 2G
innodb_doublewrite = 1
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 0
innodb_lock_wait_timeout = 60
innodb_locks_unsafe_for_binlog = 1
innodb_stats_on_metadata = 0
innodb_log_buffer_size = 256M
innodb_fast_shutdown=0

max-connect-errors=1000000
skip-name-resolve
sync_binlog = 1
key_buffer_size = 2G
lc-messages-dir = /usr/share/mysql
lock_wait_timeout = 600
max_allowed_packet = 128M
max_binlog_size = 128M
max_connections = 350
myisam-recover = BACKUP
myisam_sort_buffer_size = 64M
net_buffer_length = 8K
open-files-limit = 65535
pid-file = /var/run/mysqld/mysqld.pid
port = 3306
query_cache_limit = 16M
query_cache_size = 16M
read_buffer_size = 16M
read_rnd_buffer_size = 16M
skip-external-locking
socket = /var/run/mysqld/mysqld.sock
sort_buffer_size = 16M
table_cache = 2M
table_definition_cache = 4096
table_open_cache = 4096
thread_cache_size = 8
thread_concurrency = 8
tmpdir = /tmp
user = mysql

[mysqldump]
max_allowed_packet = 16M
quick
quote-names

[mysql]

[isamchk]
!includedir /etc/mysql/conf.d/
key_buffer = 256M
read_buffer = 16M
sort_buffer_size = 256M
write_buffer = 16M

###########LOGS SERVER ##########################
log-error = /var/log/mysql/error.log
general_log_file = /var/log/mysql/mysql.log
max_binlog_size = 100M
###################################################

############SLOW_QUERY################################
slow_query_log = 0
slow_query_log = 0
slow_query_log_file = /var/log/mysql/slow.log
long_query_time = 10
log_slow_verbosity = query_plan
########################################################