List:General Discussion« Previous MessageNext Message »
From:Scott Liu Date:April 21 1999 11:32pm
Subject:Re: What are those SQL106d6_0.ISD and SQL106d6_0.ISM
View as plain text  
Our database size is less then 400MB and the largest table has size
of 34 MB.  The next largest has 4.5 MB in size. There is no index
on the largest size table (I am going to add a few now) and there
are one primary key and one index on the next table. Other tables
are much smaller. The first table is for read only (infomation) and
the second involves both read and write operations. All the tables
have limited indexes, 1 or 2.

-rw-rw----   1 root     other    17397130 Feb  9 16:23 zipcode_bank.ISD
-rw-rw----   1 root     other       1024 Feb  9 16:23 zipcode_bank.ISM
-rw-rw----   1 root     other    2216024 Apr 21 16:02 ../candidates/main.ISD
-rw-rw----   1 root     other    1820672 Apr 21 16:02 ../candidates/main.ISM

Now I am fraid that once I index "zipcode_bank" I will probablly have more
chances to
fill up my disk?

Thanks,

Scott

Sasha Pachev wrote:

> 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)

--
Scott Liu
Software Developer
831 460 4300
.....................................................................

TAPESTRY.NET - On Target, Online Recruiting
111 Mission St. Santa Cruz, CA 95060

Visit our web sites at:
http://www.tapestry.net
http://www.asia-net.com      Bilingual Professionals
http://www.developers.net   Software Developers


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