mysql数据库技巧

Mysql5.6设置max_connections失败解决办法

my.cnf 无法修改连接数,报错信息:

[Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 15000)
[Warning] Buffered warning: Changed limits: max_connections: 214 (requested 3000)
[Warning] Buffered warning: Changed limits: table_open_cache: 400 (requested 1520)

修改/etc/security/limits.conf

添加:

mysql hard nofile 65535
mysql soft nofile 65535

vi /usr/lib/systemd/system/mysqld.service.d/limits.conf      #创建并配置配置文件
[Service]
LimitNOFILE=10000
# 重新加载配置文件
systemctl daemon-reload
#重启mysqld服务,使配置生效。
systemctl restart mysqld.service