- View the diff current.
- View the source.
- Go to MySQL/Error.
1: 2015-12-19 (Sat) 19:46:44 iseki | |||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ** MySQL Run Time Error [#ua568b70] | ||
+ | *** InnoDB のログファイルサイズ [#oa327158] | ||
+ | 151219 18:48:00 InnoDB: ERROR: the age of the last checkpoint is 9447278, | ||
+ | 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. | ||
+ | - InnoDB 用のログファイル (ib_logfile0,1) のサイズが小さすぎる | ||
+ | -- MySQL で次のコマンドを実行 | ||
+ | SET GLOBAL innodb_fast_shutdown=0; | ||
+ | -- MySQL を止める | ||
+ | -- ib_logfile0,1 を移動 | ||
+ | mv mysql/ib_logfile* . | ||
+ | -- サイズの変更 | ||
+ | vi /etc/my.cnf | ||
+ | --- [mysqld] に nnodb_log_file_size=64M を追加 | ||
+ | -- MySQL を起動 | ||
+ | #br |
- Backup list of MySQL/Error
- Backup diff of MySQL/Error(No. All)
- 1: 2015-12-19 (Sat) 19:46:44 iseki
- 2: 2015-12-19 (Sat) 19:51:45 iseki
- 3: 2017-07-27 (Thu) 11:45:20 iseki
- Cur: 2021-08-05 (Thu) 19:14:47 iseki