MySQL Forums :: InnoDB :: Innodb with HUGE row of varchar(500)s


Advanced Search

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

Hello,

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) - http://forums.innodb.com/read.php?3,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


Subject Views Written By Posted
Innodb with HUGE row of varchar(500)s 2626 david Manti 12/28/2010 03:45PM
Re: Innodb with HUGE row of varchar(500)s 1307 Rick James 12/29/2010 11:36PM
Re: Innodb with HUGE row of varchar(500)s 1207 david Manti 12/30/2010 07:05AM
Re: Innodb with HUGE row of varchar(500)s 931 Rick James 12/30/2010 01:13PM
Re: Innodb with HUGE row of varchar(500)s 881 david Manti 12/30/2010 04:22PM
Re: Innodb with HUGE row of varchar(500)s-- xtradb is not for win os ? 768 Mayur P Vegad 02/23/2011 05:26AM


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.