List:General Discussion« Previous MessageNext Message »
From:Adrian Phillips Date:May 8 2000 3:24pm
Subject:Re: AIX Filesize troubles
View as plain text  
>>>>> "David" == David Weis <djweis@stripped> writes:

    David> On Mon, 8 May 2000 sinisa@stripped wrote:
    >> David Weis writes: > I'm running MySQL 3.22.32 on a machine
    >> with AIX 4.3.2. I was replicating a > large database over to
    >> MySQL (approx 10,000,000 records). It got to > 6,200,000
    >> records and stopped with this message > DBD::mysql::st execute
    >> failed: Got error 27 from table handler at > ./replicate.pl
    >> line 51.  > Got error 27 from table handler at ./replicate.pl
    >> line 51.  > > I checked the file size, it was 1073741312 bytes,
    >> which is 1023 megs > (1073741312/1048576). We're fine for free
    >> space on the partition, > > [root@abbott access]# df -k /opt >
    >> Filesystem 1024-blocks Free %Used Iused %Iused Mounted on >
    >> /dev/lv00 12058624 10890504 10% 900 1% /opt > > Large file
    >> enabled is set to false in smit and won't let me change it. Any
    >> > ideas? Please cc me, I'm not on the list.
    >> 
    >> You should switch to 3.23, best use 3.23.15 as soon as it is
    >> out, build it with large file support and transfer your tables
    >> to MyISAM format with a script provided with 3.23 distribution.

    David> Okay, any ETA for 3.23.15? I see .14 out there now.

    >> Before you do that, check if your file system will support
    >> large files, by manually creating a huge file, e.g. by use of
    >> cat program.

    David> My dd if=/dev/zero of=largefile bs=1048576 count=1050 ended
    David> at 1023 megs again. It's odd that I can't get larger than a
    David> 1 gig file.

Hmm, ulimit ? 

    >> If you have problems with that install some other file system,
    >> like Verilog or JFS.

    David> It's a JFS partition right now.

(4.3 does support large files but I'm not sure if its enabled by
default)

Sincerely,

Adrian Phillips
Thread
AIX Filesize troublesDavid Weis8 May
  • Re: AIX Filesize troublessinisa8 May
    • Re: AIX Filesize troublesDavid Weis8 May
      • Re: AIX Filesize troublessinisa8 May
      • Re: AIX Filesize troublesAdrian Phillips8 May
Re: AIX Filesize troublesRalph Corderoy10 May
  • Re: AIX Filesize troublesDavid Weis10 May
    • Re: AIX Filesize troublesThimble Smith10 May