mysql配置优化 64g_Mysql配置文件 16c64g优化

[TOC]

## 一.说明

以下配置适合16核64G及以上的配置，会让性能稍微提高1/3左右。

## 二.配置

my.cnf

```python

[client]

port = 3306

socket = /usr/local/mysql/mysql.sock

[mysqld]

#基础设置

port = 3306

bind-address = 0.0.0.0

lower_case_table_names=1

character-set-server=utf8mb4

default-storage-engine=innoDB

basedir=/usr/local/mysql

datadir=/usr/local/mysql/data

socket=/usr/local/mysql/mysql.sock

log-error=/var/log/mysql/mysql.log

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

#扩展设置

max_connections = 5000

max_connect_errors = 6000

connect_timeout=10

wait_timeout = 300

interactive_timeout = 300

back_log = 300

open_files_limit = 65535

table_open_cache = 1