maria-discuss team mailing list archive

[Roberto Spadim <roberto@xxxxxxxxxxxxx>]

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>:

> 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> 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
>> --------------------------------
>>
>> To view or answer this question please visit:
>> http://mariadb.com/kb/en/maximum-number-of-columns/
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~maria-discuss
>> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~maria-discuss
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Roberto Spadim
SPAEmpresarial
Eng. Automação e Controle