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.
