Re: MySQL Log and Data directories

2009-03-07 Thread Baron Schwartz
5/10 .. so whats the typical IO (rnd rw) that you > archive/expect on high trafficked sites ? > > --- On Wed, 3/4/09, Baron Schwartz wrote: > > From: Baron Schwartz > Subject: Re: MySQL Log and Data directories > To: dbrb2002-...@yahoo.com > Cc: mysql@lists.mysql.com > Dat

Re: MySQL Log and Data directories

2009-03-06 Thread dbrb2002-sql
and Data directories To: dbrb2002-...@yahoo.com Cc: mysql@lists.mysql.com Date: Wednesday, March 4, 2009, 11:40 AM On Wed, Mar 4, 2009 at 1:22 PM,  wrote: > On a high read/write load.. is it good to split log (binlogs, innodb txn > logs) and data (all tables, innodb tablespace) in dif

Re: MySQL Log and Data directories

2009-03-04 Thread Baron Schwartz
On Wed, Mar 4, 2009 at 1:22 PM, wrote: > 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 1rpm... I would like

Re: MySQL Log and Data directories

2009-03-04 Thread dbrb2002-sql
Lets say HP Modular Storage/Smart Array.. http://h18006.www1.hp.com/storage/disk_storage/msa_diskarrays/san_arrays/index.html From: Chaim Rieger Subject: Re: MySQL Log and Data directories To: "Michael Dykman" Cc: dbrb2002-...@yahoo.com, mysql@lists.mysql.com Date: Wednesday, March 4

Re: MySQL Log and Data directories

2009-03-04 Thread Chaim Rieger
Michael Dykman wrote: On Wed, Mar 4, 2009 at 1:22 PM, wrote: 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 1rpm.

Re: MySQL Log and Data directories

2009-03-04 Thread Michael Dykman
On Wed, Mar 4, 2009 at 1:22 PM, wrote: > 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 1rpm... I would like

MySQL Log and Data directories

2009-03-04 Thread dbrb2002-sql
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 1rpm... I would like to keep few disks to logs and rest to data .. is