server.cnf

#
# This group are read by MySQL server.
# Use it for options that only the server (but not clients) should see
#
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/en/server-configuration-defaults.html

# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mysqld according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld]
max_connections=1024
innodb_flush_method=O_DIRECT_NO_FSYNC
default-time-zone='+08:00'
innodb_flush_log_at_trx_commit=0
sync_binlog=0
binlog_order_commits=0
skip_name_resolve=1
transaction-isolation=READ-COMMITTED
skip-log-bin
slow_query_log=0
#long_query_time=6
#log_timestamps=SYSTEM
thread_stack=256K
innodb_buffer_pool_size=256M
innodb_log_buffer_size=256K
read_buffer_size=256K
read_rnd_buffer_size=256K
sort_buffer_size=256K
join_buffer_size=256K
tmp_table_size=256K
max_heap_table_size=256K
binlog_cache_size=256K
performance_schema=OFF
character-set-server=utf8mb4
character-set-client-handshake=FALSE