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/
