Mysql Replication error "InnoDB: which exceeds the log group capacity 9433498."
Hi Friends,
I had configured Mysql replication.After i had loaded data in to Master server,replication is not working on the slave.The slave is just got stuck at particular point Showing "Waiting for master to send event".At the time of loading data,the slave server was down.Error logs from slave showing that "101005 1:52:50 InnoDB: ERROR: the age of the last checkpoint is 10096168, InnoDB: which exceeds the log group capacity 9433498. InnoDB: If you are using big BLOB or TEXT rows, you must set the InnoDB: combined size of log files at least 10 times bigger than the InnoDB: largest such row.". I guess its a problem with "innodb_log_file size".Currently i hadn't configured no value for "innodb_log_file size".How can i solve the Issue with out loosing data.. Thanks, Ajayan |
Try increasing the size
innodb_log_file_size = make sure you move existing log files before you start mysql again. |
All times are GMT -5. The time now is 08:05 AM. |