MySQL: Log to table

log_to_table.sql

-- Turn on table based logging
set global log_output = 'TABLE';

-- Turn on general log
set global general_log = 'ON';

-- Log everything to slow query log
set global log_slow_queries = 1;
set global long_query_time = 0.000001;

--Take a look at the table mysql.general_log
select * from mysql.general_log
select * from mysql.slow_log;

--Filter on the current connection
select connection_id() into @cid;
select * from mysql.`general_log` where thread_id=@cid;