MySQL Forums
Forum List  »  InnoDB

Row length problems
Posted by: Russell King
Date: September 23, 2008 03:57AM

Hi,

Does anyone know of a way to stop Innodb storing the first 768 bytes of a BLOB field in each row ? This is making the row exceed the maximum size (8k I understand).

I'm trying to migrate our production system to Innodb, but many of the tables have multiple text fields - in some cases over 100! We're running up against this limitation. My understanding was that blob-type fields are stored outside of the row in most databases. Consequently MySQL's "hybrid" approach is causing us a lot of problems.

We're using MySQL 4.1.20, and can potentially upgrade to a version 5.x.x GA release, but not an RC release - (it's a production system).

I'm sure we can't be the only ones who have run into this limitation. So, anyone have any ideas ?

Thanks,

Russ.



Edited 1 time(s). Last edit at 09/23/2008 04:22AM by Russell King.

Options: ReplyQuote


Subject
Views
Written By
Posted
Row length problems
2395
September 23, 2008 03:57AM


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.