https://adoptium.net/zh-CN/temurin/releases/?version=8遨游死神文章列表
WINDOWS 10 2024-06-18 updated June 2024
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.47GB
MD5：A59E59D0B6F2C62AA82956A135691191
SHA1：8D23B70054E0F5974CEB6DBD012A88846AFD45C5
SHA256：1CAE36DF4B3614C92E356C7ECAB227DB3057087FCCB303E51BC9EC52A50F745B
ed2k://|file|zh-cn_windows_10_business_editions_version_22h2_updated_june_2024_x64_dvd_1139f6a3.iso|6942404608|F40A743548110202B4766BAC230CD9CF|/Windows 10 (consumer editions), version 22H2 (updated June 2024) (x64) - DVD (Chinese-Simplified)
文件：zh-cn_windows_10_consumer_editions_version_22h2_updated_june_2024_x64_dvd_a8751094.iso
大小：6.63GB
MD5：1D7F511BF089B19CC7504566D052E184
SHA1：DCB0AFB2F296D13BB1D1BC31C296C94BB4D1ADC6
SHA256：0F99B5876B5C5DAD997750EFBB1CD56366AC500B2228ACCB866BCBD3F74C7FF6
ed2k://|file|zh-cn_windows_10_consumer_editions_version_22h2_updated_june_2024_x64_dvd_a8751094.iso|7114102784|2DDBBBEF85CE8AF0CFA5874C6C327E7E|/Windows 10 Enterprise LTSC 2021 (x64) - DVD (Chinese-Simplified)
文件：SW_DVD9_WIN_ENT_LTSC_2021_64BIT_ChnSimp_MLF_X22-84402.ISO
大小：4.7GB
MD5：2579B3865C0591EAD3A2B45AF3CABEEE
SHA1：C19D7DAFBAFEB26C36E31D97C465E87C7A6E8A4C
SHA256：C117C5DDBC51F315C739F9321D4907FA50090BA7B48E7E9A2D173D49EF2F73A3
ed2k://|file|SW_DVD9_WIN_ENT_LTSC_2021_64BIT_ChnSimp_MLF_X22-84402.ISO|5044211712|1555B7DCA052B5958EE68DB58A42408D|/批量处理mysql数据库大量sleep状态进程
先查询
SELECT CONCAT('KILL ', id, ';') AS kill_statement
FROM information_schema.processlist
WHERE command = 'Sleep' AND time > 50;后复制 运行
然后把kill复制出来运行
设置mysql wait_timeout过大影响如何
这样假如程序写的不够完善会出现大量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 '%timeout%' ;
show global VARIABLES like '%timeout%' ;MYSQL 查询线程语句
按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%';显示所有线程
SHOW FULL PROCESSLIST;