mysql的错误日志可能输出_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 over overrun 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, during the time.)

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