Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to make some approximation of table size for MySQL cluster.
Please read my reasoning and tell me, if I am right or am I making mistake somewhere.

I have simple table with PK (int) and additional column (int). In MySQL int = 4 bytes, so one row is about 12 bytes (4*2 for columns and 4 for PK index).
If I have for example 1'000'000 rows this will be 12'000'000 bytes ~= 11.5MB.
Am I right in this calculations? Can I store such table with so little space?

share|improve this question
up vote 0 down vote accepted

You will need some more space for row overhead and PK storage. More information you can find in MySQL Documentation.

For the most detailed information you can use utility.

share|improve this answer
How much do you mean, when you say "some more". 20%? 50%? 100%? – Michał Herman Sep 24 '13 at 12:48
Use to get full information about space needed. It depends on MySQL Cluster version if additional column can be NULL, etc. – Mindaugas Riauba Sep 24 '13 at 12:55

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.