MySQL general log on table

MySQL general log on table.md

Save MySQL general log on table instead of a log file.

Turn on general log to table

SET GLOBAL general_log = 'OFF';
ALTER TABLE `mysql`.`general_log` ENGINE = MyISAM;
ALTER TABLE `mysql`.`slow_log` ENGINE = MyISAM;
SET GLOBAL general_log = 'ON';

Show last executed queries

-- limits are good friends
SELECT * FROM `mysql`.`general_log` ORDER BY event_time DESC LIMIT 100;