I try to use pt-query-digest version 3.0.3 for save queries from slow in mysql using function --review. After pt-query-digest analyzed slow.log file with very long query and put it to db/review table, then make SQL request "SELECT sample from query;" i got only part of very long request finished at '280788', '543436', '25760', '102092', '53947', '398066', '165905', '358762', '146480', '167429', '108590', '659041', '352966', '41082', '539416', '166070', '536148', '145889', '309654', '168230', '145889', '145637', '143462', '
Medium
Launchpad: https://bugs.launchpad.net/percona-toolkit/+bug/1701507
I try to use pt-query-digest version 3.0.3 for save queries from slow in mysql using function --review.
After pt-query-digest analyzed slow.log file with very long query and put it to db/review table, then make
SQL request "SELECT sample from query;" i got only part of very long request finished at '280788', '543436', '25760', '102092', '53947', '398066', '165905', '358762', '146480', '167429', '108590', '659041', '352966', '41082', '539416', '166070', '536148', '145889', '309654', '168230', '145889', '145637', '143462', '
pt-query-digest --user root --ask-pass --create-review-table --review h=localhost,D=slow_log,t=query --report-format query_report --type slowlog log.txt
In attachment have sample of slow log, and You can try it by self for check.