At 02:04 AM 6/21/2012, you wrote:
Thank you a lot. The first indexing process finished after about 13
hours, so I think the problem is solved now.
I set the myisam_sort_bufffer_size to 10GB.
The "first indexing process"???
You should have created all of your indexes with one Alter statement.
Otherwise it will take another 13+ hours to build the second index
because it has to create a copy of the table all over again.
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql