- 论坛徽章:
- 0
|
谢谢楼上的朋友
现在故障又出现了,而且频率更高了,可能是刚又装了一个phpbb的论坛,网上搜索后发现:
http://www.2is.net/blog/?cat=8
HEAP的phpbb_session表
2006年07月25日 星期二
http://www.2is.net/bbs/显示如下错误:
—————————————–
phpBB : Critical Error
Error creating new session
DEBUG MODE
SQL Error : 1114 The table ‘phpbb2mod_sessions’ is full
INSERT INTO phpbb2mod_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in, session_admin) VALUES (’462ad24bc46034016bda33d87cd7c6b6′, -1, 1153812799, 1153812799, ‘db8f2f12′, 0, 0, 0)
Line : 186
File : sessions.php
————————————–
问了半天没人理,只好自己研究!
phpbb2mod_sessions is Full?
phpbb2mod_sessions 不能Check,Repair, Optimize…
而且phpbb2mod_sessions 不同于其他MyISAM表,竟然是HEAP类型
看了一下安装时的phpbb mysql schema文件:
————————————–
#
# Table structure for table ‘phpbb_sessions’
#
# Note that if you’re running 3.23.x you may want to make
# this table a type HEAP. This type of table is stored
# within system memory and therefore for big busy boards
# is likely to be noticeably faster than continually
# writing to disk …
#
————————————–
可是我的phpbb是2020啊,手动把phpbb2mod_sessions表类型更换为MyISAM
一切正常
可是我对mysql不熟悉,不知道如何改,还请大侠不吝赐教!![](static/image/smiley/default/em14.gif) ![](static/image/smiley/default/em14.gif) |
|