Aurora DB : What is the max columns supported in a table? Also, how do I overcome the "ERROR: Row size too large"?

Asked Nov 11 '20 at 19:34

Active Nov 11 '20 at 19:53

Viewed 711 times

I'm working on a requirement where I need to store data in Aurora DB. First problem is, it's giving below error at the time of dynamic table creation.

"ERROR: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs. [Column limit exceeded]"

Next problem is that the Aurora database is not letting me create a table with more than 200 columns.

I'm using Aurora DB (MySQL 5.7 InnoDB Engine) large instance.

asked Nov 11 '20 at 19:34

sree_me

show the `create table` request that is failing? – ysth Nov 11 '20 at 19:44
1

I've never needed a table of more than, say, 30 columns. It's a relational database so you can break it into multiple tables. – Garr Godfrey Nov 11 '20 at 20:12

Aurora DB : What is the max columns supported in a table? Also, how do I overcome the "ERROR: Row size too large"?

0 Answers0