#author("2024-09-02T06:37:00+00:00","default:iseki","iseki") #author("2024-09-02T06:37:12+00:00","default:iseki","iseki") ** 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] に innodb_log_file_size=64M を追加 -- MySQL を起動 #br *** redo log size [#u31f0ae3] InnoDB: The total blob data length (15867691) is greater than 10% of the total redo log size (134217728). Please increase total redo log size. - my.cnf で innodb_log_file_size, innodb_buffer_pool_size のサイズを増やす [mysqld] innodb_log_file_size=512M innodb_buffer_pool_size=1024M