本文地址： http://www.cnblogs.com/yhLinux/p/4013065.html
Percona是一款在线自动生成MySQL配置文件的工具，提供的MySQL配置文件做了优化处理。
首先，需要注册，然后按网站上提示选择设置，一共7步。
# Generated by Percona Configuration Wizard (http:
//
tools.percona.com/) version REL5-20120208
# Configuration name server-dev-binary-
1009
generated
for
#**********@
163
.com at
2014
-
10
-
09
04
:
32
:
10
[mysql]
# CLIENT #
port
=
3306
socket
= /usr/local/mysql/data/
mysql.sock
[mysqld]
# GENERAL #
user
=
mysql
default
-storage-engine =
InnoDB
socket
= /usr/local/mysql/data/
mysql.sock
pid
-
file
= /usr/local/mysql/data/
mysql.pid
# MyISAM #
key
-buffer-size =
32M
myisam
-recover =
FORCE,BACKUP
# SAFETY #
max
-allowed-packet =
16M
max
-connect-errors =
1000000
# DATA STORAGE #
datadir
= /usr/local/mysql/data/
# BINARY LOGGING #
log
-bin = /usr/local/mysql/data/mysql-
bin
expire
-logs-days =
14
sync
-binlog =
1
# CACHES AND LIMITS #
tmp
-table-size =
32M
max
-heap-table-size =
32M
query
-cache-type =
0
query
-cache-size =
0
max
-connections =
500
thread
-cache-size =
50
open
-files-limit =
65535
table
-definition-cache =
4096
table
-open-cache =
4096
# INNODB #
innodb
-flush-method =
O_DIRECT
innodb
-log-files-
in
-group =
2
innodb
-log-
file
-size =
64M
innodb
-flush-log-at-trx-commit =
1
innodb
-
file
-per-table =
1
innodb
-buffer-pool-size =
128M
# LOGGING #
log
-error = /usr/local/mysql/data/mysql-
error.log
log
-queries-not-using-indexes =
1
slow
-query-log =
1
slow
-query-log-
file
= /usr/local/mysql/data/mysql-slow.log
