… it on the page and not use external blob storage pages. For example 7KB blob can be stored on the page. However if… thing to beware with Innodb BLOB storage is the fact external blob pages are not shared among the blobs. Each blob, even if it has… some others to external storage. May be one day we’ll come to implementing this in XtraDB 
So BLOB storage was not very…
Post: Blob Storage in Innodb
February 9, 2010 By 13 Comments
Post: Innodb row size limitation
April 7, 2011 By 11 Comments
… version specific, see http://www.mysqlperformanceblog.com/2010/02/09/blob-storage-in-innodb/ for further reference). It’s worth mentioning that…, so for example, you should use a BLOB instead of a TEXT column for storage. You can find more information about this… at once, while one of the interesting things about overflow blob storage is that if the columns aren’t requested as part…
Post: Bug#12704861
November 20, 2011 By 1 Comment
… the full documentation from the release notes: “InnoDB Storage Engine: Data from BLOB columns could be lost if the server crashed at… of a mini-transaction allocated (nonfree=TRUE) before storing the BLOBs, or freed (nonfree=FALSE) before committing the mini-transaction. btr… the reuse of a previously freed B-tree page for BLOB storage. If init_mtr==NULL, try harder to reallocate the specified…
Post: MySQL Blob Compression performance benefits
January 11, 2008 By 17 Comments
… to keep it compressed. Unfortunately MySQL does not provide compressed BLOB/TEXT columns (I would really love to have COMPRESSED attribute… compressing data from TEXT column you should pick BLOB type for compressed data storage. Before going ahead with compression I usually run… were even better because much fewer rows required external storage now. The BLOB/TEXT column compression is not for all workloads. When…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… opinion this however should have been implemented outside of MySQL Storage Engine level for MySQL – reading rows in their physical order… changing default value needs table rebuild even though for other storage engines it often could be done simply by changing meta… often. [+] Blob handling optimizations Jim loves BLOBs as his own child, so Falcon is optimized in Blob handling for example having direct blob writes…
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
… session about PBXT because this is storage engine does not target the same general purpose transactional storage engine market a lot of… efficiently. PBXT team even leads the project to add scalable blob streaming to MySQL which would be fun for many applications… only allowed 45 minutes for Storage Engine presentations. This is complex topic and especially newsly presented storage engines deserved more than 45…
Comment: InnoDB page sizes: plans and ideas
April 22, 2011 By 8 Comments
… larger rows stored on the page (without going to external blob storage) and you have less pages in buffer pool which reduces…
Comment: InnoDB page sizes: plans and ideas
April 21, 2011 By 8 Comments
… larger rows stored on the page (without going to external blob storage) and you have less pages in buffer pool which reduces…
Comment: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… real blobs are stored in a separate storage segment. The huge different from other storage engines that Falcon doesn’t materialize blobs unless the blob is referenced and doesn’t rewrite blobs…
Post: Percona Server 5.5.15-21.0
August 31, 2011 By 9 Comments
… have a TEXT or BLOB field with that engine implementation. To overcome this limitation, the Improved MEMORY Storage Engine is introduced in this release for supporting true VARCHAR, VARBINARY, TEXT and BLOB fields in MEMORY tables… information about the usage and implementation of the Improved MEMORY Storage Engine can be found in its documentation. More Information For…
