http://dev.mysql.com/doc/refman/5.5/en/column-count-limit.html
normally you have a serious problem if you reach that limits because it won't scale well and the scheme is at least questionable select(*) even with most empty will create large results inserts/updates are much slower Am 30.01.2014 18:50, schrieb Roberto Spadim: > hum, unireg is the "global" limit, there's some ideas to change the .frm file > and create a better one with less > limits (drizzle database have it done), but you have limits in each engine > too, index size have limits, many limits > per engine exists, i think a max columns is just more one > > how many columns you need? i think it's the best question, after that select > a engine, if it's not a good engine, > create many tables and use spider engine to group all tables (vertical > partition) ? > > > 2014-01-30 Adam Scott <[email protected] > <mailto:[email protected]>>: > > I believe it's the same as in MySQL. It does depend on the engine your > table is using. By default it is > probably InnoDB. > > For the full details about the limits: > > http://www.mysqlperformanceblog.com/2013/04/08/understanding-the-maximum-number-of-columns-in-a-mysql-table/ > > > > > On Thu, Jan 30, 2014 at 9:45 AM, AskMonty KB <[email protected] > <mailto:[email protected]>> wrote: > > Hello, > > A new question has been asked in "MariaDB FAQ" by robpaton: > -------------------------------- > Hi there, > > What is the maximum number of columns a row can have in MariaDB? I > can't find this info anywhere on the web. > > Best regards, > Rob > --------------------------------
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
