Which three statements are true?

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 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:



Leave a Reply 7

Your email address will not be published. Required fields are marked *


LnL

LnL

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

kyo

kyo

A,D,E
General>Slow>Binary

Gabriel

Gabriel

A,D,E. — long-query-time=,0001 is too low, and binary traces only replication events.