Trace the SQL Queries in MYSQL

Trace the SQL Queries in MYSQL

For trace, the Queries executing from the application side in MariaDB provides a general_log parameter for enabling and disabling the traces.

Check status of General Log

mysql> select @@general_log;

For Enable the trace of SQL Queries:

mysql> set global general_log=1;

mysql> select @@general_log;

For Disable the trace of SQL Queries:

set global general_log=0;

Check and change the general log output as FILE or TABLE

-- Check the log file output format:

mysql> select @@log_output;

Check the file location:

mysql> select @@general_log_file;

--Change the log file format to TABLE:

SET GLOBAL log_output='TABLE';

Check the table for Log generation or SQL traces:

select * from mysql.general_log;

--Empty the table if no need

truncate table mysql.general_log;