本文地址： 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
?
更多文章、技術交流、商務合作、聯系博主
微信掃碼或搜索：z360901061
微信掃一掃加我為好友
QQ號聯系： 360901061
您的支持是博主寫作最大的動力，如果您喜歡我的文章，感覺我的文章對您有幫助，請用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧，狠狠點擊下面給點支持吧，站長非常感激您！手機微信長按不能支付解決辦法：請將微信支付二維碼保存到相冊，切換到微信，然后點擊微信右上角掃一掃功能，選擇支付二維碼完成支付。
【本文對您有幫助就好】元
