Welcome to WebmasterWorld Guest from 54.167.29.208

Forum Moderators: open

mySQL column limit

max number / size

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

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 13, 2002
posts: 2167
votes: 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
3:01 pm on Jan 25, 2018 (gmt 0)

Senior Member

WebmasterWorld Senior Member topr8 is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Apr 19, 2002
posts:3355
votes: 39


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.
3:24 pm on Jan 25, 2018 (gmt 0)

Junior Member from CA 

Top Contributors Of The Month

joined:Mar 2, 2017
posts:48
votes: 5


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

But, some people recommend 1,000 columns.
[stackoverflow.com...]
4:52 am on Feb 6, 2018 (gmt 0)

New User

joined:Feb 3, 2018
posts:6
votes: 1


hey mates! I can give you a link, which can help you to know about MySQL columns.
[dev.mysql.com ]
7:17 am on Feb 6, 2018 (gmt 0)

Senior Member

WebmasterWorld Senior Member 10+ Year Member

joined:June 13, 2002
posts: 2167
votes: 0


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