[mysqld] # Configuración Básica datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid default-authentication-plugin=mysql_native_password disable-log-bin=1 performance-schema=0 mysqlx=0 # --- OPTIMIZACIÓN PARA 8GB RAM --- # Pasamos de 128MB a 3GB para que las tablas vivan en RAM y no estresen la CPU innodb_buffer_pool_size = 3G innodb_buffer_pool_instances = 3 innodb_log_file_size = 512M innodb_flush_method = O_DIRECT # Límites de seguridad max_connections = 150 max_user_connections = 50 max_allowed_packet = 256M open_files_limit = 40000 innodb_file_per_table = 1 # Tablas temporales (evita escritura en disco) tmp_table_size = 64M max_heap_table_size = 64M slow_query_log=1 long_query_time=2