search

DrRichCarpenter / check-unused-keys

Automatically exported from code.google.com/p/check-unused-keys
0 stars 0 forks source link

Estimate Index Size #2

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
(from email w/PZ)

Yes I think so. BTW the duplicate-key-checker from maatkit already does it.
Though I'm not sure what formula it uses.

The one I provided is for Innodb 

> > Hey Peter,
> >
> > You said:
> >
>> > > You can also estimate logical length of indexes in Innodb as
>> > > num_rows*(10+length_of_key+length_of_primary_key)
> >
>> > > The true index size often will be 1.5 times larger or so due to
pages not
>> > > fully filled with data.
> >
> > Do you think this is useful?  If so, I can add this

Original issue reported on code.google.com by ppc.perc...@gmail.com on 15 Jul 2009 at 7:26

GoogleCodeExporter commented 9 years ago

Original comment by ryan.a.l...@gmail.com on 14 Nov 2009 at 6:15

GoogleCodeExporter commented 9 years ago

Original comment by ryan.a.l...@gmail.com on 17 Nov 2009 at 7:18