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.
Aucun commentaire:
Enregistrer un commentaire