flagflag  
1: 2015-12-19 (Sat) 19:46:44 iseki source
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


Front page   New List of Pages Search Recent changes   Help   RSS of recent changes (RSS 1.0) RSS of recent changes (RSS 2.0) RSS of recent changes (RSS Atom)

Site Search

Login

Username:

Password:


Lost Password?
Register now!!

Sub Menu

mini Calendar

Last MonthMay 2024Next Month
Su Mo Tu We Th Fr Sa
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31
Today

Who's Online

61 user(s) are online (8 user(s) are browsing xpwiki)

Members: 0
Guests: 61

more...

Access Counter

Today : 2024202420242024
Yesterday : 8599859985998599
Total : 2364903023649030236490302364903023649030236490302364903023649030
Powered by XOOPS Cube 2.1© 2001-2006 XOOPS Cube Project
Design by XoopsDesign.com