How to show the last queries executed on MySQL?
In MySQL, it is possible to show the last 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.
