Re: Suggestions for InnoDB files

2011-03-16 Thread Johan De Meersman
- Original Message - From: Adarsh Sharma adarsh.sha...@orkash.com 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

Re: Suggestions for InnoDB files

2011-03-16 Thread Johan De Meersman
From: Adarsh Sharma adarsh.sha...@orkash.com 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

Re: Suggestions for InnoDB files

2011-03-16 Thread Adarsh Sharma
Johan De Meersman wrote: From: Adarsh Sharma adarsh.sha...@orkash.com 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

Re: Suggestions for InnoDB files

2011-03-16 Thread Johan De Meersman
- Original Message - From: Adarsh Sharma adarsh.sha...@orkash.com 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

RE: Suggestions for InnoDB files

2011-03-16 Thread Rolando Edwards
://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: Adarsh Sharma adarsh.sha

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