Haitao Jiang <[EMAIL PROTECTED]> wrote: > We are using following steps to re-load and re-build a table every day: > > truncate the table > disable index > load data > enable index > > What are the important parameters I should be watching out to make the > "ebale index" step faster? Out table is over 10million rows and has > two fulltext indexes.
No need to move data back and forth. You can just run optimize table. See http://dev.mysql.com/doc/mysql/en/OPTIMIZE_TABLE.html Also see the myisam_max_sort_file_size and myisam_sort_buffer_size variables at http://dev.mysql.com/doc/mysql/en/Server_system_variables.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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]
