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
