[CSCripMa]

Hi,

Code:

(error #1118) Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.

I was reading that i need to remake my table structure, changing innodb_file_format to barracuda row format dynamic, but that didn't help i still sometimes get this error. Maybe possible to make higher value of this limit > 8126? because i save a lot of text, last kill player names, last 20 send messages and so on and i unable to minimise it, and with time i create more and more collums and in future this will be bigger problem.

[Vince]

Make more tables, more rows and less columns. If you have message1 through message20 then evidently you will hit that limit. Anything that has a number behind it must be split into different tables where the number essentially becomes the id, i.e.:

Messages

id	userId	message
1	7	message 1
2	7	message 2
3	7	message 3
...	...	...
19	7	message 19
20	7	message 20

[CSCripMa]

What is limit of columns?

[mirou123]

Quote:

Originally Posted by CSCripMa What is limit of columns?

4096.
Read this for more information.