Re: places index in separate DISK.

2005-09-16 Thread 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 a

Re: places index in separate DISK.

2005-09-16 Thread 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 PROTE

Re: places index in separate DISK.

2005-09-15 Thread 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 ho

places index in separate DISK.

2005-09-15 Thread 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 a