What is appropriate value of "innodb_log_file_size" ?

3162671

We use MySQL 5.6.24.

The following error occured.

2019-01-17 09:23:20 3359 [ERROR] InnoDB: The total blob data length (96270729) is greater than 10% of the total redo log size (805306368). Please increase total redo log size.

And, present setting values in the MySQL option file (my.cnf) are as follows.

innodb_log_file_size = 256M

innodb_log_files_in_group = 3

What does the number in the log ("96270729" or "805306368") refer to? Is the unit of the number "byte"?

How much does the setting value in the MySQL option file (my.cnf)  in order not to cause an similar error?

And, after we will change the "innodb_log_file_size" in the MySQL option file (my.cnf) , what procedure will we do to start up MySQL?

daniel_hauke

Hi,

you can take a look at the following: https://stackoverflow.com/questions/25277452/how-to-configure-mysql-5-6-longblob-for-large-binary-data

daniel_hauke

Hi,

you can take a look at the following: https://stackoverflow.com/questions/25277452/how-to-configure-mysql-5-6-longblob-for-large-binary-data

3162671

Hi,

Thank you for your response. We have solved our problem.