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

42 user(s) are online (15 user(s) are browsing xpwiki)

Members: 0
Guests: 42

more...

Access Counter

Today : 3122312231223122
Yesterday : 1033710337103371033710337
Total : 2360299223602992236029922360299223602992236029922360299223602992
Powered by XOOPS Cube 2.1© 2001-2006 XOOPS Cube Project
Design by XoopsDesign.com