Labels

Android (1) bash (2) boost (2) C (34) C++ (2) cheatsheet (2) CLion (6) css (3) Debian (33) DL (17) Docker (1) Dreamweaver (2) Eclipse (3) fail2ban (4) git (5) GitHub (4) Hacking (3) html (8) http (1) iOS (1) iPad (1) IRC (1) Java (30) javascript (3) Linux (164) Mac (19) Machine Learning (1) mySQL (47) Netbeans (4) Networking (1) Nexus (1) OpenVMS (6) Oracle (1) Pandas (3) php (16) Postgresql (8) Python (9) raid (1) RedHat (14) Samba (2) Slackware (45) SQL (14) svn (1) tar (1) ThinkPad (1) Virtualbox (3) Visual Basic (1) Visual Studio (1) Windows (2)

Thursday 22 October 2020

To enable MySQL logging during runtime.

 To enable MySQL logging...

 We can enable logging in the cnf file as below;

    [mysqld]
    log = /var/log/mysqld.log
    log-error = /var/log/mysqld.error.log

 We can enable during run time by logging into the MySQL server and executing either of the below;

 To use the mysql.general_log table, do;

SET GLOBAL log_output = "TABLE";
SET GLOBAL general_log = 'ON';

 To use file logging, do;

SET GLOBAL log_output = 'FILE';
SET GLOBAL general_log_file = "/path_to_logfile/mysql.log";
SET GLOBAL general_log = 'ON';

 To disable, do;

SET GLOBAL general_log = 0;


 

 

No comments:

Post a Comment

Note: only a member of this blog may post a comment.