From: Ananda Kumar Date: September 16 2005 10:32am Subject: Re: places index in separate DISK. List-Archive: http://lists.mysql.com/mysql/189164 Message-Id: <829b199c050916033276b809dc@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1910_17881050.1126866745115" ------=_Part_1910_17881050.1126866745115 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi Gleb, I am sorry i forgot to metion the storage engine we are using, its innodb.= =20 The below option is only for myisam engine. Innodb stores data and index in the same file as per documentation.=20 Can you please correct me if i am wrong. regards anandkl On 9/15/05, Gleb Paharenko wrote:=20 >=20 > Hello. >=20 >=20 >=20 > May be DATA DIRECTORY, INDEX DIRECTORY table options will >=20 > be helpful for you. See: >=20 > http://dev.mysql.com/doc/mysql/en/create-table.html >=20 >=20 >=20 >=20 >=20 > Ananda Kumar wrote: >=20 > >i Friends, >=20 > >I am new starter in MYSQL, but have worked extensively in oracle. I=20 > wanted >=20 > >to know how we can place indexes of tables on different disk in MYSQL. >=20 > >Generally in oracle we have the option of specifying the tablespace on >=20 > >different disk. Can we do the same in mysql to disk contention. >=20 > >I am extermelly sorry for making comparison, please forgive me. >=20 > > I am using Linux and MYSQL version 4.1 >=20 >=20 >=20 > -- > For technical support contracts, goto https://order.mysql.com/?ref=3Densi= ta > This email is sponsored by Ensita.NET http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET > <___/ www.mysql.com >=20 >=20 >=20 >=20 > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=3Danandkl@stripped >=20 > ------=_Part_1910_17881050.1126866745115--