MySQL Forums
Forum List  »  Maria

Re: To developers: If Maria engine does ZERO-VALUE-COMPRESSION ..
Posted by: Sergei Golubchik
Date: March 07, 2008 08:48AM

When ROW_FORMAT=DYNAMIC Maria behaves exactly as MyISAM does, and http://bugs.mysql.com/bug.php?id=30824 applies.

When ROW_FORMAT=PAGE, Maria also does zero-value compression, but it reserves a bit of a space on every page to allow records to grow without overflows. That is, in many cases the record length can be increased without causing a fragmentation. And when the overflow happens the tail of the record is placed on a special overflow page with other record tails, and the record, again, can continue grow without being split in more fragments.

Options: ReplyQuote


Subject
Written By
Posted
Re: To developers: If Maria engine does ZERO-VALUE-COMPRESSION ..
March 07, 2008 08:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.