首页 > 代码库 > Create My MySQL configuration by Percona
Create My MySQL configuration by Percona
https://tools.percona.com/
按网站上提示设置,一共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
Create My MySQL configuration by Percona
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。