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

From: Marshall Spight <mspight_at_dnai.com>
Date: Tue, 06 Jan 2004 04:30:17 GMT
Message-ID: <tRqKb.296834$_M.1675462@attbi_s54>

"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?

This isn't really a theory question and so is probably off-topic here. You might want to look for some mysql-specific forum. (Amazingly, there doesn't seem to be a "comp.databases.mysql" at least on my newsserver.)

Marshall Received on Mon Jan 05 2004 - 22:30:17 CST