From: Rick James
Date: September 27 2012 8:26pm
Subject: RE: checking progress of alter table on an InnoDB table (Was: Re:
 checking progress of alter table on a MyISAM table)
List-Archive: http://lists.mysql.com/mysql/228275
Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB148CF91DC2@SP2-EX07VS01.ds.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64

SXNuJ3QgQUxURVIgYSBEREwsIG5vdCBETUw/ICBTbyBJIGRvbid0IHRoaW5rIHlvdSB3b3VsZCBm
aW5kIGFueXRoaW5nIGluIHVuZG8gbG9ncy4NCg0KPiAtLS0tLU9yaWdpbmFsIE1lc3NhZ2UtLS0t
LQ0KPiBGcm9tOiBMYXJyeSBNYXJ0ZWxsIFttYWlsdG86bGFycnkubWFydGVsbEBnbWFpbC5jb21d
DQo+IFNlbnQ6IFRodXJzZGF5LCBTZXB0ZW1iZXIgMjcsIDIwMTIgMToyMCBQTQ0KPiBUbzogUmlj
ayBKYW1lcw0KPiBDYzogbXlzcWwgbWFpbGluZyBsaXN0DQo+IFN1YmplY3Q6IGNoZWNraW5nIHBy
b2dyZXNzIG9mIGFsdGVyIHRhYmxlIG9uIGFuIElubm9EQiB0YWJsZSAoV2FzOiBSZToNCj4gY2hl
Y2tpbmcgcHJvZ3Jlc3Mgb2YgYWx0ZXIgdGFibGUgb24gYSBNeUlTQU0gdGFibGUpDQo+IA0KPiBT
byB3ZSBjaGFuZ2VkIHRoZSB0YWJsZSBmcm9tIE15SVNBTSB0byBJbm5vREIuIEkgcmVhZCB0aGF0
IHRoZSAndW5kbw0KPiBsb2cgZW50cmllcycgc2hvd24gaW4gJ3Nob3cgZW5naW5lIGlubm9kYiBz
dGF0dXMnIHdvdWxkIGNvcnJlc3BvbmQgdG8NCj4gdGhlIG51bWJlciBvZiByb3dzIHRoYXQgaGF2
ZSBiZWVuIG9wZXJhdGVkIG9uIHRocm91Z2hvdXQgdGhlIHByb2Nlc3Mgb2YNCj4gdGhlIEFMVEVS
LiBUaGUgdGFibGUgd2UncmUgYWx0ZXJpbmcgaGFzIDExNSwwOTYsMjA1IHJvd3MsIGFuZCB0aGUN
Cj4gYWx0ZXIncyBiZWVuIHJ1bm5pbmcgZm9yIDI4IGhvdXJzLCBhbmQgdGhlIHVuZG8gbG9nIGVu
dHJpZXMgaXMgOTMwOS4NCj4gQWxzbyB0aGF0IG51bWJlciBzZWVtcyB0byBnbyB1cCBhbmQgZG93
bi4gU28gY2xlYXJseSwgaXQncyBub3Qgd2hhdCBJDQo+IHRoaW5rLg0KPiANCj4gU28gYW55b25l
IGtub3cgYSB3YXkgdG8gbW9uaXRvciB0aGUgc3RhdHVzIG9mIHRoZSBhbHRlciBub3cgdGhhdCBp
dCdzDQo+IGFuIElubm9EQiB0YWJsZT8NCj4gDQo+IA0KPiBPbiBXZWQsIFNlcCAyNiwgMjAxMiBh
dCAxMDozMSBBTSwgUmljayBKYW1lcyA8cmphbWVzQHlhaG9vLWluYy5jb20+DQo+IHdyb3RlOg0K
PiA+IE5vdCByZWFsbHkuDQo+ID4gWW91IGNvdWxkIGxvb2sgYXQgdGhlIC5UWUQgYW5kIC5UWUkg
ZmlsZSBzaXplcyBhbmQgY29tcGFyZSB0byB0aGUNCj4gLk1ZRCBhbmQgLk1ZSSwgYnV0IHRoYXQg
Y2FuIGJlIGRlY2VwdGl2ZS4gIElmIHRoZSB0YWJsZSBpcyByZWFsbHkgYmlnLA0KPiBhbmQgaGFz
IGxvdHMgb2YgaW5kZXhlcywgdGhlIGdlbmVyYXRpb24gb2YgdGhlIGluZGV4ZXMgbWlnaHQgZ28g
c2xvd2VyDQo+IGFuZCBzbG93ZXIgLS0gaGVuY2UgYW55IG1hdGggb24gdGhlIHNpemVzIHdvdWxk
IGJlIG9wdGltaXN0aWMuDQo+ID4NCj4gPj4gLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCj4g
Pj4gRnJvbTogTGFycnkgTWFydGVsbCBbbWFpbHRvOmxhcnJ5Lm1hcnRlbGxAZ21haWwuY29tXQ0K
PiA+PiBTZW50OiBXZWRuZXNkYXksIFNlcHRlbWJlciAyNiwgMjAxMiA4OjUyIEFNDQo+ID4+IFRv
OiBteXNxbCBtYWlsaW5nIGxpc3QNCj4gPj4gU3ViamVjdDogY2hlY2tpbmcgcHJvZ3Jlc3Mgb2Yg
YWx0ZXIgdGFibGUgb24gYSBNeUlTQU0gdGFibGUNCj4gPj4NCj4gPj4gSXMgdGhlcmUgYW55IHdh
eSB0byBjaGVjayBvbiB0aGUgcHJvZ3Jlc3Mgb2YgYSBsb25nIHJ1bm5pbmcgYWx0ZXINCj4gPj4g
dGFibGUgb24gYSBNeUlTQU0gdGFibGU/IEkga25vdyBpdCBjYW4gYmUgZG9uZSB3aXRoIGFuIElu
bm9EQiB0YWJsZSwNCj4gPj4gYnV0IEkgaGF2ZW4ndCBmb3VuZCBhIHdheSB0byBkbyBpdCBvbiB3
aXRoIGEgTXlJU0FNIHRhYmxlLg0KPiANCj4gLS0NCj4gTXlTUUwgR2VuZXJhbCBNYWlsaW5nIExp
c3QNCj4gRm9yIGxpc3QgYXJjaGl2ZXM6IGh0dHA6Ly9saXN0cy5teXNxbC5jb20vbXlzcWwNCj4g
VG8gdW5zdWJzY3JpYmU6ICAgIGh0dHA6Ly9saXN0cy5teXNxbC5jb20vbXlzcWwNCg0K