show global variables like '%timeout%';
set global wait_timeout = 500;
set global interactive_timeout = 500;
查看最大连接
show VARIABLES like '%max%';
#查看线程使用情况
show VARIABLES like '%thread%';
show status like '%connection%';
-- 查看是否开启定时器
SHOW VARIABLES LIKE 'event_scheduler';
-- 开启定时器 0:off 1:on
SET GLOBAL event_scheduler = 1;
set global wait_timeout = 500;
set global interactive_timeout = 500;
查看最大连接
show VARIABLES like '%max%';
#查看线程使用情况
show VARIABLES like '%thread%';
show status like '%connection%';
-- 查看是否开启定时器
SHOW VARIABLES LIKE 'event_scheduler';
-- 开启定时器 0:off 1:on
SET GLOBAL event_scheduler = 1;