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! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]