I built an entire application which stores all its settings in one MySQL table but in 1 row (each setting is another column).
I see now this is a poor design but it would be too much work to change the application.
There are many users using this application so the MySQL table has to be right:
I am getting the following error when trying to update the row (a setting):
Error: Row size too large (> 8123). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORM! AT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline.
I have already changed all the columns I can to TEXT (changing some of the INT ones may break the application)
Under PHP my admin I only see Compact and redundant row formats of which I can switch to.