From kde-pim  Thu Mar 27 13:19:04 2014
From: Martin Steigerwald <Martin () lichtvoll ! de>
Date: Thu, 27 Mar 2014 13:19:04 +0000
To: kde-pim
Subject: Re: [Kde-pim] Akonadi MySQL backend: tuning for larger accounts or switching to MariaDB with a diffe
Message-Id: <2212653.7QNG8n2Rf5 () merkaba>
X-MARC-Message: https://marc.info/?l=kde-pim&m=139592636009525

SGksCgpBbSBEb25uZXJzdGFnLCAyNy4gTcOkcnogMjAxNCwgMTI6MjQ6Mzkgc2NocmllYiBEYW5p
ZWwgVnLDoXRpbDoKPiBPbiBXZWRuZXNkYXkgMjYgb2YgTWFyY2ggMjAxNCAyMjoxMjo1MyBNYXJ0
aW4gU3RlaWdlcndhbGQgd3JvdGU6Cj4gPiBBbSBNaXR0d29jaCwgMjYuIE3DpHJ6IDIwMTQsIDIx
OjIyOjMzIHNjaHJpZWIgTWFydGluIFN0ZWlnZXJ3YWxkOgo+ID4gPiBBbSBNaXR0d29jaCwgMjYu
IE3DpHJ6IDIwMTQsIDIwOjIyOjI4IHNjaHJpZWIgTWFydGluIFN0ZWlnZXJ3YWxkOgo+ID4gPiA+
ID4gPiBJbm5vREIgaXMgZGlmZmljdWx0IGFzIGlubm9kYl9idWZmZXJfcG9vbF9zaXplIG5lZWRz
IHRvIHRha2UgZnJlZQo+ID4gPiA+ID4gPiBtZW1vcnkKPiA+ID4gPiA+ID4gaW50byBhY2NvdW50
IHdoaWNoIGNhbiBjaGFuZ2UgcXVpdGUgcmFwaWRseSBvbiBkZXNrdG9wcyBvcgo+ID4gPiA+ID4g
PiBhbnl0aGluZwo+ID4gPiA+ID4gPiBlbHNlCj4gPiA+ID4gPiA+IHRoYW4gYSBkZWRpY2F0ZWQg
ZGF0YWJhc2Ugc2VydmVyLiBBIGVuZ2luZSB3aGljaCB1c2VzIExpbnV4Cj4gPiA+ID4gPiA+IHBh
Z2VjYWNoZQo+ID4gPiA+ID4gPiBmb3IKPiA+ID4gPiA+ID4gbW9zdCBvZiBpdHMgY2FjaGluZyB3
b3VsZCBiZSBpbnRlcmVzdGluZyBJIHRoaW5rLgo+ID4gPiA+ID4gCj4gPiA+ID4gPiBNYXliZSB3
ZSBjb3VsZCBoYXZlIHNvbWUga2luZCBvZiAiaW5pdGlhbCBzZXR1cCIgdG9vbCB0aGF0IHdvdWxk
Cj4gPiA+ID4gPiBjaGVjawo+ID4gPiA+ID4gYXZhaWxhYmxlIG1lbW9yeSBhbmQgd291bGQgdXBk
YXRlIGlubm9kYl9idWZmZXJfcG9vbF9zaXplIGRlcGVuZGluZwo+ID4gPiA+ID4gb24KPiA+ID4g
PiA+IHRoYXQKPiA+ID4gPiA+ICh0YWtpbmcgaW4gYWNjb3VudCBzb21lIG1heCBsaW1pdCwgbWlu
IGxpbWl0LCBtYXggcGVyY2VudGFnZSwgLi4uKQo+ID4gPiA+IAo+ID4gPiA+IFdlbGwgSSBhbSBi
YWNraW5nIG9mZiBhIGJpdCBhdCB0aGUgbW9tZW50LiBNYXliZSB0aG9zZSByZWFkIGJ1cnN0cyBJ
Cj4gPiA+ID4gb2JzZXJ2ZWQgIHdoZXJlIG5vdCByZWxhdGVkIHRvIElubm9EQiBidWZmZXIgcG9v
bCBzaXplLCBidXQgdG8KPiA+ID4gPiBzb21ldGhpbmcKPiA+ID4gPiBlbHNlLiBJZiBJIHNlZSBp
dCBhZ2FpbiwgSSB0cnkgdG8gbG9vayBpbiBBa29uYWRpY29uc29sZSBhcyB0byB3aGF0Cj4gPiA+
ID4gQWtvbmFkaQo+ID4gPiA+IGlzIGRvaW5nIHRoZXJlLgo+ID4gPiAKPiA+ID4gVGhlcmUgaXMg
aW5kZWVkIHNvbWUgc3R1ZmYgaW4gQWtvbmFkaWNvbnNvbGUgdGhlcmUuCj4gPiA+IAo+ID4gPiBB
bmQgbm93IEkgaGFkIHRoaXMgbG9uZyB3YWl0IGZvciBLTWFpbCB0byBkbyBhbnl0aGluZyBhZ2Fp
bi4gQWZ0ZXIKPiA+ID4gZG93bmxvYWRpbmcgLyBmaWx0ZXJpbmcgbmV3IG1haWwuCj4gPiA+IAo+
ID4gPiBBY2NvcmRpbmcgdG8gQWtvbmFkaWNvbnNvbGUgYWtvbmFkaSBuZXBvbXVrIGZlZWRlciB3
YXMgaW5kZXhpbmcgYW5kCj4gPiA+IGFjY29yZGluZyB0byBhdG9wIGFrb25hZGkgbWFpbGRpciBy
ZXNvdXJjZSB3YXMgaG9nZ2luZyBvbmUgU2FuZHlicmlkZ2UKPiA+ID4gY29yZQo+ID4gPiBmb3Ig
MTAwJSBmb3IgbWludXRlcy4KPiA+ID4gCj4gPiA+IEFrb25hZGljb25zb2xlIFF1ZXJ5IERlYnVn
Z2VyIHNob3dlZCBxdWVyaWVzIHRvIGdldCBwYXlsb2FkIGJvZGllcywgYWxzbwo+ID4gPiBmcm9t
IHRoYXQga2VybmVsLW1sIGZvbGRlci4gQW5kIEkgaGF2ZSBxdWl0ZSBzb21lIHdhaXQgdGltZXMg
aW4gSm9iCj4gPiA+IFRyYWNrZXIKPiA+ID4gbm93LCBmb3IgQWtvbmFkaTo6SXRlbUZldGNoSm9i
LiBJIGhhdmUgd2FpdCB0aW1lcyB1cCB0bzoKPiA+ID4gCj4gPiA+IDAwOjA1OjMzLjA2OQo+ID4g
PiAKPiA+ID4gRml2ZSBvZiB0aG9zZSB3YWl0IHRpbWVzIGJldHdlZW4gNSBhbmQgNiBtaW51dGVz
Lgo+ID4gPiAKPiA+ID4gRm91ciBiZXR3ZWVuIDItMyBtaW51dGVzLgo+ID4gPiAKPiA+ID4gRml2
ZSBiZXR3ZWVuIDEwLTIwIHNlY29uZHMuCj4gPiA+IAo+ID4gPiBXaHkgdGhpcyB0aW1lIGlzIHNv
IGxvbmcsIEkgZG9uwrR0IGtub3cuCj4gPiA+IAo+ID4gPiAKPiA+ID4gQWtvbmFkaSBzZWVtcyB0
byBibG9jayBvdXQgS01haWwgZHVlIHRvIHRoaXMgbWFpbCBpbmRleGluZyBiYWNrZ3JvdW5kCj4g
PiA+IGFjdGl2aXR5LCB3aGljaCBJIHJlcG9ydGVkIGFscmVhZHk6Cj4gPiA+IAo+ID4gPiBCdWcg
MzMxODQ4IC0gZGlzcGxheWluZywgbW92aW5nLCBkZWxldGluZyBtYWlscyB0YWtlcyAxMC0yMCBz
ZWNvbmRzIHdoZW4KPiA+ID4gQWtvbmFkaSBzeW5jaHJvbml6ZXMgaW4gYmFja2dyb3VuZAo+ID4g
PiAKPiA+ID4gaHR0cHM6Ly9idWdzLmtkZS5vcmcvc2hvd19idWcuY2dpP2lkPTMzMTg0OAo+ID4g
PiAKPiA+ID4gQnV0IGF0IHdvcmsgSSBkbyBub3QgaGF2ZSBtYWlsIGluZGV4aW5nIGVuYWJsZWQg
c28gZmFyLCB5ZXQgdGhpcyB3YXMgb24KPiA+ID4gTkZTCj4gPiA+IHN0aWxsIGFzIEkgcmVwb3J0
ZWQgdGhlIGJ1Zy4KPiA+ID4gCj4gPiA+IAo+ID4gPiBJIHRoaW5rIEkganVzdCBkaXNhYmxlIG1h
aWwgaW5kZXhpbmcgZm9yIG5vdyBmb3IgdGhpcyBQT1AzIHNldHVwLCB1bnRpbAo+ID4gPiBJCj4g
PiA+IGNhbiBpbnN0YWxsIEtERSBTQyA0LjEzIGluY2x1ZGluZyBuZXcgS0RFUElNIGFuZCBCYWxv
by4KPiA+ID4gCj4gPiA+IFdlbGwsIEkgbGVhcm5lZCBhYm91dCBkZWJ1Z2dpbmcgcGVyZm9ybWFu
Y2UgaXNzdWVzIHdpdGggQWtvbmFkaS4KPiA+ID4gCj4gPiA+IAo+ID4gPiBJIGFtIGluY2xpbmVk
IHRvIGNsb3NlIG15IE15U1FMIHR1bmluZyByZWxhdGVkIHJlcG9ydC4gSSBkbyBub3QgaGF2ZSB0
aGUKPiA+ID4gaW1wcmVzc2lvbiBhbnltb3JlIHRoYXQgaXQgaXMgdmVyeSBpbXBvcnRhbnQgYXQg
dGhlIG1vbWVudC4gV2hhdCBkbyB5b3UKPiA+ID4gdGhpbms/Cj4gPiA+IAo+ID4gPiBTbyBmaW5p
c2hpbmcgYW5hbHlzaXMgZm9yIG5vdy4KPiA+IAo+ID4gSSBnb3QgbWlzcyByYXRlcyBub3c6Cj4g
PiAKPiA+IAo+ID4gQlVGRkVSIFBPT0wgQU5EIE1FTU9SWQo+ID4gLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLQo+ID4gVG90YWwgbWVtb3J5IGFsbG9jYXRlZCA4NTg1MjE2MDsgaW4gYWRkaXRpb25hbCBw
b29sIGFsbG9jYXRlZCAwCj4gPiBEaWN0aW9uYXJ5IG1lbW9yeSBhbGxvY2F0ZWQgMTAzODkyCj4g
PiBCdWZmZXIgcG9vbCBzaXplICAgNTEyMAo+ID4gRnJlZSBidWZmZXJzICAgICAgIDAKPiA+IERh
dGFiYXNlIHBhZ2VzICAgICA0ODcxCj4gPiBPbGQgZGF0YWJhc2UgcGFnZXMgMTc3OAo+ID4gTW9k
aWZpZWQgZGIgcGFnZXMgIDAKPiA+IFBlbmRpbmcgcmVhZHMgMAo+ID4gUGVuZGluZyB3cml0ZXM6
IExSVSAwLCBmbHVzaCBsaXN0IDAsIHNpbmdsZSBwYWdlIDAKPiA+IFBhZ2VzIG1hZGUgeW91bmcg
NjU5MzMzLCBub3QgeW91bmcgMAo+ID4gMzMwMi43OCB5b3VuZ3MvcywgMC4wMCBub24teW91bmdz
L3MKPiA+IFBhZ2VzIHJlYWQgNjE5MDMzLCBjcmVhdGVkIDg0LCB3cml0dGVuIDEyMDQKPiA+IDMx
OTEuMjUgcmVhZHMvcywgMC41MyBjcmVhdGVzL3MsIDEwLjgwIHdyaXRlcy9zCj4gPiBCdWZmZXIg
cG9vbCBoaXQgcmF0ZSA5NzcgLyAxMDAwLCB5b3VuZy1tYWtpbmcgcmF0ZSAyNCAvIDEwMDAgbm90
IDAgLyAxMDAwCj4gPiBQYWdlcyByZWFkIGFoZWFkIDc5Ljc5L3MsIGV2aWN0ZWQgd2l0aG91dCBh
Y2Nlc3MgMjEuMDAvcywgUmFuZG9tIHJlYWQKPiA+IGFoZWFkCj4gPiAwLjAwL3MKPiA+IExSVSBs
ZW46IDQ4NzEsIHVuemlwX0xSVSBsZW46IDAKPiA+IEkvTyBzdW1bMjY3OTQ2XTpjdXJbMF0sIHVu
emlwIHN1bVswXTpjdXJbMF0KPiA+IAo+ID4gCj4gPiBBbm90aGVyIGV4YW1wbGU6Cj4gPiAtLS0t
LS0tLS0tLS0tLS0tLS0tLS0tCj4gPiBCVUZGRVIgUE9PTCBBTkQgTUVNT1JZCj4gPiAtLS0tLS0t
LS0tLS0tLS0tLS0tLS0tCj4gPiBUb3RhbCBtZW1vcnkgYWxsb2NhdGVkIDg1ODUyMTYwOyBpbiBh
ZGRpdGlvbmFsIHBvb2wgYWxsb2NhdGVkIDAKPiA+IERpY3Rpb25hcnkgbWVtb3J5IGFsbG9jYXRl
ZCAxMDM4OTIKPiA+IEJ1ZmZlciBwb29sIHNpemUgICA1MTIwCj4gPiBGcmVlIGJ1ZmZlcnMgICAg
ICAgMAo+ID4gRGF0YWJhc2UgcGFnZXMgICAgIDQ5NDIKPiA+IE9sZCBkYXRhYmFzZSBwYWdlcyAx
ODA0Cj4gPiBNb2RpZmllZCBkYiBwYWdlcyAgMTAKPiA+IFBlbmRpbmcgcmVhZHMgMAo+ID4gUGVu
ZGluZyB3cml0ZXM6IExSVSAwLCBmbHVzaCBsaXN0IDAsIHNpbmdsZSBwYWdlIDAKPiA+IFBhZ2Vz
IG1hZGUgeW91bmcgMTA3NjI4Mywgbm90IHlvdW5nIDAKPiA+IDEwNTcwLjIxIHlvdW5ncy9zLCAw
LjAwIG5vbi15b3VuZ3Mvcwo+ID4gUGFnZXMgcmVhZCAxMDE1NTMwLCBjcmVhdGVkIDExMCwgd3Jp
dHRlbiAxNjczCj4gPiAxMDQ3MS43NiByZWFkcy9zLCAwLjUwIGNyZWF0ZXMvcywgMTAuMDAgd3Jp
dGVzL3MKPiA+IEJ1ZmZlciBwb29sIGhpdCByYXRlIDk2NSAvIDEwMDAsIHlvdW5nLW1ha2luZyBy
YXRlIDM2IC8gMTAwMCBub3QgMCAvIDEwMDAKPiA+IFBhZ2VzIHJlYWQgYWhlYWQgNDc5Ljc2L3Ms
IGV2aWN0ZWQgd2l0aG91dCBhY2Nlc3MgNzguNDYvcywgUmFuZG9tIHJlYWQKPiA+IGFoZWFkIDAu
MDAvcwo+ID4gTFJVIGxlbjogNDk0MiwgdW56aXBfTFJVIGxlbjogMAo+ID4gSS9PIHN1bVs4ODE0
NF06Y3VyWzc2NTZdLCB1bnppcCBzdW1bMF06Y3VyWzBdCj4gPiAKPiA+IHNlZToKPiA+IAo+ID4g
QnVnIDMzMjYyNiAtIE15U1FMIHR1bmluZzogYWRhcHRpb24gb2YgTXlTUUwgdHVuaW5nIG9wdGlv
bnMgZm9yIGxhcmdlcgo+ID4gYWNjb3VudHMKPiA+IGh0dHBzOi8vYnVncy5rZGUub3JnL3Nob3df
YnVnLmNnaT9pZD0zMzI2MjYjYzUKPiA+IAo+ID4gCj4gPiBBbmQgSSBnb3Q6Cj4gPiAKPiA+IEJ1
ZyAzMzI2NTMgLSBBZnRlciBtYWlsIHJlY2VpdmUgb24gZmlsdGVyaW5nOiBVbmFibGUgdG8gcmV0
cmlldmUgaXRlbSBmcm9tCj4gPiByZXNvdXJjZTogTk8gSW1hcFBhcnNlckV4Y2VwdGlvbjogVW5h
YmxlIHRvIHJlYWQgbW9yZSBkYXRhCj4gPiAKPiA+IAo+ID4gVGhpcyBzaG91bGQgaGF2ZSBiZWVu
IHdpdGggZGlzYWJsZWQgbWFpbCBpbmRleGluZy4gSSB3aWxsIG9ic2VydmUgZnVydGhlcgo+ID4g
YW5kIHJlYWxseSBjbG9zZSBhbmFseXNpcyBmb3Igbm93LiBOZWVkIHRvIGdldCBhIGNsZWFyIGhl
YWQgYWdhaW4sIGJlZm9yZQo+ID4gY29udGludWluZy4KPiA+IAo+ID4gQ2lhbywKW+KApl0KPiB0
aGFua3MgYSBsb3QgZm9yIGFsbCB0aGUgYW5hbHlzaXMuIEkgd2lsbCBuZWVkIHRvIHJlYWQgdXAg
b24gdGhpcyBhbmQKPiBjb25zdWx0IE15U1FMIGRvY3VtZW50YXRpb24gZmlyc3QsIHNvIEknbGwg
Z28gdGhyb3VnaCBpdCBuZXh0IHdlZWsgOi0pCgpZZWFoLCBtZSB0b28uCgpUaGUgYnVmZmVyIHBv
b2wgaGl0IHJhdGUgYXBwZWFycyBzdGlsbCBxdWl0ZSBnb29kIGFuZCBJIG5ldmVyIGhhdmUgc2Vl
biAKYW55dGhpbmcgYmVsb3cgOTUwLzEwMDAgc28gZmFyLCBzbyBJIHRoaW5rIGl0cyBubyByZWFs
IGJpZyBpc3N1ZS4gQnV0IEkgYWxzbyAKbmVlZCB0byB1bmRlcnN0YW5kIHRoaXMgYmV0dGVyIDop
CgpJIGVuam95ZWQgZGlnZ2luZyBhIGJpdCBkZWVwZXIgYW5kIGxlYXJuaW5nIG1vcmUgYWJvdXQg
QWtvbmFkaSBhbmQgd2hhdCBpcyAKcG9zc2libGUgaW4gQWtvbmFkaWNvbnNvbGUuIEkgdGhpbmsg
QWtvbmFkaWNvbnNvbGUgaXMgYSBnb29kIHBsYWNlIHRvIHRlc3QgCmJhc2ljIG9wZXJhdGlvbnMu
CgpJIGFtIHN0aWxsIHRyeWluZyB0byBmaW5kIG15IHdheSB0byBhbmFseXNlIHdoeSBLTWFpbCBk
b2VzbsK0dCByZXNwb25kIGZvciBzb21lIAptaW51dGVzIGZvciBleGFtcGxlIGluIG9yZGVyIHRv
IGF0IGxlYXN0IHByb3ZpZGUgbW9yZSB1c2VmdWwgYnVnIHJlcG9ydHMuIFNvIApvbiBob3cgdG8g
Z2V0IGZyb20gYW4gYXBwbGljYXRpb24gYnVnIHRvIGFuYWx5c2Ugd2hhdCByZWFsbHkgaXMgaGFw
cGVuaW5nIG9uIAp0aGUgc3VyZmFjZSBiZWxvdy4gSSBoYXZlIHNvbWUgaWRlYXMgbWVhbndoaWxl
IGFuZCBJIHRoaW5rIG15IGlzc3VlcyBhcmUgbW9yZSAKd2l0aCBwYXlsb2FkIGhhbmRsaW5nIHRo
YW4gdGhlIGFjdHVhbCBkYXRhYmFzZSBvcGVyYXRpb25zLiBFc3BlY2lhbGx5IApzeW5jaHJvbml6
aW5nIGZvbGRlcnMgc2VlbSB0byBiZSBleHBlbnNpdmUuIEVzcGVjaWFsbHkgaWYgdGhleSBoYXZl
IHRlbnMgb2YgCnRob3VzYW5kcyBtYWlscyBpbiBpdC4gTm90IHRhbGtpbmcgYWJvdXQgdGhhdCBr
ZXJuZWwtbWwgZm9sZGVyIHdpdGggMjAwMDAwIAptYWlscy4KCkluIEtNYWlsIDEgSSBhcmNoaXZl
ZCBmb2xkZXJzIHZpYSBoYXZpbmcgaXQgbW92ZSBvbGQgbWFpbHMgdG8gbWJveCBmb2xkZXJzIHZp
YSAKZm9sZGVyIGFyY2hpdmluZy4gSSB1c2VkIGEgbWl4ZWQgbWFpbGRpciByZXNvdXJjZSBmb3Ig
dGhhdC4gV2hpY2ggSSBzdGlsbCBkaWQgCm5vdCBkYXJlIHRvIGludGVncmF0ZSBiYWNrIGludG8g
QWtvbmFkaS4gSSBhbSBmaW5lIHdpdGggc3BsaXR0aW5nIGZvbGRlcnMsIAp1c2luZyBtYm94IGFy
Y2hpdmUgZm9sZGVyLCBidXQgZG9pbmcgb25lIG1ib3ggcmVzb3VyY2UgZm9yIGVhY2ggbWJveCBm
b2xkZXIgSSAKd2FudCB0byBoYXZlIGZvciBhcmNoaXZpbmcsIGRvZXMgbm90IHNlZW0gdG8gbWFr
ZSBnb29kIHNlbnNlIHRvIG1lLiBTbyBJIApyZWFsbHkgbGlrZSB0aGF0IG1peGVkbWFpbGRpciB0
aGluZy4gRm9sZGVyIGFyY2hpdmUgYWdlbnQgbWF5IGJlIGFuIAphbHRlcm5hdGl2ZSwgYnV0IEnC
tGQgbGlrZSB0byBoYXZlIHRoZSBvbGQgbWFpbHMgcmVhZC1hY2Nlc3NpYmxlIHN0aWxsIGFuZCAK
c2VhcmNoYWJsZSwgd2hpY2ggd291bGQgb25seSB3b3JrIGJ5IHpncmVwwrRpbmcgdGhyb3VnaCB0
aGUgYXJjaGl2ZSBmaWxlcyBGb2xkZXIgCkFyY2hpdmUgQWdlbnQgY3JlYXRlcy4KClN0YXJ0aW5n
IHdpdGggS0RFIFNDIDQuMTMgSSBtYXkgdHJ5IHRvIGFkZCBiYWNrIHRoYXQgb2xkIG1peGVkbWFp
bGRpciByZXNvdXJjZSAKYW5kIHNldHVwIGFyY2hpdmluZyB0byBpdCBhZ2Fpbi4gV2VsbCBJIG1h
eSBqdXN0IHRyeSBiZWZvcmUsIGJ1dCAqd2l0aG91dCogCm1haWwgaW5kZXhpbmcgdmlhIE5lcG9t
dWsgOikKCi0tIApNYXJ0aW4gJ0hlbGlvcycgU3RlaWdlcndhbGQgLSBodHRwOi8vd3d3LkxpY2h0
dm9sbC5kZQpHUEc6IDAzQjAgMEQ2QyAwMDQwIDA3MTAgNEFGQSAgQjgyRiA5OTFCIEVBQUMgQTU5
OSA4NEM3Cl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fCktE
RSBQSU0gbWFpbGluZyBsaXN0IGtkZS1waW1Aa2RlLm9yZwpodHRwczovL21haWwua2RlLm9yZy9t
YWlsbWFuL2xpc3RpbmZvL2tkZS1waW0KS0RFIFBJTSBob21lIHBhZ2UgYXQgaHR0cDovL3BpbS5r
ZGUub3JnLw==