RE: Suggestions for InnoDB files

2011-03-16 Thread Rolando Edwards
http://www.linkedin.com/in/rolandoedwards -Original Message- From: Adarsh Sharma [mailto:adarsh.sha...@orkash.com] Sent: Wednesday, March 16, 2011 5:33 AM To: Johan De Meersman Cc: mysql@lists.mysql.com Subject: Re: Suggestions for InnoDB files Johan De Meersman wrote: >> From: &quo

Re: Suggestions for InnoDB files

2011-03-16 Thread Johan De Meersman
- Original Message - > From: "Adarsh Sharma" > Johan De Meersman wrote: > A Heartiest Thanks from my heart for explaining all these things in a > fantastic manner. I agreed with your suggestions but one thing which > isn't explained from your side , as you go deeper in RAID point. > Q:-

Re: Suggestions for InnoDB files

2011-03-16 Thread Adarsh Sharma
Johan De Meersman wrote: From: "Adarsh Sharma" Johan De Meersman wrote: Interesting, but why like this instead of simply larger disks or raidsets ? It's the IT-Admin Issue , I can't question that and we have only disks of 300GB ( SAS ). Your admin is supposed to provide se

Re: Suggestions for InnoDB files

2011-03-16 Thread Johan De Meersman
> From: "Adarsh Sharma" > > Johan De Meersman wrote: > > Interesting, but why like this instead of simply larger disks or raidsets ? > > It's the IT-Admin Issue , I can't question that and we have only disks of > 300GB ( SAS ). Your admin is supposed to provide services that benefit the applicat

Re: Suggestions for InnoDB files

2011-03-15 Thread Johan De Meersman
- Original Message - > From: "Adarsh Sharma" > > Dear all, > > I have doubt regarding the storage structure for Innodb files : > > Our database server has the following paths : > > /dev/sda5 69G 35G 32G52% /hdd1-1 > /dev/sdb1 274G 225G 36G 87% /hdd2

Suggestions for InnoDB files

2011-03-15 Thread Adarsh Sharma
Dear all, I have doubt regarding the storage structure for Innodb files : Our database server has the following paths : /dev/sda5 69G 35G 32G52% /hdd1-1 /dev/sdb1 274G 225G 36G 87% /hdd2-1 /dev/sdc5 274G 225G 36G 87% /hdd3-1 /dev/sdd5