#  ...MySQL configuration...  #

[client]

## Client section

port = 3306
socket = /tmp/mysql.sock

[mysqld]

## Server section

port = 3306
socket = /tmp/mysql.sock
pid_file = mysqld.pid

sql_mode = "ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
mysqlx = 0
#tls_version = ''

## General Server Options:

#max_allowed_packet = 64M
# Default 64M

#max_connections = 151
# Default 151

table_open_cache = 1024
# Default 4000

table_open_cache_instances = 4
# Default 16

tmp_table_size = 64M
max_heap_table_size = 64M
# Default 16M 16M

tmpdir = /tmp

#skip_name_resolve
# Disabling DNS resolution
# Default OFF (Disabled)

#join_buffer_size = 256k
#sort_buffer_size = 256k
#read_buffer_size = 128k
#read_rnd_buffer_size = 256k
# Leave these at their defaults, do not change server-wide settings for them.
# Instead, use session variable when you really need it like that:
# mysql> SET session read_buffer_size = 2 * 1024 * 1024;
# mysql> RUN YOUR QUERY;

#character_set_server = utf8mb4
# Default utf8mb4

#collation_server = utf8mb4_0900_ai_ci
# Default utf8mb4_0900_ai_ci

## Binary logging section

log_bin = mysqld-binlog
log_error = mysqld-errlog
server_id = 1
# Enabling binlog as well as unique server_id for
# point in time recovery and, potentially, replication.

max_binlog_size = 100M
# Default 1G

binlog_expire_logs_seconds = 172800
# Control the amount of binary logs server is allowed to keep (in seconds).
# Default 2592000 (30 days)

sync_binlog = 0
# Disabling sync_binlog for better performance.
# Default 1

binlog_format = MIXED
# For the binary log format, I recommend MIXED, but it's up to you.
# Default ROW

## MyISAM Specific Options:

key_buffer_size = 32M
# Default 8M

## InnoDB Specific Options:

innodb_data_file_path = ibdata1:20M:autoextend
# Default ibdata1:12M:autoextend

#innodb_buffer_pool_size = 128M
# Default 128M

#innodb_log_file_size = 48M
# Default 48M

#innodb_log_buffer_size = 16M
# Default 16M

innodb_flush_log_at_trx_commit = 0
# Default 1

#innodb_file_per_table = ON
# Default ON

## Slow query log

slow_query_log = 1
slow_query_log_file = mysqld-slow
# Enable the slow query logging

long_query_time = 2
# Default 10 (seconds)