Forum Moderators: open
"mysql> SHOW TABLE STATUS;
+------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-------------------+----------+----------------+---------+
¦ Name ¦ Engine ¦ Version ¦ Row_format ¦ Rows ¦ Avg_row_length ¦ Data_length ¦ Max_data_length ¦ Index_length ¦ Data_free ¦ Auto_increment ¦ Create_time ¦ Update_time ¦ Check_time ¦ Collation ¦ Checksum ¦ Create_options ¦ Comment ¦
+------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-------------------+----------+----------------+---------+
¦ shws ¦ HEAP ¦ 9 ¦ Fixed ¦ 704044 ¦ 13 ¦ 11286720 ¦ 9087650 ¦ 5899448 ¦ 0 ¦ NULL ¦ NULL ¦ NULL ¦ NULL ¦ latin1_swedish_ci ¦ NULL ¦ ¦ ¦
+------------+--------+---------+------------+--------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-------------------+----------+----------------+---------+
5 rows in set (0.00 sec)"
"max_heap_table_size" is 33554432 which is less then Data_length above (11286720).
What is the problem?
I searched mysql's bug database again and found out that this is a bug. [bugs.mysql.com...]
Thank you for the reply