Bug #41711 please implement myisampack functionality safely within the server
Submitted: 23 Dec 2008 12:29
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S4 (Feature request)
Version:5.x, 6.x OS:Any
Assigned to: Geir Høydalsvik CPU Architecture:Any
Tags: myisampack

[23 Dec 2008 12:29] Shane Bester 
Description:
Using myisampack on a production server is risky due to the chances of corruption and downtime.

This is a feature request to implement this functionality in ALTER TABLE syntax.
The ALTER TABLE command should be safe to run to compress tables, even base tables that are being accessed via merge tables and views at the same time.

How to repeat:
http://dev.mysql.com/doc/refman/5.0/en/myisampack.html

"If the mysqld server was invoked with external locking disabled, it is not a good idea to invoke myisampack if the table might be updated by the server during the packing process. It is safest to compress tables with the server stopped."
[23 Dec 2008 12:29] MySQL Verification Team 
Related: bug #18692 and bug #41709