pt-find documentation error with mtime and InnoDB

Bug #1013407 reported by Eric H
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Toolkit moved to
Fix Released
Daniel Nichter

Bug Description

There is an error in the pt-find man page.

"Find InnoDB tables that haven’t been updated in a month, and convert them to MyISAM storage engine (data warehousing, anyone?

        pt-find --mtime +30 --engine InnoDB --exec "ALTER TABLE %D.%N ENGINE=MyISAM""

It is technically impossible to find InnoDB tables by last modified time because InnoDB does not maintain update time in metadata.

You can see this in show table status.

Name: some_table
         Engine: InnoDB
        Version: 10
     Row_format: Compact
           Rows: 7
 Avg_row_length: 2340
    Data_length: 16384
Max_data_length: 0
   Index_length: 16384
      Data_free: 0
 Auto_increment: 8
    Create_time: 2012-06-11 14:46:48
    Update_time: NULL
     Check_time: NULL
      Collation: latin1_swedish_ci
       Checksum: NULL


Tags: docs pt-find

Related branches

Revision history for this message
Baron Schwartz (baron-xaprb) wrote :

Thanks for the bug report.

Changed in percona-toolkit:
status: New → Confirmed
importance: Undecided → Medium
tags: added: docs pt-find
Changed in percona-toolkit:
assignee: nobody → Daniel Nichter (daniel-nichter)
milestone: none → 2.1.6
Revision history for this message
Daniel Nichter (daniel-nichter) wrote :

Changed the example. It's not as cool, but it's still a usage example for what it's worth.

Changed in percona-toolkit:
status: Confirmed → Fix Committed
Brian Fraser (fraserbn)
Changed in percona-toolkit:
status: Fix Committed → Fix Released
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to:

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers