MySQL Forums
Forum List  »  InnoDB

Re: Innodb with HUGE row of varchar(500)s
Posted by: david Manti
Date: December 30, 2010 07:05AM

I will look into verticle partitioning, thanks. However, I cannot change the varchar(500)'s. Thats a rule I have been given.

The main contention now is this 8K rule for rows in innodb. Nobody seems to know the answer. Is it:
ANY variable length text column is spilled over?
Only variable length columns which are individually over 768 spilled over?
Spill over only occurs if total variable column length combined is over 768?

Nobody seems to know...

Options: ReplyQuote


Subject
Views
Written By
Posted
3318
December 28, 2010 03:45PM
1585
December 29, 2010 11:36PM
Re: Innodb with HUGE row of varchar(500)s
1498
December 30, 2010 07:05AM
1093
December 30, 2010 01:13PM


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.