mySQL column limit

Forum Moderators: open

Message Too Old, No Replies

mySQL column limit

max number / size

aspdaddy

8:08 am on Jan 25, 2018 (gmt 0)

I've found when I have a dozen or very large text fields or a high number of columns in a table , there is a limit in the product that causes an error.

Has anyone here come across this before or know any fixes ? I can find documentation on it yet I can repeat it , its looks like the total byte size of a tables columns is limited, rather than the number of columns.

I'm using Ubuntu, Apache Tomcat / Java and Maria DB - which I'm told is identical to mySQL

Thanks

topr8

3:01 pm on Jan 25, 2018 (gmt 0)

i don't think mariaDB and mySQL are identical anymore, they both developed seperately for a while.
it seems that columnStore is specially developed for very large text or blob columns ... i think it will be generally available at some point as a storage engine within mariaDB, but i think currently it is only available with the enterprise version. i've not used columnStore myself so cannot be sure of this but it could be worth investigating.

JonathanEdmonton

3:24 pm on Jan 25, 2018 (gmt 0)

It's not about the number of columns. It's about size.
[stackoverflow.com...]

But, some people recommend 1,000 columns.
[stackoverflow.com...]

MattCarson

4:52 am on Feb 6, 2018 (gmt 0)

hey mates! I can give you a link, which can help you to know about MySQL columns.
[dev.mysql.com ]

aspdaddy

7:17 am on Feb 6, 2018 (gmt 0)

Thanks all - yes that's it, I'm using Maria DB & InnoDB engine. I'll have a look inro columnStore