A general purpose MySQL instance is configured with the following options:
— log-slow-queries
— long-query-time=,0001
— log-slow-admin-queries
— general-log
— log-bin
— binlog-format=STATEMENT
— innodb-flush-log-at-trx-commit=1
Which three statements are true?
A.
The General Query Log records more data than the Binary Log.
B.
The binary Log records more data than the General Query Log.
C.
The Slow Query Log records more data than the General Query Log.
D.
The General Query Log records more data than the Slow Query Log.
E.
The Slow Query Log records more data than the Binary Log.
F.
The Binary Log records more data than the Slow Query Log.
Explanation:
E
A, C, F
A, C, E
Turned on the same settings, and the below is the files listed by biggest to smallest.
Slow Query Log
General Query Log
Binary Log
A,D,E
General>Slow>Binary
A D F
A,D,E. — long-query-time=,0001 is too low, and binary traces only replication events.
A,D,E