Bug #67963 InnoDB wastes almost one extent out of every innodb_page_size pages
Submitted: 22 Dec 2012 6:51 Modified: 2 Nov 2015 12:52
Reporter: Jeremy Cole (Basic Quality Contributor) (OCA) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:All OS:Any
Assigned to: Shaohua Wang CPU Architecture:Any
Tags: extents, innodb, space, waste

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[13 May 2014 23:24] Jeremy Cole
Illustration showing ~24.8% waste from innodb_page_size=4k with compressed table with 1k pages

Attachment: innodb_bug_67963_4k_1k.png (image/png, text), 75.74 KiB.