Re: How much space take each column in table [RESOLVED]

[Brano Gerzo]

Rick,

my respect, this is exactly what I was looking for. Now I know, my blob used almost 10GB of space, I am not sure, if something like this will work:

SELECT (AVG(LENGTH(blob_field)) + 2) * COUNT(*)/1024/1024 FROM tbl;

get the value in MB.

Also thanks for pointing for ANALYSE(), didnt aware of that.

One is learning all the life!