[Gllug] Size of MySQL indexes

[Pooly]

2005/11/7, Dylan <dylan at dylan.me.uk>:
> Hi All,
>
> 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?

Try running an :
OPTIMIZE TABLE your_table
Index spaces are not reclaimed on deletion (nor data space...).

--
Pooly
Webzine Rock : http://www.w-fenec.org/
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug