[mysqld]
explicit_defaults_for_timestamp = 1
userstat=1
user=mysql
pid-file=/var/lib/mysql/mysql.pid
datadir=/var/lib/mysql/data
event_scheduler=1
open_files_limit=10000
myisam-recover-options=BACKUP,FORCE

# Network
wait_timeout=15
skip_name_resolve
max_connections=2000
max_connect_errors=10000
max_user_connections=30
max_allowed_packet=16M

#Cache
thread_cache_size=32

# Temporary Tables
max_heap_table_size=4194304
tmpdir=/var/lib/mysql/tmpdir
tmp_table_size=20M

# InnoDB
innodb_buffer_pool_size=6G


# Logs
slow_query_log=1
slow_query_log_file=/var/lib/mysql/logs/perf_mysql.log
long_query_time=10
log-error=/var/lib/mysql/logs/mysqld.log
log_timestamps = SYSTEM
log_output=TABLE,FILE

#DESCOMENTAR ABAIXO SOMENTE PARA RECUPERAR TABELAS INNODB
#innodb_force_recovery = 4

[client]
socket=/var/lib/mysql/mysql.sock