Re: Why Index Lengh grow up

[Leo Chan]

Hi,

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
Comment:
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.