Bug #22755 myisampack on partitioned tables
Submitted: 27 Sep 2006 18:56 Modified: 30 Dec 2013 13:22
Reporter: Cuong Nguyen Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5.1.11-beta-log OS:Linux (RHEL 4 AS U3)
Assigned to: CPU Architecture:Any
Tags: myisampack, partition

[27 Sep 2006 18:56] Cuong Nguyen
Description:
Running myisampack with only the "-T tmpdir" option on a partitioned table laid out on three physical disk locations failed with the following report:

table_name gave error 2 on open 

User time 0.00, System time 0.00 
Maximum resident set size 0, Integral resident set size 0 
Non-physical pagefaults 231, Physical pagefaults 0, Swaps 0 
Blocks in 0 out 0, Messages in 0 out 0, Signals 0 
Voluntary context switches 1, Involuntary context switches 0 

How to repeat:
Create a partitioned MyISAM table on different physical locations and attempt to run myisampack on this table.