[mysqld]
# Files layout
datadir=/var/lib/mysql/data
pid-file=/var/lib/mysql/mysql.pid
tmpdir=/var/lib/mysql/tmpdir

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

# Network
max_connections = 2000
max_user_connections = 30
max_connect_errors = 10000
max_allowed_packet=268435456

open_files_limit = 50000

# InnoDB
innodb_file_per_table
innodb_flush_method=O_DIRECT