MySQL Forums
Forum List  »  MyISAM

MyISAM index issue
Posted by: Wayne Clancy
Date: February 11, 2013 10:48AM

Hi

I was wondering if anyone can point me in the right direction. I have a problem on 5.1.66 running on Centos 6.

Any MyISAM table which is indexed creates a *.MYI fil 1GB in size even if the index is only a few kb. Well when I say 1GB in size, that's the reported size using du or dk however ls reports the correct size.

At first I thought this might be a operating system / FS issue but when I optimized one of the affected tables the problem went away..until it was re-indexed.

Any help on this matter would be really appreciated as I've spent most of the day trying to figure this out.

Regards

Wayne

Options: ReplyQuote


Subject
Views
Written By
Posted
MyISAM index issue
2337
February 11, 2013 10:48AM
1401
February 12, 2013 10:08AM


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.