一起遨游网

https://adoptium.net/zh-CN/temurin/releases/?version=8

Windows 10 (business editions), version 22H2 (updated June 2024) (x64) - DVD (Chinese-Simplified)文件：zh-cn_windows_10_business_editions_version_22h2_updated_june_2024_x64_dvd_1139f6a3.iso大小：6.47GBMD5：A59E59D0B6F2C62AA82956A135691191SHA1：8D23B70054E...

先查询SELECT CONCAT('KILL ', id, ';') AS kill_statement FROM information_schema.processlist WHERE command = 'Sleep' AND time > 50;后复制 运行然后把kill复制出来运行

这样假如程序写的不够完善会出现大量sleep超过几千的进程，这样会引起性能变差，链接中断,所以建议如下修改.全局和会话变量一起改 具体多少变量自己决定。show VARIABLES like '%timeout%' ; set wait_timeout=600; set interactive_timeout=600; set global wait_timeout=600; set global interactive_timeout=600; show VARIABLES like...

按IP来排序select client_ip,count(client_ip) as client_num from (select substring_index(host,':' ,1) as client_ip from information_schema.processlist ) as connect_info group by client_ip order by client_num desc;显示线程数show status like 'thread%';显示所有线程SH...