Calculating total data size of BLOB column in a table

mysql blob

You can use the MySQL function OCTET_LENGTH(your_column_name). See here for more details.

mysql blob

select sum(length(blob_column)) as total_size from your_table

mysql blob

select sum(length(blob_column_name)) from desired_tablename;

CodeHunter