mysql - How much disk space is used by indexes?
From: Melon <maikel7_at_poczta.onet.pl>
Date: Mon, 05 Jan 2004 20:36:20 +0100
Message-ID: <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 Mon Jan 05 2004 - 20:36:20 CET
Date: Mon, 05 Jan 2004 20:36:20 +0100
Message-ID: <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 Mon Jan 05 2004 - 20:36:20 CET