Re: InnoDB filesystem

[Chris Nolan]

Jeremy Zawodny wrote:

On Thu, May 13, 2004 at 04:51:27PM -0700, Dathan Vance Pattishall wrote:
 

-----Original Message-----
From: Tim Cutts [mailto:[EMAIL PROTECTED]
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.
 

Didn't InnoDB gain PAE support on some platforms a little while ago?

Best regards,

Chris

Jeremy
 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]