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]