From: Rick James
Date: January 30 2013 9:24pm
Subject: RE: InnoDB interaction between secondary and primary keys.
List-Archive: http://lists.mysql.com/mysql/228893
Message-Id: <582AFBFC517D194489EF570FE21694CF135FEBBE@GQ1-EX10-MB03.y.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64

VGhlIGhpbnQgb2YgYSBjaGFuZ2UgaXMgaW4gaGVyZSAoc2VhcmNoIGZvciAic2Vjb25kYXJ5Iik6
DQpodHRwOi8vam9yZ2VubG9sYW5kLmJsb2dzcG90LmNvLnVrLzIwMTIvMTIvZmF2b3JpdGUtbXlz
cWwtNTYtZmVhdHVyZXMtb3B0aW1pemVyLmh0bWwNCg0KPiAtLS0tLU9yaWdpbmFsIE1lc3NhZ2Ut
LS0tLQ0KPiBGcm9tOiBSaWNrIEphbWVzDQo+IFNlbnQ6IFdlZG5lc2RheSwgSmFudWFyeSAzMCwg
MjAxMyAxOjA4IFBNDQo+IFRvOiAnSmVyZW15IENoYXNlJzsgbXlzcWxAbGlzdHMubXlzcWwuY29t
DQo+IFN1YmplY3Q6IFJFOiBJbm5vREIgaW50ZXJhY3Rpb24gYmV0d2VlbiBzZWNvbmRhcnkgYW5k
IHByaW1hcnkga2V5cy4NCj4gDQo+IHNlY29uZGFyeWtleSBhbmQgcmVkdW5kYW50a2V5IGFyZSBy
ZWR1bmRhbnQgd2l0aCBlYWNoIG90aGVyIC0tIGluIGFsbA0KPiB2ZXJzaW9ucyBvZiBJbm5vREIu
DQo+IA0KPiBPbmUgImV4cGVydCIgc2FpZCB0aGF0IHJlZHVuZGFudCBrZXkgd291bGQgaGF2ZSB0
d28gY29waWVzIG9mIGAxYCxgMmAuDQo+IEkgdGhpbmsgaGUgaXMgd3JvbmcuICBJIGJlbGlldmUg
dGhlIHR3byBhcmUgdGhlIHNhbWUgaW4gc2l6ZS4NCj4gDQo+IFRoZXJlIGlzIGEgc3VidGxlIGNo
YW5nZSBpbiA1LjYgdGhhdCBfbWF5XyBtYWtlIGEgX2Zld18gcXVlcmllcyB3b3JrDQo+IGJldHRl
ciB3aXRoIHJlZHVuZGFudGtleS4NCj4gDQo+IEkgcHJlZmVyIHRvIHNwZWNpZnkgYXMgbWFueSBm
aWVsZHMgaW4gdGhlIGtleSBhcyBtYWtlIHNlbnNlIGZvciB0aGUNCj4gU0VMRUNUKHMpLCB0aGVu
IGxldCB0aGUgZW5naW5lIGFkZCBhbnkgbW9yZSBmaWVsZHMgYXMgbmVlZGVkIHRvIGZpbGwNCj4g
b3V0IHRoZSBQSy4gIFRoYXQgaXMsIEkgbWlnaHQgc2F5ICgzLDQpIG9yICgzLDQsMSkgb3IgKDMs
NCwxLDIpIG9yDQo+ICgzLDQsMiksIGV0YywgZGVwZW5kaW5nIG9uIHRoZSBxdWVyaWVzLg0KPiAN
Cj4gV2hlbiBsb29raW5nIHVwIGEgcm93KHMpIGJ5IGEgc2Vjb25kYXJ5IGtleSwgdGhlIGVuZ2lu
ZSBmaXJzdCBkcmlsbHMNCj4gZG93biB0aGUgc2Vjb25kYXJ5IEJUcmVlLCBmaW5kcyB0aGUgUEso
cyksIHRoZW4gZHJpbGxzIGRvd24gdGhlIFBSSU1BUlkNCj4gQlRyZWUuDQo+IA0KPiA+IC0tLS0t
T3JpZ2luYWwgTWVzc2FnZS0tLS0tDQo+ID4gRnJvbTogSmVyZW15IENoYXNlIFttYWlsdG86amVy
ZW15Y2hhc2VAZ21haWwuY29tXQ0KPiA+IFNlbnQ6IFdlZG5lc2RheSwgSmFudWFyeSAzMCwgMjAx
MyAxMToyNSBBTQ0KPiA+IFRvOiBteXNxbEBsaXN0cy5teXNxbC5jb20NCj4gPiBTdWJqZWN0OiBJ
bm5vREIgaW50ZXJhY3Rpb24gYmV0d2VlbiBzZWNvbmRhcnkgYW5kIHByaW1hcnkga2V5cy4NCj4g
Pg0KPiA+ICBIZWxsbywNCj4gPg0KPiA+IEkndmUgYmVlbiB3b3JraW5nIHdpdGggYSBzZWNvbmRh
cnkgaW5kZXggYW5kIHdvdWxkIGxpa2Ugc29tZQ0KPiA+IGNsYXJpZmljYXRpb24gYWJvdXQgaG93
IHRoZSBwcmltYXJ5IGNvbHVtbnMgYXJlIGluY2x1ZGVkLiBTbywgaW4gdGhlDQo+ID4gZm9sbG93
aW5nIGV4YW1wbGUsIGlzIHRoZSBzZWNvbmRhcnlLZXkgZWZmZWN0aXZlbHkgdGhlIHNhbWUgYXMN
Cj4gPiByZWR1bmRhbnRLZXk/DQo+ID4NCj4gPiBDUkVBVEUgVEFCTEUgYGV4YW1wbGVgICgNCj4g
PiAgIGAxYCBpbnQoMTApIHVuc2lnbmVkIE5PVCBOVUxMLA0KPiA+ICAgYDJgIGludCgxMCkgdW5z
aWduZWQgTk9UIE5VTEwsDQo+ID4gICBgM2AgaW50KDEwKSB1bnNpZ25lZCBOT1QgTlVMTCwNCj4g
PiAgIGA0YCBpbnQoMTApIHVuc2lnbmVkIE5PVCBOVUxMLA0KPiA+ICAgUFJJTUFSWSBLRVkgKGAx
YCxgMmApLA0KPiA+ICAgS0VZIGBzZWNvbmRhcnlLZXlgIChgM2AsIGA0YCkNCj4gPiAgIEtFWSBg
cmVkdW5kYW50S2V5YCAoYDNgLCBgNGAsIGAxYCwgYDJgKQ0KPiA+ICkgRU5HSU5FPUlubm9EQiBE
RUZBVUxUIENIQVJTRVQ9dXRmOA0KPiA+DQo+ID4gQmFja2dyb3VuZDogaHR0cDovL2Rldi5teXNx
bC5jb20vZG9jL3JlZm1hbi81LjUvZW4vaW5ub2RiLWluZGV4LQ0KPiA+IHR5cGVzLmh0bWwNCj4g
Pg0KPiA+ICJJbiBJbm5vREIsIGVhY2ggcmVjb3JkIGluIGEgc2Vjb25kYXJ5IGluZGV4IGNvbnRh
aW5zIHRoZSBwcmltYXJ5IGtleQ0KPiA+IGNvbHVtbnMgZm9yIHRoZSByb3csIGFzIHdlbGwgYXMg
dGhlIGNvbHVtbnMgc3BlY2lmaWVkIGZvciB0aGUNCj4gPiBzZWNvbmRhcnkgaW5kZXguIg0KPiA+
DQo+ID4gVGhhbmsgeW91IQ0KPiA+IEplcmVteQ0K