An error occurred when I analyzed the slow log using the following command：
[root@minghost ~]# pt-query-digest slow.log --user=root --password=123123 --socket=/mydata/mysql.sock --history D=test --since=“2019-10-17 22:00:00” --until=“2019-10-18 04:00:00”
Hello,
Could you provide the slow log?
or could you run query digest putting PTDEBUG=1 pt-query-digest and attach the output?
I cannot see not reproduce the error you mention.
Regards
Hello ，
I am running correctly when using the following command
[root@minghost ~]# pt-query-digest slow.log --user=root --password=123123 --socket=/mydata/mysql.sock --history D=test
Should I not specify --since and --until when using --history?
Hello,
To read from the slog log without using the history table you can just run pt-query-digest
If you want to use the history table, it is not mandatory to use --since nor --until and the --history parameter should have the DSN to connect to the db where the history will be saved like:
pt-query-digest --history h=127.0.0.1,P=3306,u=user,p=password,D=database,t=table
Regards
Ok, thank you very much for your reply.