I have table which is big enough, phpmyadmin shows that it takes more than 40Gb space. I can't remove data from it, but I've figure out one thing: there is one field which is described as
There are always latin symbols.
I thought that changing collation to latin1_general_ci would reduce the Table size.
I've tried this out on small version of it with 200 Mb but I did not get expected result :(
Why so ?
MySQL's documentation for utf8 shows that it will use 1 byte for Latin characters, and only use more if the situation requires them.
Therefore, if you're only using normal latin characters, both utf8_general_ci and latin1_general_ci will use between 1 and 4 bytes: one byte to store the length (0-3 characters), and then up to three bytes for the actual text.
If the value of this field will always be exactly three characters, you could save one byte by changing the column from a
varchar(3) to a
char(3) (as long as you also use
If it's not exactly three characters, it's likely to be more efficient to leave it as a
varchar - there's not much more you can do to reduce the size of this field. However, with a 40GB table you can hopefully find something else to optimise!
External links referenced by this document: