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]