Wrong tables size?
| User, date | Message |
|---|---|
|
Written by Allineer
1 year ago Category: General 41 posts since Thu, 01 Jul 10 |
I have some table with BLOB field. For a test, table contain 1000 rows. When table using the 'Aria' engine, Heidi shows the size of the table, equal to 19,5Megabytes. When table using the 'PBXT' engine, Heidi shows the size of the table, equal to 530,8Kilobytes. Why? :( |
|
Written by ansgar
1 year ago 4027 posts since Fri, 07 Apr 06 |
HeidiSQL shows the table size as the sum of Data_length + Index_length in a SHOW TABLE STATUS result. Find out what MySQL reports: SHOW TABLE STATUS LIKE 'mytable' |
|
Written by Allineer
1 year ago 41 posts since Thu, 01 Jul 10 |
Thanks |
|
Written by ansgar
1 year ago 4027 posts since Fri, 07 Apr 06 |
What about posting your values from SHOW TABLE STATUS here? |
|
Written by Allineer
1 year ago 41 posts since Thu, 01 Jul 10 |
As example: 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 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 |
|
Written by Allineer
1 year ago 41 posts since Thu, 01 Jul 10 |
oops. this is table without BLOBs. With a BLOB will be later. |
|
Please login to leave a reply, or register at first. |