Bug #30340 Online Backup: Default drivers create too large backup images

• Submitted: 9 Aug 2007 17:31
• Modified: 30 Oct 2007 14:39
• Reporter: Lars Thalmann
• Status: Duplicate
• Category: MySQL Server: Backup
• Severity: S4 (Feature request)
• Version: 5.2 source
• OS: Any
• Assigned to: Assigned Account
• CPU Architecture: Any

[9 Aug 2007 17:31] Lars Thalmann

Description:
Default drivers (the blocking one and the consistent snapshot one) 
is using the full length of char(X) etc (we use the handler interface
record structure in the backup), and this takes more space than the 
storage engine is using to store the data.

Example:
An Archive table (which is 148MB in size) backup takes up 3GB+ of 
space and naturally runs much longer.  An identical InnoDB table 
that is 1GB in storage also produces a 3GB sized backup.  

How to repeat:
Take backup using some default driver

Suggested fix:
Add some compressing mechanism.

[30 Oct 2007 14:39] Lars Thalmann

Duplicate of BUG#31538.