pt-online-schema-change
错误Threads_running=58 exceeds its critical threshold 50
#pt-online-schema-change --user=root --password= e835 --alter='ENGINE=InnoDB' --socket=/data/db/mysql6980/mysql6980.sock --execute D='discuz_db',t='pre_forum_post'
1> Cannot connect to S=/data/db/mysql6980/mysql6980.sock,h=172.106.301.52,p=...,u=root
1> Cannot connect to S=/data/db/mysql6980/mysql6980.sock,h=172.106.301.53,p=...,u=root
1> Cannot connect to S=/data/db/mysql6980/mysql6980.sock,h=172.106.301.54,p=...,u=root
No slaves found. See --recursion-method if host ca444egi-b44-mys44ql02 has slaves.
Not checking slave lag because no slaves were found and --check-slave-lag was not specified.
Operation, tries, wait:
analyze_table, 10, 1
copy_rows, 10, 0.25
create_triggers, 10, 1
drop_triggers, 10, 1
swap_tables, 10, 1
update_foreign_keys, 10, 1
Altering `discuz_db`.`pre_forum_post`...
Creating new table...
Created new table discuz_db._pre_forum_post_new OK.
Altering new table...
Altered `discuz_db`.`_pre_forum_post_new` OK.
2019-04-24T09:14:44 Creating triggers...
2019-04-24T09:14:44 Created triggers OK.
2019-04-24T09:14:44 Copying approximately 17085984 rows...
2019-04-24T09:14:59 Dropping triggers...
2019-04-24T09:14:59 Dropped triggers OK.
2019-04-24T09:14:59 Dropping new table...
2019-04-24T09:14:59 Dropped new table OK.
`discuz_db`.`pre_forum_post` was not altered.
2019-04-24T09:14:59 Error copying rows from `discuz_db`.`pre_forum_post` to `discuz_db`.`_pre_forum_post_new`: Threads_running=58 exceeds its critical threshold 50
解决办法:
添加: "--critical-load Threads_running=100"项
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· Linux系列:如何用heaptrack跟踪.NET程序的非托管内存泄露
· 开发者必知的日志记录最佳实践
· SQL Server 2025 AI相关能力初探
· Linux系列:如何用 C#调用 C方法造成内存泄露
· AI与.NET技术实操系列(二):开始使用ML.NET
· 无需6万激活码!GitHub神秘组织3小时极速复刻Manus,手把手教你使用OpenManus搭建本
· C#/.NET/.NET Core优秀项目和框架2025年2月简报
· 一文读懂知识蒸馏
· Manus爆火,是硬核还是营销?
· 终于写完轮子一部分:tcp代理 了,记录一下