mysql 配置文件

基础配置文件：

[mysqld]
#mysql存放目录
basedir=/var/lib/mysql
#mysql数据存放目录
datadir=/var/lib/mysql/data
socket=/var/lib/mysql/mysql.sock
pid_file=/var/lib/mysql/mysql.pid
user=mysql
port=3306
default_storage_engine=InnoDB

#innodb
innodb_buffer_pool_size=<value>
innodb_log_file_size=<value>
innodb_file_per_table=1
innodb_flush_method=O_DIRECT

#myisam
key_buffer_siez=<value>

#logging
log_error=/var/lib/mysql/mysql-error.log
slow_query_log=/var/lib/mysql/mysql-slow.log

#other
tmp_table_size=32M
max_heap_table_size=32M
query_cache_type=0
query_cache_size=0
max_connections=<value>
thread_cache=<value>
open_files_limit=65535

[client]
socket=/var/lib/mysql/mysql.sock
port=3306