List:General Discussion« Previous MessageNext Message »
From:mfatene Date:May 24 2005 8:34pm
Subject:Re: data length vs index length ??
View as plain text  
Hi,
if you have a lot of indexes on your table, it's normal that they consume  more
than data. That's the general case in a lot of databases.

You've just to monitor index usage and drop the unused ones, before they impact
the insert/update/delete performance.

Mathias

Selon Michael Gale <michael.gale@stripped>:

> Hello,
>
> Currently I have a large mysql table (36 million rows) and according to
> the mysql-admin the data length is 6.5GB and my index length is 8.8GB.
>
> I am new to mysql, but I would assume that my index should not consume
> more space then my data ?
>
> But in order to provide the data in a timely manner I do not believe I
> can remove any of my indexes as there were all added as a result of a
> query taking 30-40 minutes.
>
> Michael
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>


Thread
data length vs index length ??Michael Gale24 May
  • Re: data length vs index length ??mfatene24 May
  • Re: data length vs index length ??Dan Nelson24 May
  • Re: data length vs index length ??SGreen24 May
  • classic outer join problemHank24 May
    • Re: classic outer join problemSGreen24 May
    • Re: classic outer join problemmfatene25 May