From: Rick James
Date: June 21 2012 8:48pm
Subject: RE: Indexing about 40 Billion Entries
List-Archive: http://lists.mysql.com/mysql/227723
Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB14876082D5@SP2-EX07VS01.ds.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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
>=20
> 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.
>=20
> The "first indexing process"???
>=20
> 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.
>=20
> Mike
>=20
>=20
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql