> -----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.

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




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

Reply via email to