When you have a numeric field in MySQL(MYISAM) (E.g. Integer) will it always use the same disk space, no matter what number is actually stored?
Tell me more
×
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. It's 100% free, no registration required.
|
MySQL's integers take 4 bytes, regardless of the value you store. (Data storage requirements) MyISAM supports compression, but only with a compressed row format, which makes the table read-only. I don't think I've ever worked on an application where a read-only table was appropriate. |
|||
|
|
