Re: mysql - How much disk space is used by indexes?

To be consistent one must implement a database space management system for which the source data are database which have database maintenance plans already automated (or at least run routinely).

Database maintenance plans should be therefore implemented, and the index/data useage stats examined after these maintenance plans are done.

ie: What you are looking at might simply be lack of database reoganisation task scheduling.

Pete Brown
Falls Creek
Oz

"Melon" <maikel7_at_poczta.onet.pl> wrote in message news:3ff9bca2_at_news.home.net.pl...
> I couldn't find in mysql documentation any information on how much disk
> space indexes require. I've just created a table - 8 columns and 11
> rows, with 2 indexes on SMALLINT columns - 1 unique and 1 normal. I
> filled the table with some data, there is some text as well but not
> much. Now PhpMyAdmin reports that the data take up 256 bytes while the
> indexes 3,072 bytes. The index file is incredibly large compared to the
> amount of data! Will this ratio remain like this when I insert new data
> into the table? How much disk space do indexes require?
>
Received on Tue Jan 06 2004 - 09:36:14 CET