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 /etc/my.cnf file in
the [mysqld] section:
general_log_file = /path/to/query.log
general_log = 1
Alternatively, you can do this at runtime by running 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 the "/path/to/your/logfile.log" with the path to the
actual log file you wish to store the logs.
Then you can see the logs in the /path/to/your/logfile.log file.
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: ...
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 -
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...
Questions