Posts MySQL - Error Code- 1118 Row size too large
Post
Cancel

MySQL - Error Code- 1118 Row size too large

merge these to etc/mysql/my.cnf

1
2
3
4
5
6
7
// src - https://stackoverflow.com/a/48841413/1320686

[mysqld]
innodb_log_file_size = 32M
innodb_strict_mode = 0
innodb_page_size =64k
innodb_buffer_pool_size=512M

ofc you have to restart the mysql server, the con @ you have to recreate the whole dbase!, solution working on docker as well.


Build docker image from scratch having these settings, add this command to your docker setup

1
2
3
4
// src - https://stackoverflow.com/a/55826472/1320686

command: ['--innodb_page_size=64k', '--innodb_log_buffer_size=32M', '--innodb_buffer_pool_size=512M']

origin - https://www.pipiscrew.com/?p=16517 mysql-error-code-1118-row-size-too-large

This post is licensed under CC BY 4.0 by the author.
Contents

Trending Tags