Possibly worse than that, since it will rebuild the 'first' index again. > -----Original Message----- > From: mos [mailto:mo...@fastmail.fm] > Sent: Thursday, June 21, 2012 7:51 AM > To: mysql@lists.mysql.com > 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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
