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

Wrong tables size?

Allineer posted 5 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 5 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 5 years ago
Thanks
ansgar posted 5 years ago
What about posting your values from SHOW TABLE STATUS here?
Allineer posted 5 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 5 years ago
oops. this is table without BLOBs.
With a BLOB will be later.

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