Mysql的配置优化

Mysql的配置优化
硬件环境说明：CPU：4 内存16G
[client]
port = 3306 # MySQL客户端默认端口号
socket = /data/mysql/mysql.sock # 用于本地连接的套接字文件存放路径

[mysql]
no-auto-rehash # 关闭tab补齐功能
port = 3306
prompt = \u@\h:\d \R:\m:\s> #mysql的提示符
socket = /data/mysql/mysql.sock # 用于本地连接的套接字文件存放路径

[mysqld]
####### General ############
port = 3306 # # MySQL服务端默认监听的TCP/IP端口
socket = /data/mysql/mysql.sock
pid-file = /data/mysql/mysql.pid # 进程ID文件存放路径
basedir = /usr/local/mysql # 设置Mysql的安装目录
datadir = /data/mysql/data # 设置Mysql数据库的数据的存放目录
tmpdir = /data/mysql/tmp # MySQL临时文件存放路径
character-set-server = utf8 # MySQL服务端字符集
collation-server = utf8_general_ci # MySQL服务端校对规则
default-storage-engine = INNODB # 设置默认存储引擎为InnoDB
transaction_isolation = READ-COMMITTED #读提交
event_scheduler = ON # 开启事件调度器event_scheduler