From: Rick James
Date: October 17 2012 3:50pm
Subject: RE: Unexpected gradual replication log size increase.
List-Archive: http://lists.mysql.com/mysql/228441
Message-Id: <2E7DD7ADE53B044C8C8BCD9C5829E1EB148D27C1A7@SP2-EX07VS01.ds.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: base64

Q2hlY2sgdGhhdCBzZXJ2ZXJfaWQgaXMgZGlmZmVyZW50IGJldHdlZW4gTWFzdGVyIGFuZCBTbGF2
ZShzKS4NCg0KQ2hlY2sgb3RoZXIgc2V0dGluZ3MgcmVsYXRpbmcgdG8gcmVwbGljYXRpb24uDQoN
Cj4gLS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCj4gRnJvbTogS2VudCBIbyBbbWFpbHRvOmtl
bnRAZ3JhZmZpdGkubmV0XQ0KPiBTZW50OiBXZWRuZXNkYXksIE9jdG9iZXIgMTcsIDIwMTIgNjo0
NSBBTQ0KPiBUbzogbXlzcWxAbGlzdHMubXlzcWwuY29tOyByZXBsaWNhdGlvbkBsaXN0cy5teXNx
bC5jb20NCj4gU3ViamVjdDogVW5leHBlY3RlZCBncmFkdWFsIHJlcGxpY2F0aW9uIGxvZyBzaXpl
IGluY3JlYXNlLg0KPiANCj4gSGksDQo+IA0KPiBJIGhhdmUgYSBNeXNxbCByZXBsaWNhdGUgc2V0
dXAgcnVubmluZyBmb3IgYSB3aGlsZSBvdmVyIDYgbW9udGhzIGFuZA0KPiByZWNlbnQgd2UgaGFk
IGFuIG91dGFnZS4gwqBXZSBmaXggaXQsIGJvdWdodCB0aGUgc2VydmVyIGJhY2sgdXAgYW5kIHdl
DQo+IHNwb3R0ZWQgc29tZXRoaW5nIHBlY3VsaWFyIGFuZCB3b3JyeWluZy4gwqAgVGhlIHJlcGxp
Y2F0aW9uIGxvZ3MgYXJlDQo+IGdyb3dpbmcgaW4gc2l6ZSwgYWxsIG9mIGEgc3VkZGVuIG9uIFR1
ZXNkYXkgOXRoIE9jdCBiYXNlZCBvbiBjbHVlcyBmcm9tDQo+IG1vbml0b3JpbmcgZ3JhcGhzLiDC
oE5vIGNoYW5nZXMgcmVjb3JkZWQgYXQgdGhlIHRpbWUgdGhhdCBtaWdodCBoYXZlDQo+IHRyaWdn
ZXJlZCBpdC4NCj4gDQo+IFRoZSBhcHBsaWNhdGlvbiB1c2luZyB0aGlzIGRhdGFiYXNlIGlzIFpl
bm9zcy4gwqBUaGVyZSBhcmUgbm8gc3VyZ2Ugb2YNCj4gZXZlbnRzIG9yIGFjdGl2aXRpeSBBRkFJ
SyBvZiBpbiBaZW5vc3MgYW5kIHdvcmtpbmcgYXMgbm9ybWFsLiDCoFRoZXJlJ3MNCj4gbm8gZXh0
cmEgbG9hZCBvciB3b3JrIGFkZGVkIHRvIHRoZSBzZXJ2ZXIuIMKgQ1BVICYgbG9hZCBhdmVyYWdl
IGFyZQ0KPiBub3JtYWwuIMKgSXQncyBqdXN0IHRoYXQgdGhlIElPIHdyaXRlIHRvIGRpc2sgYXJl
IGluY3JlYXNpbmcgc3VkZGVubHksDQo+IGNyZWVwaW5nIHVwIHNsb3dseS4NCj4gDQo+IE5leHQg
dHJ5IGZpbmQgb3V0IHdoeT8gwqBJJ20gbm90IGEgbXlzcWwgZ3VydS4gwqBJJ3ZlIGZvdW5kIGEg
bXlzcWwgYmluDQo+IGxvZyBhbmFseXNlciBoZXJlOi0gaHR0cDovL3NjYWxlLW91dC1ibG9nLmJs
b2dzcG90LmNvLnVrLzIwMTAvMDEvd2hhdHMtDQo+IGluLXlvdXItYmlubG9nLmh0bWwNCj4gcnVu
IGl0IGFnYWluc3QgdGhlIGxvZ3MuDQo+IA0KPiBXZSBub3RpY2VkICJNYXguIEV2ZW50IEJ5dGVz
IiBhcmUgaW5jcmVhc2luZyBhcHByb3guIGFsbW9zdCBleGFjdGx5IGJ5DQo+IDU4LDU5MCBieXRl
cyBwZXIgaG91ci4NCj4gDQo+IGZvciBpIGluIGBscyAtMSBteXNxbC1iaW4uKmAgOyBkbyBscyAt
bCAkaSA7IC9vcHQvemVuZHMvYmluL215c3FsYmlubG9nDQo+ICRpIHwgLi9iaW5sb2ctYW5hbHl6
ZS5wbCAtcSB8IGdyZXAgIk1heC4gRXZlbnQgQnl0ZXMiIDsgZG9uZQ0KPiAtcnctcnctLS0tIDEg
emVub3NzIHplbm9zcyAxMDc2OTY1Njk2IE9jdCAxNyAwMTowNyBteXNxbC1iaW4uMDAwMjEwDQo+
IE1heC4gRXZlbnQgQnl0ZXMgwqA6IMKgIMKgIMKgIMKgMTAxMjkwNjYNCj4gLXJ3LXJ3LS0tLSAx
IHplbm9zcyB6ZW5vc3MgMTA4Mjg5NzY1NCBPY3QgMTcgMDE6MzQgbXlzcWwtYmluLjAwMDIxMQ0K
PiBNYXguIEV2ZW50IEJ5dGVzIMKgOiDCoCDCoCDCoCDCoDEwMTU2MDY2IC4NCj4gLg0KPiAtcnct
cnctLS0tIDEgemVub3NzIHplbm9zcyAxMDc1NTM4NjE5IE9jdCAxNyAwNzoxNCBteXNxbC1iaW4u
MDAwMjI0DQo+IE1heC4gRXZlbnQgQnl0ZXMgwqA6IMKgIMKgIMKgIMKgMTA0OTUzNjYNCj4gDQo+
IE9uIDE1dGggT2N0IDIyOjA1IEdNVCBteXNxbC1iaW4uMDAwMTU1IE1heC4gRXZlbnQgQnl0ZXMg
cmVhZGluZyB3YXMNCj4gOCw1NTMsMTY2Lg0KPiA0MCBob3VycyBsYXRlciB0b2RheSAxN3RoIE9j
dCAxNDowMCBHTVQgbXlzcWwtYmluLjAwMDI0MCBNYXguIEV2ZW50DQo+IEJ5dGVzIHJlYWRpbmcg
aXMgMTAsODk2LDc2Ni4NCj4gDQo+IE9uIDE1dGggYmluIGxvZyBncm93dGggcmF0ZSB3YXMgYXJv
dW5kIDE2TUIgcGVyIGhvdXIsIHRvZGF5IDUwTWIgcGVyDQo+IGhvdXIgYW5kIGluY3JlYXNpbmcu
IMKgQmVmb3JlIDl0aCB0aGUgYmluIGxvZyB3YXMgY29uc3RhbnQgc2l6ZSwgaXQgdGFrZQ0KPiBz
ZXZlcmFsIGRheXMgdG8gZmlsbCBhIDFHYiBiaW4gbG9nIGZpbGUuIMKgTm93IEkgZ2V0IGFib3V0
IDcyIGZpbGVzIG9yDQo+IDcyR2IgbG9ncyBwZXIgZGF5LiDCoCBOb3cgSSd2ZSBwdXQgaW4gYSBj
cm9uIGpvYiB0byBwdXJnZSBhbnl0aGluZyBvbGRlcg0KPiB0aGVuIDEyIGhvdXJzIGFuZCBzb29u
IG5lZWQgdG8gcmVkdWNlIHRoYXQgZnVydGhlciBhdCB0aGUgY3VycmVudCByYXRlLg0KPiANCj4g
V2hhdCBjb3VsZCBiZSBjYXVzaW5nIHRoaXM/IMKgIEFsbCBvdGhlciBhdHJyaWJ1dGVzIG9uIHRo
ZSBzeXN0ZW0gYXJlDQo+IHNhbWUgYXMgaXQgd2FzIHdlZWtzIG9yIG1vbnRocyBhZ28uDQo+IA0K
PiBJJ20gcnVubmluZyBNeXNxbCAiVmVyIDguNDIgRGlzdHJpYiA1LjUuMTUsIGZvciBsaW51eDIu
NiBvbiB4ODZfNjQiIG9uDQo+IFJIRUw1LjYgTGludXggeHh4IDIuNi4xOC0yMzguZWw1ICMxIFNN
UCBTdW4gRGVjIDE5IDE0OjIyOjQ0IEVTVCAyMDEwDQo+IHg4Nl82NCB4ODZfNjQgeDg2XzY0IEdO
VS9MaW51eC4NCj4gDQo+IFBsZWFzZSBsZXQgbWUga25vdyBpZiBuZWVkIGFueSBmdXJ0aGVyIGlu
Zm9tYXRpb24sIEknbGwgZ3JhYiBhbmQgcG9zdC4NCj4gDQo+IEFueSBoZWxwL2luZm8gYXJlIGhp
Z2hseSBhcHByZWNpYXRlZC4NCj4gDQo+IFRoYW5rcyBpbiBhZHZhbmNlLg0KPiANCj4gS2VudC4N
Cj4gDQo+IC0tDQo+IE15U1FMIEdlbmVyYWwgTWFpbGluZyBMaXN0DQo+IEZvciBsaXN0IGFyY2hp
dmVzOiBodHRwOi8vbGlzdHMubXlzcWwuY29tL215c3FsDQo+IFRvIHVuc3Vic2NyaWJlOiAgICBo
dHRwOi8vbGlzdHMubXlzcWwuY29tL215c3FsDQoNCg==