[mysqld]
disable-log-bin = 1
default-authentication-plugin = mysql_native_password
performance-schema = 0
datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
log-error = /var/log/mysqld.log
pid-file = /var/run/mysqld/mysqld.pid
max_allowed_packet = 268435456
open_files_limit=80000
innodb_file_per_table = 1
mysqlx = 0

# Optimizaciones Opcion A
innodb_buffer_pool_size = 16G
max_connections = 700
tmp_table_size = 128M
max_heap_table_size = 128M

# Slow query log
slow_query_log = 1
slow_query_log_file = /var/lib/mysql/slow.log
long_query_time = 2
wait_timeout = 600
interactive_timeout = 600
max_connect_errors = 1000
table_open_cache = 8000
table_definition_cache = 4000
thread_cache_size = 50