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
