Forum Stats

  • 3,732,984 Users
  • 2,246,665 Discussions
  • 7,856,453 Comments

Discussions

What is appropriate value of "innodb_log_file_size" ?

3162671
3162671 Member Posts: 2
edited January 2019 in MySQL Community Space

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?

Tagged:

Best Answer

Answers

Sign In or Register to comment.