[Gllug] Size of MySQL indexes
Minty
mintywalker at gmail.com
Wed Nov 9 19:54:41 UTC 2005
On 11/7/05, Dylan <dylan at dylan.me.uk> wrote:
> I'm building a MySQL database at the moment. It contains a table with 13
> VARCHAR(255) fields and an ID field of type INT which is the primary
> key. The data in the table totals 1,114KB, but I notice the index is
> over 21,000KB. Since the index only contains references to an INT
> field, why is it so bg?
Not sure it applies to the indexes (but rather the tables), but if the
table type is myisam and read only, then myisampack can compress it
down a bit
http://dev.mysql.com/doc/refman/4.1/en/compressed-format.html
--
Gllug mailing list - Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug
More information about the GLLUG
mailing list