List:General Discussion« Previous MessageNext Message »
From:Ananda Kumar Date:September 16 2005 10:32am
Subject:Re: places index in separate DISK.
View as plain text  
Hi Gleb,
I am sorry i forgot to metion the storage engine we are using, its innodb. 
The below option is only for myisam engine.
 Innodb stores data and index in the same file as per documentation. 
Can you please correct me if i am wrong.
 regards
anandkl

 On 9/15/05, Gleb Paharenko <gleb.paharenko@stripped> wrote: 
> 
> Hello.
> 
> 
> 
> May be DATA DIRECTORY, INDEX DIRECTORY table options will
> 
> be helpful for you. See:
> 
> http://dev.mysql.com/doc/mysql/en/create-table.html
> 
> 
> 
> 
> 
> Ananda Kumar <anandkl@stripped> wrote:
> 
> >i Friends,
> 
> >I am new starter in MYSQL, but have worked extensively in oracle. I 
> wanted
> 
> >to know how we can place indexes of tables on different disk in MYSQL.
> 
> >Generally in oracle we have the option of specifying the tablespace on
> 
> >different disk. Can we do the same in mysql to disk contention.
> 
> >I am extermelly sorry for making comparison, please forgive me.
> 
> > I am using Linux and MYSQL version 4.1
> 
> 
> 
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.NET http://www.ensita.net/
> __ ___ ___ ____ __
> / |/ /_ __/ __/ __ \/ / Gleb Paharenko
> / /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
> <___/ www.mysql.com <http://www.mysql.com>
> 
> 
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
> 
>

Thread
places index in separate DISK.Ananda Kumar15 Sep
  • Re: places index in separate DISK.Gleb Paharenko15 Sep
    • Re: places index in separate DISK.Ananda Kumar16 Sep
      • Re: places index in separate DISK.Gleb Paharenko16 Sep