Possibly worse than that, since it will rebuild the 'first' index again.
> -----Original Message-----
> From: mos [mailto:mos99@stripped]
> Sent: Thursday, June 21, 2012 7:51 AM
> To: mysql@stripped> Subject: Re: Indexing about 40 Billion Entries
>
> 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

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.