List:General Discussion« Previous MessageNext Message »
From:dbrb2002-sql Date:March 4 2009 6:22pm
Subject:MySQL Log and Data directories
View as plain text  
On a high read/write load.. is it good to split log (binlogs, innodb txn logs) and data
(all tables, innodb tablespace) in different partitions ?

Anybody had any experience ? 

For example; out of 25 disks array with 142GB 10000rpm... I would like to keep few disks
to logs and rest to data .. is it advised or better to keep everything in spool so that
all spindles can be efficiently managed...

Thanks in advance

Thread
MySQL Log and Data directoriesdbrb2002-sql4 Mar
  • Re: MySQL Log and Data directoriesMichael Dykman4 Mar
    • Re: MySQL Log and Data directoriesChaim Rieger4 Mar
  • Re: MySQL Log and Data directoriesBaron Schwartz4 Mar
Re: MySQL Log and Data directoriesdbrb2002-sql4 Mar
Re: MySQL Log and Data directoriesdbrb2002-sql7 Mar
  • Re: MySQL Log and Data directoriesBaron Schwartz7 Mar