Tuesday, April 19, 2022

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;

No comments:

Post a Comment