Log all queries in MySQL
In MySQL, it is possible to log all queries that were executed. You can view them as a table or file.
Output query history into a table
To output executed queries into a table, run the following MySQL commands:
SET GLOBAL log_output = 'TABLE';
SET GLOBAL general_log = 'ON';
Then, take a look at mysql.general_log table, where you see the query history:
SELECT * FROM mysql.general_log
Output query history into a file
To output query history into a file instead of a table, run the following MySQL commands:
SET GLOBAL log_output = "FILE";
SET GLOBAL general_log_file = "/path/to/your/logfile.log";
SET GLOBAL general_log = 'ON';
Don’t forget to replace "/path/to/your/logfile.log" with the actual log file
you wish to use. Then you can just open the file to see query history. To see
the last 10 line, run the following command:
tail /path/to/your/logfile.log
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
-
How to do error logging in CodeIgniter (PHP)
Code igniter has logging capabilities built-in. Make sure you do the following: Make your /application/logs folder writable In /application/config/config.php set the following: $config['log_thresho...
Questions -
Where can I find error log files for PHP?
PHP stores error logs in /var/log/apache2 if PHP is an apache2 module. Shared hosts are often storing log files in your root directory /log subdirectory. If you are using cPanel, the master log is ...
Questions -
How to Get the Query Executed in Laravel 5
By default, the query log is disabled in Laravel 5: Don’t worry, you can enable the query log by running the following: // enable query log DB::enableQueryLog(); Then you can display the log like t...
Questions -
How to enable MySQL Query Log?
MySQL query log stores the history of executed queries. This history is stored in a log file. On busy servers, this file ca grow very large. To enable the query log, put the following line into /et...
Questions
We are hiring.
Software is our way of making the world a tiny bit better. We build tools for the makers of tomorrow.
Help us in making the internet more reliable.
Help us with developer education and get paid.
Reliability is the
ultimate feature
Delightful observability tools that turn your logs & monitoring into a secret weapon for shipping better software faster.
Explore Better Stack