Re: Does a blank field take up disk space?
From: The Natural Philosopher <tnp_at_invalid.invalid>
Date: Fri, 29 Jul 2016 16:44:55 +0100
Message-ID: <nnftln$r18$2_at_news.albasani.net>
Date: Fri, 29 Jul 2016 16:44:55 +0100
Message-ID: <nnftln$r18$2_at_news.albasani.net>
On 29/07/16 15:23, bit-naughty_at_hotmail.com wrote:
> If I have a field, say "Price", and there has been nothing put into
> that field in a particular line (but there may be something in that
> field on *other* lines), I assume it doesn't take up space on the
> disk? (I have very little idea about what data structures MySQL uses
> to do its shit - what *is* it, anyway?)
>
>
> Thanks.
>
https://dev.mysql.com/doc/internals/en/myisam-introduction.html
https://dev.mysql.com/doc/internals/en/innodb-field-contents.html
-- "Women actually are capable of being far more than the feminists will let them."Received on Fri Jul 29 2016 - 17:44:55 CEST