[Gllug] Size of MySQL indexes

[Minty]

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