本文地址: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 = 3306socket = /usr/local/mysql/data/mysql.sock[mysqld]# GENERAL #user = mysqldefault-storage-engine = InnoDBsocket = /usr/local/mysql/data/mysql.sockpid-file = /usr/local/mysql/data/mysql.pid# MyISAM #key-buffer-size = 32Mmyisam-recover = FORCE,BACKUP# SAFETY #max-allowed-packet = 16Mmax-connect-errors = 1000000# DATA STORAGE #datadir = /usr/local/mysql/data/# BINARY LOGGING #log-bin = /usr/local/mysql/data/mysql-binexpire-logs-days = 14sync-binlog = 1# CACHES AND LIMITS #tmp-table-size = 32Mmax-heap-table-size = 32Mquery-cache-type = 0query-cache-size = 0max-connections = 500thread-cache-size = 50open-files-limit = 65535table-definition-cache = 4096table-open-cache = 4096# INNODB #innodb-flush-method = O_DIRECTinnodb-log-files-in-group = 2innodb-log-file-size = 64Minnodb-flush-log-at-trx-commit = 1innodb-file-per-table = 1innodb-buffer-pool-size = 128M# LOGGING #log-error = /usr/local/mysql/data/mysql-error.loglog-queries-not-using-indexes = 1slow-query-log = 1slow-query-log-file = /usr/local/mysql/data/mysql-slow.log