文章讲述了在MySQL5.7中遇到多线程复制导致的Note级别错误日志频繁打印问题，这些日志影响了error log的分析效率并可能导致磁盘空间占用过大。作者通过分析源码发现，日志打印频率受三个条件控制，并且可以通过设置log_error_verbosity参数来过滤Note级别的日志，将其改为2即可仅保留错误和警告信息。
mysql5.7,启用基于logical_clock的多线程复制,发现error日志增长很快，查看日志发现大量关于多线程复制的Note级别日志。
2018-07-03T03:22:01.638371+08:00 8941 [Note] Multi-threaded slave statistics for channel '': seconds elapsed = 298; events assigned = 3043329; worker queues filled over ove
rrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 725810947700 waited (count) when Workers occupied = 5346 wait
ed when Workers occupied = 0
2018-07-03T03:24:22.589147+08:00 8941 [Note] Multi-threaded slave statistics for channel '': seconds elapsed = 141; events assigned = 3044353; worker queues filled over ove
rrun level = 0; waited due a Worker queue full = 0; waited due the total size = 0; waited at clock conflicts = 725810947700 waited (count) when Workers occupied = 5346 wait
ed when Workers occupied &
最低0.47元/天 解锁文章
2222
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
