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

c2Vjb25kYXJ5a2V5IGFuZCByZWR1bmRhbnRrZXkgYXJlIHJlZHVuZGFudCB3aXRoIGVhY2ggb3Ro
ZXIgLS0gaW4gYWxsIHZlcnNpb25zIG9mIElubm9EQi4NCg0KT25lICJleHBlcnQiIHNhaWQgdGhh
dCByZWR1bmRhbnQga2V5IHdvdWxkIGhhdmUgdHdvIGNvcGllcyBvZiBgMWAsYDJgLiAgSSB0aGlu
ayBoZSBpcyB3cm9uZy4gIEkgYmVsaWV2ZSB0aGUgdHdvIGFyZSB0aGUgc2FtZSBpbiBzaXplLg0K
DQpUaGVyZSBpcyBhIHN1YnRsZSBjaGFuZ2UgaW4gNS42IHRoYXQgX21heV8gbWFrZSBhIF9mZXdf
IHF1ZXJpZXMgd29yayBiZXR0ZXIgd2l0aCByZWR1bmRhbnRrZXkuDQoNCkkgcHJlZmVyIHRvIHNw
ZWNpZnkgYXMgbWFueSBmaWVsZHMgaW4gdGhlIGtleSBhcyBtYWtlIHNlbnNlIGZvciB0aGUgU0VM
RUNUKHMpLCB0aGVuIGxldCB0aGUgZW5naW5lIGFkZCBhbnkgbW9yZSBmaWVsZHMgYXMgbmVlZGVk
IHRvIGZpbGwgb3V0IHRoZSBQSy4gIFRoYXQgaXMsIEkgbWlnaHQgc2F5ICgzLDQpIG9yICgzLDQs
MSkgb3IgKDMsNCwxLDIpIG9yICgzLDQsMiksIGV0YywgZGVwZW5kaW5nIG9uIHRoZSBxdWVyaWVz
Lg0KDQpXaGVuIGxvb2tpbmcgdXAgYSByb3cocykgYnkgYSBzZWNvbmRhcnkga2V5LCB0aGUgZW5n
aW5lIGZpcnN0IGRyaWxscyBkb3duIHRoZSBzZWNvbmRhcnkgQlRyZWUsIGZpbmRzIHRoZSBQSyhz
KSwgdGhlbiBkcmlsbHMgZG93biB0aGUgUFJJTUFSWSBCVHJlZS4NCg0KPiAtLS0tLU9yaWdpbmFs
IE1lc3NhZ2UtLS0tLQ0KPiBGcm9tOiBKZXJlbXkgQ2hhc2UgW21haWx0bzpqZXJlbXljaGFzZUBn
bWFpbC5jb21dDQo+IFNlbnQ6IFdlZG5lc2RheSwgSmFudWFyeSAzMCwgMjAxMyAxMToyNSBBTQ0K
PiBUbzogbXlzcWxAbGlzdHMubXlzcWwuY29tDQo+IFN1YmplY3Q6IElubm9EQiBpbnRlcmFjdGlv
biBiZXR3ZWVuIHNlY29uZGFyeSBhbmQgcHJpbWFyeSBrZXlzLg0KPiANCj4gIEhlbGxvLA0KPiAN
Cj4gSSd2ZSBiZWVuIHdvcmtpbmcgd2l0aCBhIHNlY29uZGFyeSBpbmRleCBhbmQgd291bGQgbGlr
ZSBzb21lDQo+IGNsYXJpZmljYXRpb24gYWJvdXQgaG93IHRoZSBwcmltYXJ5IGNvbHVtbnMgYXJl
IGluY2x1ZGVkLiBTbywgaW4gdGhlDQo+IGZvbGxvd2luZyBleGFtcGxlLCBpcyB0aGUgc2Vjb25k
YXJ5S2V5IGVmZmVjdGl2ZWx5IHRoZSBzYW1lIGFzDQo+IHJlZHVuZGFudEtleT8NCj4gDQo+IENS
RUFURSBUQUJMRSBgZXhhbXBsZWAgKA0KPiAgIGAxYCBpbnQoMTApIHVuc2lnbmVkIE5PVCBOVUxM
LA0KPiAgIGAyYCBpbnQoMTApIHVuc2lnbmVkIE5PVCBOVUxMLA0KPiAgIGAzYCBpbnQoMTApIHVu
c2lnbmVkIE5PVCBOVUxMLA0KPiAgIGA0YCBpbnQoMTApIHVuc2lnbmVkIE5PVCBOVUxMLA0KPiAg
IFBSSU1BUlkgS0VZIChgMWAsYDJgKSwNCj4gICBLRVkgYHNlY29uZGFyeUtleWAgKGAzYCwgYDRg
KQ0KPiAgIEtFWSBgcmVkdW5kYW50S2V5YCAoYDNgLCBgNGAsIGAxYCwgYDJgKQ0KPiApIEVOR0lO
RT1Jbm5vREIgREVGQVVMVCBDSEFSU0VUPXV0ZjgNCj4gDQo+IEJhY2tncm91bmQ6IGh0dHA6Ly9k
ZXYubXlzcWwuY29tL2RvYy9yZWZtYW4vNS41L2VuL2lubm9kYi1pbmRleC0NCj4gdHlwZXMuaHRt
bA0KPiANCj4gIkluIElubm9EQiwgZWFjaCByZWNvcmQgaW4gYSBzZWNvbmRhcnkgaW5kZXggY29u
dGFpbnMgdGhlIHByaW1hcnkga2V5DQo+IGNvbHVtbnMgZm9yIHRoZSByb3csIGFzIHdlbGwgYXMg
dGhlIGNvbHVtbnMgc3BlY2lmaWVkIGZvciB0aGUgc2Vjb25kYXJ5DQo+IGluZGV4LiINCj4gDQo+
IFRoYW5rIHlvdSENCj4gSmVyZW15DQo=