Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

What is appropriate value of "innodb_log_file_size" ?

3162671Jan 17 2019 — edited Jan 18 2019

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?

This post has been answered by daniel_hauke on Jan 17 2019
Jump to Answer

Comments

Post Details

Added on Jan 17 2019
2 comments
416 views