I've read that Mysql server creates a log file where it keeps a record of all activities - like when and what queries execute. Can anybody tell me where it exists in my system? How can I read it?

Jun 25, 2011 · To enable the query log, put this in /etc/my.cnf in the [mysqld] section. Also, to enable it from MySQL console. See http://dev.mysql.com/doc/refman/5.1/en/query-log.html. For mysql 5.1.29+. With mysql 5.1.29+ , the log option is deprecated. To specify the logfile and enable logging, use this in my.cnf in the [mysqld] section:

Set general_log_file to specify the name of the log file. If a log file already is open, it is closed and the new file is opened. When the general query log is enabled, the server writes output to any destinations specified by the log_output system variable. If you enable the log, the server opens the log file and writes startup messages to it ...

To write general query log entries to the log table and the log file, use --log_output=TABLE,FILE to select both log destinations and --general_log to enable the general query log.

Jul 1, 2024 · Enabling the MySQL General Query Log is a useful way to keep track of the SQL statements executed on your MySQL server. This query log can be instrumental in troubleshooting, performance optimization, and security analysis.

Nov 20, 2008 · Is it possible for me to turn on audit logging on my mysql database? I basically want to monitor all queries for an hour, and dump the log to a file. For readers benefit: Don't miss to read the question in the above comment. To turn logging on/off without restarting mysql, see …

Feb 7, 2022 · General Query Log. The general query log in MySQL can be used to view what’s happening on your MySQL server. In the following examples, we’ll use Workbench to setup viewing this log from a table and from a file. Log to Table. First, let’s show how to log to a table. We’ll set general_log=1 and specify that we want to log to a table:

The General Query Log contains a listing of general information from client connects, disconnects, and queries. It is invaluable for debugging, yet it poses as a hindrance to performance (citation?). An example view of a General Query Log is seen below:

Oct 10, 2018 · Instead of restarting MySQL you can do this: The server will immediately start logging to `mysql`.`general_log`. By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

To specify the initial general query log state explicitly, use --general_log[={0|1}]. With no argument or an argument of 1, --general_log enables the log. With an argument of 0, this option disables the log. To specify a log file name, use --general_log_file=file_name.