Home / Questions / 120073
Accepted
lucho
Asked: 2020-11-25 15:33:43 +0800 CST 2020-11-25 15:33:43 +0800 CST

How can I calculate the total size of bytes that a table occupies in mysql?

  • 772

I have created tables in mysql but I need to know how much it occupies in bytes, for example I know that if I have defined an int(7) field it will occupy 4 bytes, but how much does a varchar(n) occupy in bytes how is that size calculated

mysql

1 Answers

  1. Best Answer

    Well I found the pattern for varchars, the size in bytes is determined by the number of characters plus 1, in the case of int and float it is constant in 4 bytes

    • 1