[mysqld] bind-address=127.0.0.1 port=3306 default-authentication-plugin=mysql_native_password disable-log-bin=1 performance-schema=ON sql_mode=NO_ENGINE_SUBSTITUTION event_scheduler=off max_connections=300 max_user_connections=15 wait_timeout=100 interactive_timeout=150 sort_buffer_size=1M innodb_buffer_pool_size=20G long_query_time=2 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock symbolic-links=0 sort_buffer_size=1M default-storage-engine=InnoDB default-tmp-storage-engine=InnoDB mysqlx=0 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 thread_cache_size=64 innodb_buffer_pool_instances=20 innodb_thread_concurrency=0 innodb_flush_log_at_trx_commit=2 innodb_strict_mode=0