x. 临时禁用外键检查
SET GLOBAL FOREIGN_KEY_CHECKS = false;x. 修改最大连接数
# 临时修改(立即生效,但重启后失效)
SET GLOBAL max_connections = 2000;
# my.cnf永久生效
[mysqld]
max_connections = 2000
世界哪有真情在
SET GLOBAL FOREIGN_KEY_CHECKS = false;# 临时修改(立即生效,但重启后失效)
SET GLOBAL max_connections = 2000;
# my.cnf永久生效
[mysqld]
max_connections = 2000
评论