>>>>> "Mathijs" == Mathijs Brands <mathijs@stripped> writes:
Mathijs> On Wed, Jan 26, 2000 at 10:42:20AM +0200, Michael Widenius allegedly wrote:
>> We already do the above for compressed tables; We plan to do the above
>> also for other tables in the future; The main problem with using mmap
>> - What happens if you get a read error (and how to detect which file+thread
>> got the read error)
>> - How to extend the file+mmap area if needed; This is particularly
>> tricky when using threads that may be reading the file as you try to
>> insert new rows.
>> - How to deal with memory fragmentation issues on 32 bit
>> operating systems; Just having many files that grows can easily
>> take up your whole process memory and not leave enough room for the
>> normal memory that MySQL needs.
Mathijs> What about tables bigger than 2 GB? Does MySQL use the increased
Mathijs> on a 64 bit architecture?
Yes; MySQL can handle big files if the underlaying OS supports it.
The new RAID option can expand the barrier on 32 bit systems, but this
is still in testing!