Which of the following statements best describe the purpose of the general query log and how you enable it?

Question

Options

• AThe purpose is to record when a client connects or disconnects and record every SQL statement
• BThe purpose is to record SQL statements that are issued to the server for use when restoring
• CThe general query log is enabled with the --general-log or --general-log=file_name option.
• DThe general query log is enabled with the --log or --log=file_name option.

• A
  81% (25)
• B
  6% (2)
• C
  13% (4)

Explanation

The general query log contains a record of when clients connect and disconnect, and the text of every SQL statement received by the server (whether or not it was processed successfully). The server writes statements to the log in the order that it receives them. This log is useful for determining the frequency of a given type of statement or for troubleshooting queries that are not logged to other log files. To enable the general query log, use the --log or --log=file_name option. If no filename is given, the default name is host_name.log, where host_name stands for the server hostname. By default, the server creates the general query log file under the data directory unless you specify an absolute pathname.

No community discussion yet for this question.