List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:March 16 2000 12:49am
Subject:Re: HELP! I need REALLY BIG Tables!
View as plain text  

Hi!

>>>>> "sasha" == sasha  <sasha@stripped> writes:

sasha> Ben Willis wrote:
>> 
>> Hi Sasha,
>> 
>> I tried the C program, and (at first) it didn't work - it died at 2GB.
>> Then I recompiled it as follows:
>> 
>> % gcc -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -o bigfile bigfile.c
>> 
>> And this worked!!
>> 
>> I asked our local guru and he said that normally on Solaris an app
>> has to make special calls to take advantage of large files, for instance one
>> needs to call 'fseeko()' rather than 'fseek()'.  Is MySQL using stdio for
>> database access?  This would be surprising if it is...
>>
>> Is it okay to recompile MySQL from source in LP64 mode?  This basically
>> converts longs and pointers from 4 bytes to 8 bytes.  Can MySQL handle
>> this?
>> 
>> Thanks again,
>> Ben

Yes;  MySQL 3.23 works perfectly with big files on Solaris;  We use
ourselves big MyISAM tables ( > 8G) on our Solaris 2.7 computers...

MySQL will by default apply the needed defines to handle big files
when you configure MySQL 3.23 on Solaris >= 2.6

(We do also map fseek() to fseeko() to be able to handle big log files)

Regards,
Monty
Thread
HELP! I need REALLY BIG Tables!Ben Willis15 Mar
  • Re: HELP! I need REALLY BIG Tables!sinisa15 Mar
  • Re: HELP! I need REALLY BIG Tables!Ben Willis15 Mar
  • Re: HELP! I need REALLY BIG Tables!sasha15 Mar
  • Re: HELP! I need REALLY BIG Tables!Ben Willis16 Mar
  • Re: HELP! I need REALLY BIG Tables!sasha16 Mar
    • Re: HELP! I need REALLY BIG Tables!Michael Widenius16 Mar
    • Re: HELP! I need REALLY BIG Tables!Vivek Khera16 Mar
  • Re: HELP! I need REALLY BIG Tables!Paul D. Smith16 Mar
    • Re: HELP! I need REALLY BIG Tables!Michael Widenius16 Mar
  • Re: HELP! I need REALLY BIG Tables!sasha16 Mar
  • Re: HELP! I need REALLY BIG Tables!Ben Willis16 Mar
    • Re: HELP! I need REALLY BIG Tables!Michael Widenius16 Mar
  • Re: HELP! I need REALLY BIG Tables!Ben Willis16 Mar
    • Re: HELP! I need REALLY BIG Tables!Michael Widenius17 Mar
  • Re: HELP! I need REALLY BIG Tables!Ben Willis6 Apr
    • Re: HELP! I need REALLY BIG Tables!Thimble Smith7 Apr
    • Re: HELP! I need REALLY BIG Tables!Michael Widenius7 Apr
RE: HELP! I need REALLY BIG Tables!Quentin Bennett16 Mar