Данная ошибка говорит о том, что значение innodb_log_file_size слишкам мало, и его нужно увеличить и крайне желательно при этом почистить сам лог фаил.
При этой ошибке могут быть проблемы:
+Accommodate any big BLOB or TEXT fields
+Holding bigger transactions
Решение:
STEP 01) Change the following in /etc/my.cnf
[mysqld]
innodb_log_buffer_size = 32M
innodb_buffer_pool_size = 3G
innodb_log_file_size = 768M
STEP 02) mysql -uroot -p -e"SET GLOBAL innodb_fast_shutdown = 0;"
STEP 03) service mysql stop
STEP 04) rm -f /var/lib/mysql/ib_logfile*
STEP 05) service mysql start
Проверяем:
mysql -e "show variables" |grep innodb_log_file_size
innodb_log_file_size 52428800
Пояснение
innodb_fast_shutdown = 0 (При этой опции mysql при остановки службы объединит лог с БД и после остановки лог файлы можно удалять)
Небольшое пояснение:
The InnoDB shutdown mode. If the value is 0, InnoDB does a slow shutdown, a full purge and a change buffer merge before shutting down. If the value is 1 (the default), InnoDB skips these operations at shutdown, a process known as a fast shutdown. If the value is 2, InnoDB flushes its logs and shuts down cold, as if MySQL had crashed; no committed transactions are lost, but the crash recovery operation makes the next startup take longer.
The slow shutdown can take minutes, or even hours in extreme cases where substantial amounts of data are still buffered. Use the slow shutdown technique before upgrading or downgrading between MySQL major releases, so that all data files are fully prepared in case the upgrade process updates the file format.
Use innodb_fast_shutdown=2 in emergency or troubleshooting situations, to get the absolute fastest shutdown if data is at risk of corruption.
