List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:April 21 1999 10:34pm
Subject:Re: What are those SQL106d6_0.ISD and SQL106d6_0.ISM
View as plain text  
Scott Liu wrote:
> 
> Thanks for the reply.  I have other questions on these files.  At one time
> the *.ISD and *.ISM files growed to ~40GB and they filled up all our
> disk space. I do not know what happened and why it happened. Does
> any one know if we can prevent this from happening? Or if we can set
> up a process to detect this and respond accordingly? I just used
> "isamchk -s datadir/*.ISM" and no error messages on all my tables.
> 
> Thanks,
> 
> Scott Liu
> 
> Sasha Pachev wrote:
> 
> > Scott Liu wrote:
> > >
> > > In our /var/tmp directory, there are serveral *.ISD and *.ISM files
> > > with serveral hundred MB. They are dated April 6. My guess is
> > > that at one time (April 6), MySQL died and it left these files in the
> > > /var/tmp. Am I right? Is it safe to remove them now? Thanks.
> > >
> > > Scott Liu
> > > Software Developer
> > > 831 460 4318
> > > .....................................................................
> >
> > Most likely, yes, but I would back them up just in case.
> >
> > --
> > Sasha Pachev
> > http://www.sashanet.com/ (home)
> > http://www.direct1.com/ (work)
> >
> > ---------------------------------------------------------------------
> > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> > posting. To request this thread, e-mail mysql-thread2193@stripped
> >
> > To unsubscribe, send a message to the address shown in the
> > List-Unsubscribe header of this message. If you cannot see it,
> > e-mail mysql-unsubscribe@stripped instead.
> 
> --
> Scott Liu
> Software Developer
> 831 460 4300

How much data do you have, and how are you indexing? The
sizes of isd and ism files are determined by the amount
of data you have and the number on indeces.


-- 
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)
Thread
What are those SQL106d6_0.ISD and SQL106d6_0.ISMScott Liu21 Apr
  • Re: What are those SQL106d6_0.ISD and SQL106d6_0.ISMSasha Pachev21 Apr
    • Re: What are those SQL106d6_0.ISD and SQL106d6_0.ISMMichael Widenius22 Apr
  • Re: What are those SQL106d6_0.ISD and SQL106d6_0.ISMScott Liu22 Apr
  • Re: What are those SQL106d6_0.ISD and SQL106d6_0.ISMSasha Pachev22 Apr
  • Re: What are those SQL106d6_0.ISD and SQL106d6_0.ISMScott Liu22 Apr