maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #01313
Re: New Question: Maximum number of columns
-
To:
maria-discuss@xxxxxxxxxxxxxxxxxxx
-
From:
Reindl Harald <h.reindl@xxxxxxxxxxxxx>
-
Date:
Thu, 30 Jan 2014 19:02:56 +0100
-
In-reply-to:
<CAH3kUhHnvbhPw_33=F2_63Bh_8msCgd2J5UWEW_L730PXezS2Q@mail.gmail.com>
-
Openpgp:
id=7F780279; url=http://arrakis.thelounge.net/gpg/h.reindl_thelounge.net.pub.txt
-
Organization:
the lounge interactive design
-
User-agent:
Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.2.0
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 <adam.c.scott@xxxxxxxxx <mailto:adam.c.scott@xxxxxxxxx>>:
>
> 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 <noreply@xxxxxxxxxxxx <mailto:noreply@xxxxxxxxxxxx>> 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
> --------------------------------
Attachment:
signature.asc
Description: OpenPGP digital signature
Follow ups
References