``` https://adoptium.net/zh-CN/temurin/releases/?version=8 ```
``` 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.47...
先查询 ``` SELECT CONCAT('KILL ', id, ';') AS kill_statement FROM information_schema.processlist WHERE command = 'Sleep' AND time > 50; ``` 后复制 运行 ![1.png][1] 然后把kill复制出来运行 [1]: https://w...
这样假如程序写的不够完善会出现大量sleep超过几千的进程，这样会引起性能变差，链接中断, 所以建议如下修改. 全局和会话变量一起改 具体多少变量自己决定。 ``` show VARIABLES like '%timeout%' ; set wait_timeout=600; set interactive_timeout=600; set global wait_time...
按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...