Re: Indexing about 40 Billion Entries

[mos]

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