search cancel

MYSQL Query Logging


Article ID: 214602


Updated On:


CA Network Flow Analysis (NetQos / NFA)


When working with support is is often useful to have a log of queries run on the MySQL database. Here is the procedure to turn mysql query logging on and off.


To enable Query Logging, run the following in a cmd prompt:


    Mysql -unetqos -pnetqos


Or (if you want to enable this for the Harvester’s custom mysql storage engine)


     Mysql -P3307 -unetqos -pnetqos


Mysql query logging will log ALL queries that are running in the background while it is enabled.

With NFA Services running it can log A LOT of output, so it should only be enabled for a short period of time.  


It is a helpful tool to find which tables are being updated during  a specific task or when loading a specific web page.  

To set the log file name:

     SET GLOBAL general_log_file='log.log';


To turn on the logging run the command below, I recommend having the task you want to trace ready to go before enabling it.


     set global general_log = 'ON';


Then reproduce whatever action you are trying to trace, then quickly run the command below to stop the query logging.


     set global general_log = 'OFF';

The log file will be in the \CA\NFA\Mysql\data\ directory.