CODEWITHSUNDEEP
mysqlsql
satheesh.droid
satheesh.droid

Reputation: 31547

How much memory will be occupied by a null value in a DB?

I was wondering how much memory does a null value occupy in a database can anyone answer clearly?

Upvotes: 10

Views: 1857

Answers (1)

Ted Hopp
Ted Hopp

Reputation: 234847

How much space it takes up depends on what the column is defined to be and on the storage engine being used. Some data types take a fixed amount of space regardless of the data stored. There is a small space penalty for declaring a column to accept NULL. Details can be found in this general discussion in the manual and more in the docs about each storage engine.

Upvotes: 5

Related Questions