List:General Discussion« Previous MessageNext Message »
From:Dathan Vance Pattishall Date:May 13 2004 11:51pm
Subject:RE: InnoDB filesystem
View as plain text  

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

> 
> Tim
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1



Thread
InnoDB filesystemJFL13 May
  • Re: InnoDB filesystemJeremy Zawodny13 May
    • Re: InnoDB filesystemJFL13 May
      • Re: InnoDB filesystemDan Nelson13 May
        • Re: InnoDB filesystemTim Cutts13 May
          • RE: InnoDB filesystemDathan Vance Pattishall14 May
            • Re: InnoDB filesystemJeremy Zawodny14 May
              • RE: InnoDB filesystemDathan Vance Pattishall14 May
                • Re: InnoDB filesystemTim Cutts14 May
              • Re: InnoDB filesystemChris Nolan14 May
                • Re: InnoDB filesystemJeremy Zawodny14 May