mysql案例~mysql常见日志错误

⼀ 简介: mysql note级别⽇志汇总⼆错误系列

1 Aborted connection

1 [Note] Aborted connection 61 to db: 'unconnected' user: ‘mha’ host: ‘197.xx.xx.xx(Got an error reading communication packets) 2 [Note] Aborted connection 61 to db: 'unconnected’' user: ‘mha’ host: ‘197.xx.xx.xx(Got timeout reading communication packets) 分析

1 代表由于⽹络中断导致的连接断开

2 代表由于超过timeout时间导致的连接断开 2 SLAVE多线程同步的信息

[Note]Multi-threaded slave statistics for channel ”: seconds elapsed = 121; eventsassigned = 100374529; worker queues filled overoverrun level = 0; waited due aWorker queue full = 0; waited due the total size = 0; waited at clock conflicts= 1451875661700 waited(count) when Workers occupied = 3211993 waited whenWorkers occupied = 445032386000

分析 此信息常见于并⾏复制的循环打印,⼏乎每隔120秒，就有上述⽇志的输出 通常出现在slave并⾏复制有延迟的情况下 3 page_cleaner线程的输出⽇志

[Note] InnoDB:page_cleaner: 1000ms intended loop took 4750ms.The settings might not beoptimal. (flushed=1519 and evicted=0, duringthe time.)

分析 此信息代表page_cleaner刷新⽐原定的循环时间next_loop_time多3000毫秒