maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #04851
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;