MySQL Forums
Forum List  »  Memory Storage Engine

Re: Why Index Lengh grow up
Posted by: Leo Chan
Date: October 09, 2005 10:40PM


I have an error when the Index_Length grow to certain value, the MySQL response table is full no matter no data or few data inside. I use show status and get the following
mysql> show table status like 'DATA_SM' \G;
*************************** 1. row ***************************
Name: mytbl
Engine: HEAP
Version: 9
Row_format: Dynamic
Rows: 10350
Avg_row_length: 401
Data_length: 4182720
Max_data_length: 154020491
Index_length: 1655421092
Data_free: 802
Auto_increment: NULL
Create_time: NULL
Update_time: NULL
Check_time: NULL
Collation: latin1_swedish_ci
Checksum: NULL
Create_options: max_rows=3000000
1 row in set (0.00 sec)

I not sure is the Index_length not synchronized cause this error but I very sure the database has just few records inside and should not give table is full.

Is this a bug or else, please help and this is a urgent matter as I need to change my design to not use HEAP if having this kind of error.

Options: ReplyQuote

Written By
October 02, 2005 11:43PM
Re: Why Index Lengh grow up
October 09, 2005 10:40PM
October 10, 2005 07:29PM
October 17, 2005 10:59AM
April 05, 2006 02:47AM

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.