[mysqld]

event_scheduler=off

join_buffer_size = 3M
tmp_table_size = 64M
max_heap_table_size = 64M
table_definition_cache = 8192

performance_schema = ON

disable-log-bin = 1
#default-authentication-plugin = mysql_native_password
authentication_policy=mysql_native_password
mysql_native_password=1

internal_tmp_mem_storage_engine=MEMORY
innodb-flush-method=O_DIRECT
innodb_use_native_aio=0

datadir = /var/lib/mysql
socket = /var/lib/mysql/mysql.sock
log-error = /var/log/mysqld.log
pid-file = /var/run/mysqld/mysqld.pid

innodb_file_per_table=1

local-infile = 0
max_allowed_packet=268435456
join_buffer_size = 2M
tmp_table_size = 32M
max_heap_table_size = 32M
table_open_cache = 16000
key_buffer_size = 6G
# for 200GB
innodb_buffer_pool_size = 66G
#innodb_flush_log_at_trx_commit = 2
#innodb_lock_wait_timeout = 200
max_connections = 500
max_user_connections = 25
innodb_log_file_size= 1600M
open_files_limit=80000
default-storage-engine = MyISAM
sql_mode=""

#mysql8.0
innodb_read_io_threads = 16  
innodb_write_io_threads = 16  
innodb_thread_concurrency=64  # cpus*2  
sync_binlog=0 
#When it is set to 0, nothing is done on commit; rather the log buffer is written and flushed to the InnoDB redo log once a second. This gives better performance, but a server crash can erase the last second of transactions
#The innodb_flush_log_at_trx_commit system variable configures how often the transactions are flushed to the redo log:
innodb_flush_log_at_trx_commit=0
#More multithreading in backend memory 
innodb_buffer_pool_instances=12