[FAQ] (mydumper:8655): CRITICAL There are queries in PROCESSLIST running longer use --long-query-guard to change the guard value

[问题澄清]

mydumper 导出时报错:

错误:** (mydumper:8655): CRITICAL **: 17:19:35.667: There are queries in PROCESSLIST running longer than 60s, aborting dump, use --long-query-guard to change the guard value, kill queries (–kill-long-queries) or use different server for dump

[原因分析]

如报错提示,在 processlist 中有一些长查询查过了 60s

[解决方案]

参考文档设置参数 -l 7200 尝试.

[参考案例]