mysql - Calculating total data size of BLOB column in a table

Question

I have a table with large amounts of BLOB data in a column. I am writing a utility to dump the data to file system. But before dumping, I need to check if necessary space is available on the disk to export all the blob fields throughout the table.

Please suggest an efficient approach to get size of all the blob fields in the table.

Answer 1

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