首页 > 学术百科

5.7mysql配置_mysql5.7

5.7mysql配置_mysql5.7 的完整配置⽂件 myf cat /etc/myf

# For advice on how to change settings please see

# *** DO NOT EDIT THIS FILE. It's a template which will be copied

to the

# *** default location during install, and will be replaced if

you

# *** upgrade to a newer version of MySQL.

[mysqld]

# Remove leading # and set to the amount of RAM for the most

important data

# cache in MySQL. Start at 70% of total RAM for dedicated server,

else 10%.

# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity

豪杰超级解霸3000

option: logging

# changes to the binary log between backups.

# log_bin

general_log_file = /var/log/mysql/mysql.log

general_log = 1

# These are commonly set, remove the # and set as required.

书画书录解题# basedir = .....

# datadir = .....

# port = .....cnf

# server_id = .....

# socket = .....

#kip-external-locking

skip-name-resolve

basedir=/usr/local/mysql

datadir=/usr/local/mysql/data

pid-file=/usr/local/mysql/data/mysql.pid

port=3306

character_set_server=utf8

init_connect='SET NAMES utf8'

log-error=/usr/local/mysql/

cdna

slow_query_log = 1

slow_query_log_file =/usr/local/mysql/data/slow-query.log long_query_time = 1

log-queries-not-using-indexes

max_connections = 1024混凝土u型槽排水沟

back_log = 128

wait_timeout = 100

interactive_timeout = 200

key_buffer_size=256M

query_cache_size = 256M

query_cache_type=1

query_cache_limit=50M

max_connect_errors=20

sort_buffer_size = 2M

max_allowed_packet=16M

join_buffer_size=2M

thread_cache_size=200

innodb_buffer_pool_size = 2048M

innodb_flush_log_at_trx_commit = 1

innodb_log_buffer_size=32M

innodb_log_file_size=128M

innodb_log_files_in_group=3

server_id=1

log-bin=mysql-bin

binlog_cache_size=2M

max_binlog_cache_size=8M

max_binlog_size=512M

expire_logs_days=7

read_buffer_size=1M

read_rnd_buffer_size=16M

bulk_insert_buffer_size=64M

# Remove leading # to set options mainly useful for reporting servers.

# The server defaults are faster for transactions and fast

SELECTs.

# Adjust sizes as needed, experiment to find the optimal

values.

# join_buffer_size = 128M

# sort_buffer_size = 2M

# read_rnd_buffer_size = 2M

#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

sql_mode

='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,N

>导平

本文发布于:2024-09-20 21:21:01，感谢您对本站的认可！

本文链接：https://www.17tex.com/xueshu/718780.html

上一篇：rpm包安装Mysql

下一篇：FOBCIFCFRCFCPTCIPFCA货运相关贸易常用术语分析及比较

标签：解题混凝土书画排水沟书录

留言与评论（共有 0 条评论）