MySQL Forums
Forum List  »  InnoDB

Innodb with HUGE row of varchar(500)s
Posted by: david Manti
Date: December 28, 2010 03:45PM


I am building a database, it requires each row to be about 60,000 bytes (very close to mysql max row size, basically lots of varchar(500) statements [Its a bad strucutre, but necessary]). now, that is ok in myism as far as I know.

However, I am considering innodb due to its row locking behaviour (I get lots of updates to my table). I have only just come across some troubling information regarding innodb not liking large rows (something about 8000 bytes max or something) -,1196,1204

So, given that my table must have rows of approx 60,000 bytes each, is this a problem for innodb? Is it a big problem? deal breaker? what would you suggest?

Table structure: ID (int, autoinc, primary key), varchar(500), varchar(500)...repeat...varchar(500) until end of table reached

Options: ReplyQuote

Written By
Innodb with HUGE row of varchar(500)s
December 28, 2010 03:45PM
December 29, 2010 11:36PM

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.