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

Wrong tables size?

Allineer posted 3 years ago in General
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? :(
ansgar posted 3 years ago
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'

Allineer posted 3 years ago
Thanks
ansgar posted 3 years ago
What about posting your values from SHOW TABLE STATUS here?
Allineer posted 3 years ago
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

Allineer posted 3 years ago
oops. this is table without BLOBs.
With a BLOB will be later.

Please login to leave a reply, or register at first.