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 <http://www.mysql.com> > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
