← Back to team overview

maria-discuss team mailing list archive

slow_query_log: Binlog Dump

 

these entries are *not* helpful when you need to seek for real queryies like a needle

SET timestamp=1509853561;
# administrator command: Binlog Dump;
# Time: 171105  4:47:04
# User@Host: replication[replication] @  [192.168.196.106]
# Thread_id: 415842  Schema:   QC_hit: No
# Query_time: 62.807846  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
# Rows_affected: 0
SET timestamp=1509853624;
# administrator command: Binlog Dump;
# Time: 171105  4:49:04
# User@Host: replication[replication] @  [192.168.196.106]
# Thread_id: 415899  Schema:   QC_hit: No
# Query_time: 120.228237 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0
# Rows_affected: 0
SET timestamp=1509853744;
# administrator command: Binlog Dump;
# Time: 171105  4:51:01
# User@Host: replication[replication] @  [192.168.196.106]
# Thread_id: 416036  Schema:   QC_hit: No
# Query_time: 117.412204 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0
# Rows_affected: 0
SET timestamp=1509853861;
# administrator command: Binlog Dump;
# Time: 171105  4:52:01
# User@Host: replication[replication] @  [192.168.196.106]
# Thread_id: 416184  Schema:   QC_hit: No
# Query_time: 60.132083  Lock_time: 0.000000  Rows_sent: 1  Rows_examined: 0
# Rows_affected: 0
SET timestamp=1509853921;
# administrator command: Binlog Dump;
# Time: 171105  4:56:01
# User@Host: replication[replication] @  [192.168.196.106]
# Thread_id: 416257  Schema:   QC_hit: No
# Query_time: 240.021180 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0
# Rows_affected: 0
SET timestamp=1509854161;
# administrator command: Binlog Dump;
# Time: 171105  4:58:08
# User@Host: replication[replication] @  [192.168.196.106]
# Thread_id: 416567  Schema:   QC_hit: No
# Query_time: 127.012674 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0
# Rows_affected: 0
SET timestamp=1509854288;
# administrator command: Binlog Dump;