Is there a way to calculate total data size of column in MySql?

Question

Here is a solution how calculate table size, but what about column? Is there apporoach to calculate data which stored only for 1 column of table?

Note

The question is about data size, not data type size.

Raghbendra Nayak · Answer 1 · 2019-07-17T18:10:56.030

7

You can use below query that will return data size in bytes:

SELECT sum(char_length(comment)) FROM tbl_comments

edited Jul 17 '19 at 18:10

answered May 11 '16 at 03:39

Raghbendra Nayak

1

1) it check only character data 2) I think index data should be added too. – Cherry May 13 '16 at 08:31
1

This only returns the sum of the number of characters all strings in a column have. It is completely useless for numbers, dates, and other than string data. – Kaspis245 Nov 23 '22 at 19:22
And if even one row has NULL in this column then what? – Anton Duzenko Jun 22 '23 at 12:26

score 2 · Answer 2 · answered Jan 12 '17 at 10:33

2

You can check in the storage requirements in the reference manual, and you can calculate your column size.

If you don't want to read too much, you can find some page, where is a collection about sizes and an online calculator: calculator

answered Jan 12 '17 at 10:33

Tibee

1

Welcome to Stack Overflow! Whilst this may theoretically answer the question, [it would be preferable](//meta.stackoverflow.com/q/8259) to include the essential parts of the answer here, and provide the link for reference. – Toby Speight Jan 12 '17 at 10:41
1

Cherry didn't describe specifically what type of column want to use. I can copy-paste the entire reference manual, but it looks easier to link it. Thanks your advice. – Tibee Jan 12 '17 at 11:36

2 Answers2