[client]
port=3306
#user=root
#password=mysql
#default-character-set=utf8
socket=/tmp/mysql.sock #设置默认scok链接路径
[mysqld]
#GENERAL
datadir =/usr/local/mysql/data #数据路径
socket =/tmp/mysql.sock #开始服务时sock存放位置
pid_file =/usr/local/mysql/data/mysql.pid
user =mysql
port =3306
default_storage_engine =InnoDB
server_id =1
auto_increment_offset =1
auto_increment_increment =2
#skip-grant-tables
#INNODB
innodb_buffer_pool_size =512MB
innodb_log_file_size =50MB
innodb_file_per_table =1
innodb_flush_method =O_DIRECT
#MyISAM
key_buffer_size =100MB
#LOGGING
log_error =/usr/local/mysql/logs/mysql_error.log
slow_query_log =/usr/local/mysql/logs/mysql_slow.log
log_bin =/usr/local/mysql/logs/log_bin
expire_logs_days =10
#OTHER
tmp_table_size =32M
max_heap_table_size =32M
query_cache_type =0
query_cache_size =0
max_connections =150
thread_cache_size =30
table_open_cache =2000
open_files_limit =65535