On Thu, May 13, 2004 at 04:51:27PM -0700, Dathan Vance Pattishall wrote:
> > -----Original Message-----
> > From: Tim Cutts [mailto:tjrc@stripped]
> > Sent: Thursday, May 13, 2004 7:11 AM
> > To: MySQL List
> > Subject: Re: InnoDB filesystem
> > On 13 May 2004, at 3:34 pm, Dan Nelson wrote:
> > >>> Pros: performance and bypassing the filesystem cache.
> > MySQL can't use all that memory itself, so it makes sense to allow the
> > OS to cache as much disk space as possible in the memory that MySQL
> > can't use directly?
> It depends, if your datafile is less then 16 GB then the system cache can
> help, but fill up the innodb_buffer_pool you'll get better performance.
> Think of innodb as being its own virtual filesystem. If you have 16GB it's
> probably a 64 bit OS, and mysql is available in 64 bit.
I think that the problem is that it's *not* a 64 bit OS. It's just an
Intel 32bit box with > 4GB of memory. And sine MySQL doesn't do PAE,
it'll never see that extra memory.
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped> | http://jeremy.zawodny.com/
[book] High Performance MySQL -- http://highperformancemysql.com/