[client]
port=3306
socket=/tmp/mysql.sock
default-character-set=utf8

[mysql]
default-character-set=utf8
no-auto-rehash

[mysqld]
user=mysql
port=3306
bind-address=__SFD_DB_SERVER_IP__
basedir=/usr/local/mysql
datadir=/workspace/mysql/data
socket=/tmp/mysql.sock
pid-file=/workspace/mysql/mysql.pid

character-set-server=utf8
collation-server=utf8_general_ci
lower_case_table_names=1
skip-name-resolve
explicit_defaults_for_timestamp=1

max_connections=500
max_connect_errors=10000
open_files_limit=65535
table_open_cache=2048
thread_cache_size=64

innodb_file_per_table=1
innodb_buffer_pool_size=1G
innodb_log_file_size=256M
innodb_log_buffer_size=16M
innodb_flush_log_at_trx_commit=1

sql-mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

log-error=/workspace/mysql/log/mysql-error.log
slow-query-log=1
slow-query-log-file=/workspace/mysql/log/mysql-slow.log
long-query-time=2

[mysqldump]
quick
max_allowed_packet=64M