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)
