分享一份 MySQL 通用配置

[mysqld]
sql_mode=STRICT_ALL_TABLES
datadir=/var/data/mysql
socket=/var/data/mysql/mysql.sock
user=mysql 
default_table_type=InnoDB
slow_query_log=6
slow_query_log_file=/var/log/mysql_slow.log
lower_case_table_names=1
long_query_time=1
innodb_file_per_table=1
innodb_buffer_pool_size=500M
max_connections = 1000
max_allowed_packet=33554432
general_log=on
general_log_file=/var/log/mysql.log
default-storage-engine=innodb
default-table-type=innodb


## Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/data/mysql/mysqld.pid

[mysql]
socket=/var/data/mysql/mysql.sock

[mysqladmin]
socket=/var/data/mysql/mysql.sock