pt-find documentation error with mtime and InnoDB
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| Percona Toolkit moved to https://jira.percona.com/projects/PT |
Fix Released
|
Medium
|
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.
http://
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
Create_options:
Comment:
-Eric
Related branches
- Daniel Nichter: Approve
-
Diff: 16 lines (+2/-3)1 file modifiedbin/pt-find (+2/-3)
| Baron Schwartz (baron-xaprb) wrote | #1 |
| 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 |
| Daniel Nichter (daniel-nichter) wrote | #2 |
| Changed in percona-toolkit: | |
| status: | Confirmed → Fix Committed |
| Changed in percona-toolkit: | |
| status: | Fix Committed → Fix Released |
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #3 |
Thanks for the bug report.