MySQL Forums
Forum List  »  Memory Storage Engine

Please Help, 200,000 errors: The table 'session' is full
Posted by: yuntian li
Date: October 28, 2007 09:48PM

MySQL version: 5.0.41, max_heap_table_size = 67108864 in my.cnf

VBB's session table:
CREATE TABLE `session` (
`sessionhash` char(32) NOT NULL default '',
...
`lastactivity` int(10) unsigned NOT NULL default '0',
...
PRIMARY KEY (`sessionhash`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8;


The past 2days, the VBB forum sent me more than 200,000 error email, the subject is: The table 'session' is full, when insert data to the sessin table.
The VBB forum execute sql "DELETE FROM session WHERE lastactivity < UNIX_TIMESTAMP() - 900" every 5 minutes.

I use "SHOW TABLE STATUS LIKE 'session'",the information is:
------------------------
Name : session
Engine : MEMORY
Version : 10
Row_format : Fixed
Rows : 11276
Avg_row_length : 1330
Data_length : 66895872
Max_data_length : 66015880
Index_length : 883728
Data_free : 51566760
Auto_increment
Create_time
Update_time
Check_time
Collation : utf8_general_ci
Checksum
Create_options
Comment
------------------------

The Data_length > Max_data_length, and the Data_free is 51566760. What's the problem, how to avoid the error: the table is full?



Edited 1 time(s). Last edit at 10/28/2007 09:52PM by zgia.

Options: ReplyQuote


Subject
Views
Written By
Posted
Please Help, 200,000 errors: The table 'session' is full
8977
October 28, 2007 09:48PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.