Can pt-query-digest work if I set log_output to=‘TABLE’?
Meaning it won’t use a log file but a table to store the slow queries data?
You should never set log_output=TABLE. The performance of your MySQL server will be horrendously affected. The slow log, as a file, is near-zero impact to MySQL running. Make sure your slow log file is rotated after a gig or two.
Use Percona Monitoring and Management (PMM) to perform live, always up-to-date, query analysis, instead of pt-query-digest.