0

I am getting continuously below error message in mysqld.log

[ERROR] InnoDB: The total blob data length (10152274) is greater than 10% of the redo log file size (3072). Please increase innodb_log_file_size.

The size of tables which are having blob datatype is 690 MB. The size of each ib_logfile is 48MB

As per the error message should I increase my ib_logfiles to more than 69MB. If so, when again if data of blob tables increases to 10GB, should I increase my log files to 1 GB.

Please suggest me how to resolve this, and how are these dependent to each other.

OS is Linux MySQL version is 5.6.21

Later, I had changed all the columns whose datatype from BLOB to TEXT. Now there are BLOB datatype tables only in 'mysql' schema. Even after converting the datatype, I am observing the above error message.

  • What version of MySQL is this ? – RolandoMySQLDBA Dec 3 '14 at 18:13
  • What operating system are you running MySQL under ? – RolandoMySQLDBA Dec 3 '14 at 18:14
  • OS - Linux MySQL - 5.6.21 – Phanindra Dec 3 '14 at 18:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.