List:General Discussion« Previous MessageNext Message »
From:Jeremy Zawodny Date:May 13 2004 9:46am
Subject:Re: InnoDB filesystem
View as plain text  
On Thu, May 13, 2004 at 11:00:17AM +0200, JFL wrote:
> I've been told that InnoDB on a raw partition is the fastest setup.

Actually, you've been told that it's probably the fastest.

> To setup my system for this, could I create a partition called /innodb 
> and adjust the my.cnf like this?
> 
> innodb_data_home_dir = /innodb
> innodb_log_group_home_dir = /var/lib/mysql/
> innodb_log_arch_dir = /var/lib/mysql/

Nope.

> I suppose that innodb_log_group_home_dir and innodb_log_arch_dir can not 
> be on a raw disk?

Check the InnoDB docs.  They explain how to setup raw disk
partitions.  You'll be using device names, not mount points.

> Any other tips, pros and cons?

Pros: performance and bypassing the filesystem cache.

Cons: loss of transparency and limited backup options.

Jeremy
-- 
Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped>  |  http://jeremy.zawodny.com/

[book] High Performance MySQL -- http://highperformancemysql.com/
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