mercredi 3 décembre 2014

Blob datatype issue with log file


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