Wrong tables size?

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

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