percona mysql 5.7_Percona MySQL 5.7 Linux通用二进制包安装(CentOS 6.5)

爱被打了一巴掌 2022-10-25 11:21 11阅读 0赞

\[client\]

port = 3306

socket = /mysql\_data\_57/mysql.sock

\[mysqld\]

\#MySQL Server layer basic setting

server-id = 1

port = 3306

socket = /mysql\_data\_57/mysql.sock

\#MySQL Server layer directory setting

basedir = /mysql\_software\_57

datadir = /mysql\_data\_57

tmpdir = /mysql\_data\_57

\#MySQL Server layer connection setting

max\_connections = 900

\#MySQL Server layer connection setting

max\_connections = 900

max\_connect\_errors = 100000

max\_allowed\_packet = 16M

back\_log = 50

\#MySQL Server layer binlog setting

log\_bin\_trust\_function\_creators = on

expire\_logs\_days = 5

binlog\_cache\_size = 1M

log-bin = /mysql\_log\_57/mysql-bin

binlog\_format = mixed

\#MySQL Server layer memory management setting

tmp\_table\_size = 64M

max\_heap\_table\_size = 64M

read\_buffer\_size = 2M

read\_rnd\_buffer\_size = 16M

sort\_buffer\_size = 8M

join\_buffer\_size = 16M

query\_cache\_size = 0

thread\_stack = 192K

query\_cache\_size = 0

thread\_stack = 192K

\#MySQL Server layer transaction management setting

transaction\_isolation = READ-COMMITTED

autocommit = OFF

\#MySQL Server layer log related setting

log\_warnings = 2 \#\#this value have been the default value in MySQL 5.7

slow\_query\_log = ON

long\_query\_time = 2

slow\_query\_log\_file = /mysql\_log\_57/mysql-slow.log

\#log\_queries\_not\_using\_indexes = 1

\#MySQL Server layer other behaviour setting

sql\_mode = PIPES\_AS\_CONCAT,IGNORE\_SPACE,STRICT\_TRANS\_TABLES

event\_scheduler = ON

lower\_case\_table\_names = 1

explicit\_defaults\_for\_timestamp = ON

default-storage-engine = INNODB

explicit\_defaults\_for\_timestamp = ON

default-storage-engine = INNODB

\#\#ft\_min\_word\_len = 4

\# Statistic

\# userstat = ON

\# thread\_statistics = ON

\# End statistics

\# MyISAM Engine related setting

key\_buffer\_size = 32M

bulk\_insert\_buffer\_size = 64M

myisam\_sort\_buffer\_size = 128M

myisam\_max\_sort\_file\_size = 10G

myisam\_repair\_threads = 1

\#myisam\_recover

\#InnoDB Engine related setting

\#InnoDB memory management related setting

innodb\_buffer\_pool\_size = 2G

innodb\_max\_dirty\_pages\_pct = 90

innodb\_sync\_array\_size = 16

innodb\_max\_dirty\_pages\_pct = 90

innodb\_sync\_array\_size = 16

\#table open cache related

table\_open\_cache = 4096

table\_open\_cache\_instances = 16

\#innodb\_additional\_mem\_pool\_size = 16M \#\#This variable have been removed MySQL 5.7

\#innodb\_numa\_interleave = 1 \#\#Only work with Percona 5.6.27 and later

\#\#InnoDB engine I/O related setting

innodb\_write\_io\_threads = 8

innodb\_read\_io\_threads = 8

innodb\_flush\_method = O\_DIRECT

\#InnoDB engine File management related setting

innodb\_data\_file\_path = ibdata1:12M:autoextend \#10M-->12M, 12M is default values, it is meaningless to set it to 10M

innodb\_file\_per\_table = 1 \#this value have been the default value in MySQL 5.7

innodb\_data\_file\_path = ibdata1:12M:autoextend \#10M-->12M, 12M is default values, it is meaningless to set it to 10M

innodb\_file\_per\_table = 1 \#this value have been the default value in MySQL 5.7

innodb\_file\_format = Barracuda \#this value have been the default value in MySQL 5.7

\#InnoDB engine undo log related setting

innodb\_undo\_directory = /mysql\_data\_57

innodb\_undo\_tablespaces = 4

innodb\_purge\_batch\_size = 5000

innodb\_purge\_threads = 8

\#InnoDB engine redo log related setting

innodb\_flush\_log\_at\_trx\_commit = 2

innodb\_log\_buffer\_size = 8M

innodb\_log\_file\_size = 256M

innodb\_log\_files\_in\_group = 3

innodb\_log\_group\_home\_dir = /mysql\_log\_57

\#InnoDB engine lock and transaction management setting

innodb\_lock\_wait\_timeout = 120

\#InnoDB engine other behaviour setting

innodb\_large\_prefix = ON \#\#this value have been the default value in MySQL 5.7

innodb\_strict\_mode = ON \#\#this value have been the default value in MySQL 5.7

innodb\_checksum\_algorithm = crc32 \#\#this value have been the default value in MySQL 5.7

\[mysqldump\]

quick

max\_allowed\_packet = 16M

\[mysql\]

no-auto-rehash

\# Only allow UPDATEs and DELETEs that use keys.

\#safe-updates

\[myisamchk\]

key\_buffer\_size = 512M

sort\_buffer\_size = 512M

key\_buffer\_size = 512M

sort\_buffer\_size = 512M

read\_buffer = 8M

write\_buffer = 8M

\[mysqlhotcopy\]

interactive-timeout

\[mysqld\_safe\]

\# Increase the amount of open files allowed per process. Warning: Make

\# sure you have set the global system limit high enough! The high value

\# is required for a large number of opened tables

open-files-limit = 8192

log-error = /mysql\_log\_57/mysqld\_error.log

percona mysql 5.7_Percona MySQL 5.7 Linux通用二进制包安装(CentOS 6.5)

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 Percona MySQL 5.7 Linux通用二进制包安装(CentOS 6.5)

相关 Percona MySQL 5.5 Linux通用二进制包安装(CentOS 6.9)

相关 mysql57压缩包安装教程

相关 CentOS7 配置MySQL57

相关 percona mysql 5.7_Percona MySQL 5.7 Linux通用二进制包安装(CentOS 6.5)

相关 Percona Toolkit for MySQL安装（CentOS5.8）

相关 linux二进制通用包安装mysql

相关 CentOS 7安装Mysql57数据库

相关 Linux CentOS7 安装 jdk1.8 && MySQL57

相关 Docker安装MySQL、Percona