MySQL: Row is too large
If you have the following error on Mac OS X,
Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROWFORMAT=DYNAMIC or ROWFORMAT=COMPRESSED
You must configure the mysql server.
Edit your file ~/.my.cnf
(see Where is the my.cnf file ?)
[mysqld]
max_allowed_packet = 1G
innodb_log_file_size = 2G
innodb_log_buffer_size = 512M
Then restart mysql server. If you installed mysql with brew, the command to restart is mysql.server restart
Written by Pierre-Louis LAUNAY
Related protips
Have a fresh tip? Share with Coderwall community!
Post
Post a tip
Best
#Mac os x
Authors
Sponsored by #native_company# — Learn More
#native_title#
#native_desc#