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.