MySQL Forums
Forum List  »  MyISAM

Index creation - Disk space requirements
Posted by: estegban wagnerj
Date: January 12, 2010 03:05PM

Hi,

I currently have a MyISAM table(ForecastArchive) with the following columns:
(latitude(float), longitude(float), issuedDate(datetime), value1(float),value2(float),value3(float))

The table is partitionated per month on column issuedDate.

The table data size is of 40 GB.

I want to create an index on (latitude, longitude) columns.

1) I would like to know which would be the resulting index file size?(estimation)

2) Which is the estimated required disk space to create the index?(maybe the engine require more than the final index size to perform the index creation, correct me if I am wrong)


If any can give me a hand on this, I would be grateful.

Thanks.

Esteban.

Options: ReplyQuote


Subject
Views
Written By
Posted
Index creation - Disk space requirements
7307
January 12, 2010 03:05PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.