List:Bugs« Previous MessageNext Message »
From:sasha Date:July 15 2000 3:09am
Subject:Re: myisamchk requires 4x disk space to run
View as plain text  
Rick Moore wrote:
> 
> >Description:
> 
> Researched mail archives and couldn't find any info.  Posted to
> mysql@stripped but received no useful responses.
> 
> su-2.03# cd /usr/local/mysql/var/g
> su-2.03# TMPDIR=.
> su-2.03# export TMPDIR
> su-2.03# myisamchk -r -O sort_buffer_size=64M -O key_buffer_size=64M -O
> read_bu
> ffer_size=64M -O write_buffer_size=64M reference.MYI
> - recovering MyISAM-table 'reference.MYI'
> Data records: 93996874
> - Fixing index 1
> Wrong bytesec:   0-  0-  0 at 3488489516; Skipped
> 102370000
> /usr/local/mysql/var/g: write failed, file system is full
> myisamchk: Error writing file './STovF497' (Errcode: 28)
> 
> /usr/local/mysql/var/g: write failed, file system is full
> myisamchk: Error writing file './STovF497' (Errcode: 28)
> myisamchk: error: 28 when fixing table
> MyISAM-table 'reference.MYI' is not fixed because of errors
> Try fixing it by using the --safe-recover (-o) option
> su-2.03#
> 
> In another shell, I check disk space on /usr/local/mysql/var/g while
> myisamchk is running:
> 
> su-2.03# df -k
> Filesystem      1K-blocks     Used    Avail Capacity  Mounted on
> /dev/ad0a           49583    27125    18492    59%    /
> /dev/ad0f        16027176 11486575  3258427    78%    /usr
> /dev/ad0e           19815     2209    16021    12%    /var
> /dev/vinum/raid  69546157 65076511 -1094046   102%    /usr/local/mysql/var/g
> procfs                  4        4        0   100%    /proc
> 
> When myisamchk is complete, I check disk space again:
> 
> su-2.03# df -k
> Filesystem      1K-blocks     Used    Avail Capacity  Mounted on
> /dev/ad0a           49583    27125    18492    59%    /
> /dev/ad0f        16027176 11486575  3258427    78%    /usr
> /dev/ad0e           19815     2211    16019    12%    /var
> /dev/vinum/raid  69546157 15945679 48036786    25%    /usr/local/mysql/var/g
> procfs                  4        4        0   100%    /proc
> su-2.03#
> 
> >How-To-Repeat:
> 
> Rerun the same commands again.  Doesn't matter whether "-q" is present.
> Doesn't matter whether the database has errors or not. Reproducible on
> multiple FreeBSD 4.0 machines.
> 
> >Fix:
> 
> Wish I had one-- this is a serious problem.  It would be cheaper for me to
> buy Oracle than maintain a 4x disk farm.
> 
> You are welcome to access my server if that would help.  Unfortunately the
> database files are rather large, which makes them difficult to send to you.
> If you would be willing to guide me, I'd be happy to try to debug this
> "remotely" for you.
> 
> >Submitter-Id: <submitter ID>
> 
> >Originator: rick
> 
> >Organization: geckobot.com
> 
> >MySQL support: none
> 
> >Synopsis: myisamchk requires 4x disk space to run
> 
> >Severity: serious, critical next time I have a DB error
> 
> >Priority: up to you, but I think it's high  ;)
> 
> >Category: mysql
> 
> >Class:  bug?  design flaw?  not sure
> 
> >Release: mysql-3.23.15-alpha (Source distribution)
> 
> >Environment:

Something is really wrong with your file system on /usr/local/var/g  -- 102%
utilization is definitely wrong :-)

-- 
Sasha Pachev

+------------------------------------------------------------------+
|      ____  __     _____   _____  ___     http://www.mysql.com    |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sasha Pachev            |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     sasha@stripped         |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Provo, Utah, USA        |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                         |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                        |
|             /*/             \*\ Developers Team                  |
+------------------------------------------------------------------+
Thread
myisamchk requires 4x disk space to runRick Moore15 Jul
  • Re: myisamchk requires 4x disk space to runsasha15 Jul
  • Re: myisamchk requires 4x disk space to runRick Moore15 Jul
    • Re: myisamchk requires 4x disk space to runMichael Widenius27 Jul