Skip to:

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

pt-table-usage output only returns dates instead of complete timestamp

Description

I am running pt-table-usage on a general log of a MySQL 5.6 database. The log has timestamps of the following format. 

When I run pt-table-usage against it. I get an output with the date and the table name not the complete timestamp.

Is it a bug or am I just doing it wrong?

Environment

CentOS 7

AMD64

Smart Checklist

Activity

Show:

Lalit Choudhary November 26, 2020 at 3:20 PM

Hi

Thank you for the report.

Yes, it works as expected with slow log.

pt-table-usage reads queries from a log and analyzes how they use tables. The log should be in MySQL’s slow query log format.

Qasim Mehmood October 14, 2020 at 2:32 PM

Going by the code it looks like it shouldn't be returning the date at all. The first column is supposed to be the `context` probably because it is considering it as a slow log.

Qasim Mehmood October 14, 2020 at 1:42 PM

Here is a sample log format

The output I get after pt-table-usage mysqld.log is something like

Not a Bug

Details

Assignee

Reporter

Priority

Smart Checklist

Created October 14, 2020 at 1:33 PM
Updated February 29, 2024 at 8:56 PM
Resolved November 26, 2020 at 3:21 PM