Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

pt-query-digest distills OPTIMIZE statements to empty strings

Description

Hello,

 

OPTIMIZE TABLE table_name distill result given by pt-query-digest is an empty string.

Command line : PTDEBUG=1 ./pt-query-digest-3.5.5 slow_query_files/slow_query_MYOTVMI651S1-test-lock-tables.log --preserve-embedded-
numbers --ignore-attributes arg,cmd,insert_id,ip,port,Thread_id,timestamp,exptime,flags,key,res,val,server_id,offset,end_log_pos,Xid,bytes --limit 100% --ti
meline --show-all Start,End > report 2>&1

I am using pt-query-digest 3.5.5.

The involved MySQL server is in version 8.0.34.

The report result with debug enabled and the input slow log file are attached to this ticket.

 

Best regards.

Alexandre

Environment

None

Attachments

8

Activity

Show:

Aaditya Dubey November 29, 2023 at 8:09 AM

Hi ,

Thank you for the report.
Verified as described.

Alex C November 7, 2023 at 4:58 PM

The same happens with DO, PURGE BINARY LOGS, REPAIR TABLE, GRANT and TABLE  [...] INSERSECT [...] TABLE statements.

I used the same version for pt-query-digest.

MySQL is 8.0.35.

I will attach the corresponding input and ouput files (input-3.log and output-3.txt)

Alex C November 7, 2023 at 4:36 PM

The same happens with PREPARE statements.

I used the same version for pt-query-digest.

MySQL is 8.0.35.

I will attach the corresponding input and ouput files (input-prepare.log and output-prepare.txt)

Alex C November 7, 2023 at 4:25 PM

The same happens with ANALYZE, DESCRIBE and CALL statements.

I used the same version for pt-query-digest.

MySQL is 8.0.35.

I will attach the corresponding input and ouput files (input-2.log and output-2.txt)

 

Details

Assignee

Reporter

Priority

Components

Affects versions

Labels

Needs QA

Yes

Smart Checklist

Created November 6, 2023 at 4:35 PM
Updated February 29, 2024 at 8:35 PM