distal-attribute
distal-attribute
distal-attribute
distal-attribute

Wrong tables size?

User, date Message
Written by Allineer
2 years ago
Category: General
47 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
2 years ago
4986 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
2 years ago
47 posts since Thu, 01 Jul 10
Thanks
Written by ansgar
2 years ago
4986 posts since Fri, 07 Apr 06
What about posting your values from SHOW TABLE STATUS here?
Written by Allineer
2 years ago
47 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
csvs Aria 10 Page 38164 121 4620288 68719484928 1957888 0 2012-03-09 23:10:44 2012-03-12 22:12:08 2012-03-09 23:11:08 utf8_general_ci page_checksum=1



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
csvs PBXT 10 Dynamic 38164 389 14846820 16777215 4083712 0 utf8_general_ci page_checksum=1

Written by Allineer
2 years ago
47 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.