Written by 正冰 on 2024, June 4, 10:17 PM
nginx+php+mysql这个架构中,出现了VPS偶发性100%CPU资源耗尽,大概持续5分钟又恢复正常,通过检查Mysql慢日志找到了问题:
Time Id Command Argument
# Time: 2024-06-03T11:56:09.101160Z
# User@Host: blog_is36_com[blog_is36_com] @ localhost [] Id: 135566
# Query_time: 8.490175 Lock_time: 0.159524 Rows_sent: 0 Rows_examined: 1386
use blog_is36_com;
SET timestamp=1717415769;
DELETE FROM sablog_sessions WHERE hash='XHm2K9' OR lastactivity<(1717415760-900) OR ('0'<>'0' AND uid='0') OR (uid='0' AND ip1='60' AND ip2='188' AND ip3='9' AND ip4='208' AND lastactivity>1717415760-60) OR (is_robot = '1' AND lastactivity < (1717415760-900));
--------------
# Time: 2024-04-15T10:20:42.123456Z
# User@Host: root[root] @ localhost []
# Query_time: 12.345678 Lock_time: 0.123456 Rows_sent: 456 Rows_examined: 12345
use dbname;
SET timestamp=1234567890;
SELECT * FROM table WHERE non_indexed_column = 'value';
# Time:这是查询执行的时间戳。
# User@Host:执行查询的用户是root,主机是localhost。
# Query_time:查询执行花费了12.345678秒。
# Lock_time:查询在锁定上花费了0.123456秒。
Rows_sent:查询发送了456行数据给客户端。
Rows_examined:查询检查了12345行数据,这可能是性能问题的一个指标,特别是如果检查的行数远大于发送的行数。
use dbname:表明这个查询是在dbname数据库上执行的。
SET timestamp:这是查询执行时的UNIX时间戳。
SELECT:这是实际执行的SQL语句。
Filed under: 技术归总
0 Comments
0 Views
Written by 正冰 on 2024, March 18, 2:58 PM
文章仅用于测试,模拟的群晖型号是DS3617xs,安装的系统版本为DSM 6.1.7-15284,系统网页版入口为http://192.168.1.2
先在套件中心搜索安装完成Active Backup for Business
安装完成后进入【控制面板】-【信息中心】,复制【产品序列号】后的字符串备用
1、把【登录账号】和【登录密码】改成实际的账号密码后,访问:http://192.168.1.2/webapi/auth.cgi?api=SYNO.API.Auth&version=3&method=login&account=登录账号&passwd=登录密码&format=cookie
会返回类似信息即表示成功了:{"data":{"sid":"jnXX232xx8YMgB8OTR02468"},"success":true}
2、把【产品序列号】的字符串填写到后面这个链接,访问:http://192.168.1.2/webapi/entry.cgi?api=SYNO.ActiveBackup.Activation&method=set&version=1&activated=true&serial_number="产品序列号"
会返回类似信息即表示成功了:{"data":{"activated":true},"success":true}
3、打开主菜单中的Active Backup for Business开始使用吧
Filed under: 技术归总
0 Comments
23207 Views
Written by 正冰 on 2023, April 9, 8:49 PM
解决方法,下载smcFanControl软件进行设置,这个软件支持较老的macOS系统。
下载地址:https://www.eidac.de/smcfancontrol/smcfancontrol_2_6.zip
smcFanControl 2.6 requires OS X 10.7 or higher. Support for 32Bit machines has been deprecated.
Filed under: 技术归总
0 Comments
56153 Views
Written by 正冰 on 2023, March 11, 9:02 AM
https://support.apple.com/kb/DL1888?viewlocale=zh_CN&locale=en_US
https://www.bilibili.com/video/BV1d64y1a7Lc/
Filed under: 技术归总
0 Comments
54941 Views
Written by 正冰 on 2022, November 22, 10:23 PM
@echo off
for /f "tokens=1,2,* " %%i in ('REG QUERY "HKCU\Software\Microsoft\Windows\CurrentVersion\Internet Settings" /v ProxyEnable ^| find /i "ProxyEnable"') do (set /A ProxyEnableValue=%%k)
if %ProxyEnableValue% equ 0 (
echo 系统代理目前处于关闭状态,正在开启代理,请稍候...
echo=
reg add "HKCU\Software\Microsoft\Windows\CurrentVersion\Internet Settings" /v ProxyEnable /t REG_DWORD /d 1 /f >nul 2>nul
reg add "HKCU\Software\Microsoft\Windows\CurrentVersion\Internet Settings" /v ProxyServer /d "IP:PORT" /f >nul 2>nul
echo 系统代理已开启,请按任意键关闭本窗口...
) else if %ProxyEnableValue% equ 1 (
echo 系统代理目前处于开启状态,正在关闭代理,请稍候...
echo=
reg add "HKCU\Software\Microsoft\Windows\CurrentVersion\Internet Settings" /v ProxyEnable /t REG_DWORD /d 0 /f >nul 2>nul
reg add "HKCU\Software\Microsoft\Windows\CurrentVersion\Internet Settings" /v ProxyServer /d "" /f >nul 2>nul
echo 系统代理已关闭,请按任意键退出本窗口...
)
pause>nul
Filed under: 技术归总
0 Comments
59023 Views
Written by 正冰 on 2022, September 27, 2:11 PM
Written by 正冰 on 2022, September 27, 2:11 PM
Written by 正冰 on 2022, September 27, 2:11 PM