Blobs and row formats

MySQL & MariaDB Other MySQL® Questions
1

Hi!

I have a table with multiple blobs on a row.

It would seem that the dynamic or compressed row type would be the most performant for this, but this is only available in innodb barracuda… Are there any plans to port it to xtradb?

Am I totally wrong about this? It would seem that the aim is to generally avoid overflow pages, and any blob bigger than 768 bytes spills over into an overflow with row type compact, which is what xtradb uses?

All wisdom gratefully received!

Matt

2

XtraDB support Barracuda format and compression. It is enabled exactly same way as in Innodb plugin and MySQL 5.5

3

Fantastic!

Thanks for the quick reply, this was not clear from the online docs :slight_smile:

4

Peter wrote on Fri, 25 March 2011 10:39

It is enabled exactly same way as in Innodb plugin and MySQL 5.5 ???

mcdermott cues poison cues predator cues