RE: RAID Question
Paul: Thank you for your response. Another question: Would it cause a problem if I configure --with-raid and then never use it in any programming? Will it add any overhead? It would help if this feature is available for future use. Thanks 2nd time. Kirti -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 10, 2004 8:18 PM To: Kirti S. Bajwa; [EMAIL PROTECTED] Subject: RE: RAID Question At 15:19 -0500 11/10/04, Kirti S. Bajwa wrote: >Hello List: > >System: RH9, MySQL 4.1.7 > >I am in the process of re-setting up (I have test setup 4-5 times) a data >server with the above software. This server consists of 2-CPU (Intel) >RAID-1, 1-40GB IDE HDD for O/S & 2-250GB IDE HDD for storing data. 250 GB >IDE HDD are mirrored (RAID-1). > >Previously, I setup RAID while setting up RH9. Recently, while reviewing the >MySQL, documentation, I noticed the following directive for "configure" >command: > ># ./configure -prefix=/usr/local/mysql -with-raid > >While researching on GOOGLE, I did find quite a bit of information on "MySQL >RAID HOWTO" search, but nothing to answer my question. Can someone explain >how the aboce directive in "configure" works? In my setup, do I need the >above directive as shown? It doesn't have anything to do with hardware raid. It enables support for the RAID table options that allow you to split the data file for MyISAM tables into several files. See the description for RAID_TYPE, RAID_CHUNKS, and RAID_CHUNKSIZE options at: http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: RAID Question
At 15:19 -0500 11/10/04, Kirti S. Bajwa wrote: Hello List: System: RH9, MySQL 4.1.7 I am in the process of re-setting up (I have test setup 4-5 times) a data server with the above software. This server consists of 2-CPU (Intel) RAID-1, 1-40GB IDE HDD for O/S & 2-250GB IDE HDD for storing data. 250 GB IDE HDD are mirrored (RAID-1). Previously, I setup RAID while setting up RH9. Recently, while reviewing the MySQL, documentation, I noticed the following directive for "configure" command: # ./configure prefix=/usr/local/mysql with-raid While researching on GOOGLE, I did find quite a bit of information on "MySQL RAID HOWTO" search, but nothing to answer my question. Can someone explain how the aboce directive in "configure" works? In my setup, do I need the above directive as shown? It doesn't have anything to do with hardware raid. It enables support for the RAID table options that allow you to split the data file for MyISAM tables into several files. See the description for RAID_TYPE, RAID_CHUNKS, and RAID_CHUNKSIZE options at: http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: RAID Question
Hello List: System: RH9, MySQL 4.1.7 I am in the process of re-setting up (I have test setup 4-5 times) a data server with the above software. This server consists of 2-CPU (Intel) RAID-1, 1-40GB IDE HDD for O/S & 2-250GB IDE HDD for storing data. 250 GB IDE HDD are mirrored (RAID-1). Previously, I setup RAID while setting up RH9. Recently, while reviewing the MySQL, documentation, I noticed the following directive for "configure" command: # ./configure prefix=/usr/local/mysql with-raid While researching on GOOGLE, I did find quite a bit of information on "MySQL RAID HOWTO" search, but nothing to answer my question. Can someone explain how the aboce directive in "configure" works? In my setup, do I need the above directive as shown? Thanks. Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
