Log SQL Queries To Mysql (TABLE Storage)

• Tweet
• 

        Add the following lines in the MySQL configuration file (my.cnf or my.ini) to log the queries and the slow queries in a MySQL table: 

slow-query-log
log-output = TABLE
long_query_time = 1
general-log
expire_logs_days = 1

Sample queries: 

select * from mysql.general_log order by event_time desc limit 10;
select * from mysql.slow_log order by start_time desc limit 10;

Tags:
• log
• MySQL
• slow queries