Home
News
Forum
Wiki
Blog
Contents
Gallery
Movies
Downloads
About NSL
[
List of Titles
|
List of Pages
|
New
|
Search
|
Recent changes
|
Help
]
MySQL/Error
[
Front page
]
[ ]
Start:
** MySQL Run Time Error
*** InnoDB のログファイルサイズ
151219 18:48:00 InnoDB: ERROR: the age of the last chec...
InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must...
InnoDB: combined size of log files at least 10 times big...
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
InnoDB: The total blob data length (15867691) is greater...
- my.cnf で innodb_log_file_size, innodb_buffer_pool_siz...
[mysqld]
innodb_log_file_size=512M
innodb_buffer_pool_size=1024M
End:
** MySQL Run Time Error
*** InnoDB のログファイルサイズ
151219 18:48:00 InnoDB: ERROR: the age of the last chec...
InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must...
InnoDB: combined size of log files at least 10 times big...
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
InnoDB: The total blob data length (15867691) is greater...
- my.cnf で innodb_log_file_size, innodb_buffer_pool_siz...
[mysqld]
innodb_log_file_size=512M
innodb_buffer_pool_size=1024M
Page:
Site Search
Advanced Search
Login
Username:
Password:
Lost Password?
Register now!!
Sub Menu
New Arrivals
Books
Web Links
Site Map
e-Learning
TUIS Certificate
mini Calendar
May 2024
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
40 user(s) are online (8 user(s) are browsing xpwiki)
Members: 0
Guests: 40
more...
Access Counter
Today :
Yesterday :
Total :
Powered by XOOPS Cube 2.1© 2001-2006
XOOPS Cube Project
Design by
XoopsDesign.com