MySQL Forums
Forum List  »  Performance

Re: Is BLOB stored in InnoDB buffer pool?
Posted by: Rick James
Date: February 03, 2009 12:34AM

When you request fields other than the blob, (I believe) it does not fetch the blob's block(s).

I have used a similar trick quite successfully in MyISAM -- vertically partition the table so that the meta info is in one table, and the blob (preferably compressed) is in a parallel table. This makes lengthy SELECTs that don't need the blob (eg, statistics about the rows) run much faster.

With the InnoDB "plugin", the 768 changes to 0, like my trick in MyISAM. I can't say whether this makes the plugin faster than regular InnoDB or not.

768 = 256*3. Utf8 characters are up to 3 bytes. Coincidence?

With the 768 rule, short blobs will be in the row; long ones will spill to elsewhere. Again, this is at least sometimes good.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Is BLOB stored in InnoDB buffer pool?
2055
February 03, 2009 12:34AM


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.