Re: places index in separate DISK.

[Gleb Paharenko]

Hello.



For a pity in your case it won't help.







>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



Ananda Kumar <[EMAIL PROTECTED]> wrote:



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: places index in separate DISK.

[Ananda Kumar]

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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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
> / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
> <___/ www.mysql.com 
> 
> 
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
> 
>

Re: places index in separate DISK.

[Gleb Paharenko]

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 <[EMAIL PROTECTED]> 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
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

places index in separate DISK.

[Ananda Kumar]

Hi 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