mysql运维配置_mysql配置文件

桃扇骨 2022-10-25 04:57 128阅读 0赞

\[client\]

port            = 3306

socket          = /tmp/mysql.sock

\# The MySQL server

\[mysqld\]

\# Basic

port            = 3306

user        = mysql

basedir         = /usr/local/mysql

datadir         = /data/mysql/mysql3306/data

tmpdir          = /data/mysql/mysql3306/tmp

socket          = /tmp/mysql.sock

log-bin     = /data/mysql/mysql3306/logs/mysql-bin

log-error   = error.log

slow-query-log-file = slow.log

skip-external-locking

skip-name-resolve

log-slave-updates

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#

\# FOR Percona 5.6

\#extra\_port = 3345

gtid-mode = 0

\#thread\_handling=pool-of-threads

\#thread\_pool\_oversubscribe=8

explicit\_defaults\_for\_timestamp

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#

server-id       =53306

character-set-server = utf8

slow-query-log

binlog\_format = mixed

max\_binlog\_size = 128M

binlog\_cache\_size = 1M

expire-logs-days = 5

back\_log = 500

long\_query\_time=1

max\_connections=1100

max\_user\_connections=1000

max\_connect\_errors=1000

wait\_timeout=100

interactive\_timeout=100

connect\_timeout = 20

slave-net-timeout=30

max-relay-log-size = 256M

relay-log = relay-bin

transaction\_isolation = READ-COMMITTED

performance\_schema=0

\#myisam\_recover

key\_buffer\_size = 64M

max\_allowed\_packet = 16M

\#table\_cache = 3096

table\_open\_cache = 6144

table\_definition\_cache = 4096

sort\_buffer\_size = 128K

read\_buffer\_size = 1M

read\_rnd\_buffer\_size = 1M

join\_buffer\_size = 128K

myisam\_sort\_buffer\_size = 32M

tmp\_table\_size = 32M

max\_heap\_table\_size = 64M

query\_cache\_type=0

query\_cache\_size = 0

bulk\_insert\_buffer\_size = 32M

thread\_cache\_size = 64

\#thread\_concurrency = 32

thread\_stack = 192K

skip-slave-start

\# InnoDB

innodb\_data\_home\_dir = /data/mysql/mysql3306/data

innodb\_log\_group\_home\_dir = /data/mysql/mysql3306/logs

innodb\_data\_file\_path = ibdata1:10M:autoextend

innodb\_buffer\_pool\_size = 100M

innodb\_buffer\_pool\_instances    = 8

\#innodb\_additional\_mem\_pool\_size = 16M

innodb\_log\_file\_size = 200M

innodb\_log\_buffer\_size = 16M

innodb\_log\_files\_in\_group = 3

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

innodb\_lock\_wait\_timeout = 10

innodb\_sync\_spin\_loops = 40

innodb\_max\_dirty\_pages\_pct = 90

innodb\_support\_xa = 0

innodb\_thread\_concurrency = 0

innodb\_thread\_sleep\_delay = 500

innodb\_file\_io\_threads    = 4

innodb\_concurrency\_tickets = 1000

log\_bin\_trust\_function\_creators = 1

innodb\_flush\_method = O\_DIRECT

innodb\_file\_per\_table

innodb\_read\_io\_threads = 16

innodb\_write\_io\_threads = 16

innodb\_io\_capacity = 2000

innodb\_file\_format = Barracuda

innodb\_purge\_threads=1

innodb\_purge\_batch\_size = 32

innodb\_old\_blocks\_pct=75

innodb\_change\_buffering=all

innodb\_stats\_on\_metadata=OFF

\[mysqldump\]

quick

max\_allowed\_packet = 128M

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

\[mysql\]

no-auto-rehash

max\_allowed\_packet = 128M

prompt                         = ‘(product)\\u@\\h \[\\d\]> ‘

default\_character\_set          = utf8

\[myisamchk\]

key\_buffer\_size = 64M

sort\_buffer\_size = 512k

read\_buffer = 2M

write\_buffer = 2M

\[mysqlhotcopy\]

interactive-timeout

\[mysqld\_safe\]

\#malloc-lib= /usr/local/mysql/lib/mysql/libjemalloc.so

mysql运维配置_mysql配置文件

发表评论取消回复

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

相关阅读

相关 mysql运维

相关 mysql运维命令

相关 mysql运维面试

相关 mysql自动化运维脚本_mysql互主自动化配置脚本

相关 mysql运维

相关 mysql运维配置_mysql配置文件

相关 mysql配置文件

相关运维配置：Nginx日志配置详解

相关 mysql运维日记（一）：安装与配置

相关 MySQL运维信息