List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:March 29 2001 1:54pm
Subject:Re: myisam upgrade problem
View as plain text  
I am not sure how the conversion is done, but if it dumps the data,
renames the old file,
loads the new file, and deletes the dump and old file, it would need
freespace twice the
size of the current table and index.


Hang wrote:
> 
> Thanks!
> 
> So, is there any way to calculate the approximate disk space required
> for the transformation from ISAM to MYISAM?
> 
> Gerald Clark wrote:
> 
> > error 28 is "No space left on device".
> >
> > Hang wrote:
> > >
> > > Greetings,
> > >
> > > I am upgrading my mysql from 3.22.23b to 3.23.35 on RedHat with
> > kernel
> > > 2.4.0. I followed the instructions on the manual for the upgrade.
> > Every
> > > goes fine except I can't convert one table from ISAM to MYISAM.
> > >
> > > I got quite a lot of tables and all can be converted successfully
> > but
> > > not this table. It contains > 3,000,000 rows, 80MB data file and
> > 250MB
> > > index file. I got following error message when I am converting the
> > table
> > > format:
> > >
> > > mysql> alter table mytable type=MYISAM;
> > > ERROR 3: Error writing file '/tmp/ST4kylYE' (Errcode: 28)
> > >
> > > I also found following line by running "ls -al /proc/12121/fd"
> > (12121 is
> > > the pid of the mysqld):
> > >
> > > lrwx------    1 root     root           64 Mar 28 12:25 17 ->
> > > /tmp/ST4kylYE (deleted)
> > >
> > > I had run isamcheck before the conversion and my /tmp got > 400MB
> > disk
> > > space.
> > > Any one have idea what's going wrong?
> > >
> > > Besides, I also have tables on other Linux machines with about
> > 200MB
> > > data and 2.0GB index file. Will there be any problem?
> > >
> > > Pls Help. Thanks.
> > >
> > > --
> > > CH Tsang
> > >
> > >
> > ---------------------------------------------------------------------
> >
> > > Before posting, please check:
> > >    http://www.mysql.com/manual.php   (the manual)
> > >    http://lists.mysql.com/           (the list archive)
> > >
> > > To request this thread, e-mail <mysql-thread69760@stripped>
> >
> > > To unsubscribe, e-mail
> > <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> >
> > > Trouble unsubscribing? Try:
> > http://lists.mysql.com/php/unsubscribe.php
> >
> >
> > --------------------------------------------------------------------
> >
> > Before posting, please check:
> >    http://www.mysql.com/manual.php   (the manual)
> >    http://lists.mysql.com/           (the list archive)
> >
> > To request this thread, e-mail <mysql-thread69813@stripped>
> > To unsubscribe, e-mail
> > <mysql-unsubscribe-hang=outblaze.com@stripped>
> > Trouble unsubscribing? Try:
> > http://lists.mysql.com/php/unsubscribe.php
> 
> --
> CH Tsang
> Outblaze Ltd.
> Em@il: hang@stripped
> 
>
Thread
myisam upgrade problemHang28 Mar
  • Re: myisam upgrade problemGerald Clark28 Mar
  • Re: myisam upgrade problemHang29 Mar
    • Re: myisam upgrade problemBenjamin Pflugmann29 Mar
      • Re: myisam upgrade problemLindsay Adams29 Mar
  • Re: myisam upgrade problemGerald Clark29 Mar