Re: Need some further understanding of MariaDB/MySQL on ZFS

Morgan Wesström <[email protected]> Wed, 23 Nov 2016 16:34:01 +0100
Newsgroups gmane.os.freebsd.devel.database
Message-ID <[email protected]>
T24gMjAxNi0xMS0yMyAwOTozNSwgTWlyb3NsYXYgTGFjaG1hbiB3cm90ZToKPiBNb3JnYW4gV2Vz
c3Ryw7ZtIHdyb3RlIG9uIDIwMTYvMTEvMjIgMjM6MTU6Cj4KPj4gaW5ub2RiX2RhdGFfaG9tZV9k
aXIgPSAvdmFyL2RiL215c3FsL2lubm9kYgo+PiBpbm5vZGJfbG9nX2dyb3VwX2hvbWVfZGlyID0g
L3Zhci9kYi9teXNxbC9pbm5vZGIvbG9ncwo+Pgo+PiBXaGVuIEkgc3RhcnQgdGhlIHNlcnZlciB0
aGUgZmlyc3QgdGltZSB0aGUgSW5ub0RCIGZvbGRlcnMgYXJlIGNvcnJlY3RseQo+PiBwb3B1bGF0
ZWQgd2l0aCBzb21lIGRlZmF1bHQgZmlsZXMgbGlrZSBpbm5vZGIvaWJkYXRhMSBhbmQKPj4gaW5u
b2RiL2xvZ3MvaWJfbG9nZmlsZTAuIEJ1dCBhcyBzb29uIGFzIEkgY3JlYXRlIGEgbmV3IGRhdGFi
YXNlIChmb28pCj4+IHdpdGggSW5ub0RCIHRhYmxlcywgdGhlIHNlcnZlciBjcmVhdGVzIGEgL3Zh
ci9kYi9teXNxbC9mb28gZm9sZGVyIGFuZAo+PiBwb3B1bGF0ZXMgaXQgd2l0aCBpYmQgYW5kIGZy
bSBmaWxlcyB3aGVyZWFzIEkgd291bGQndmUgZXhwZWN0ZWQgaXQgdG8KPj4gY3JlYXRlIGl0IGFz
IC92YXIvZGIvbXlzcWwvaW5ub2RiL2ZvbyB0byBpbmhlcml0IHRoZSBjb3JyZWN0IDE2Swo+PiBy
ZWNvcmRzaXplLgo+Pgo+PiBJcyB0aGlzIGNvcnJlY3Q/IFNob3VsZG4ndCBpdCBiZSBjcmVhdGVk
IHVuZGVyIC92YXIvZGIvbXlzcWwvaW5ub2RiPwo+PiBIYXZlIEkgbWlzc2VkIHNvbWUgdml0YWwg
Y29uZmlndXJhdGlvbiBvcHRpb24/Cj4KPiBJIGRvbid0IHRoaW5rIGl0IHdvcmtzIHRoZSB3YXkg
eW91IGFyZSBleHBlY3RpbmcuCj4KPiBJZiB5b3UgaGF2ZSBpbm5vZGJfZmlsZV9wZXJfdGFibGUg
T2ZmLCB0aGVuIGFsbCBJbm5vREIgLyBYdHJhREIgdGFibGVzCj4gYXJlIHN0b3JlZCBpbiBpYl9k
YXRhIGZpbGUocykgaW4gaW5ub2RiX2RhdGFfaG9tZV9kaXIgPQo+IC92YXIvZGIvbXlzcWwvaW5u
b2RiCj4gQnV0IHNvbWUgbWV0YWRhdGEgKGZybSBmaWxlcykgYXJlIHN0b3JlZCBpbiAvdmFyL2Ri
L215c3FsL2RhdGFiYXNlbmFtZS8KPgo+IElmIHlvdSBoYXZlIGlubm9kYl9maWxlX3Blcl90YWJs
ZSBPbiwgdGhlbiBhbGwgdGFibGVzIGRhdGEgYXJlIHN0b3JlZCBpbgo+IC92YXIvZGIvbXlzcWwv
ZGF0YWJhc2VuYW1lLyBhbmQgb25seSBpbnRlcm5hbCBJbm5vREIgZGF0YSBhcmUgc3RvcmVkIGlu
Cj4gL3Zhci9kYi9teXNxbC9pbm5vZGIvaWJfZGF0YQo+CgpUaGFuayB5b3UgTWlyb3NsYXYsIHRo
aXMgd2FzIHRoZSB2aXRhbCBwaWVjZSBvZiBpbmZvcm1hdGlvbiBJIG5lZWRlZC4gSXQgCnNlZW1z
IE15U1FMIGNoYW5nZWQgdGhlIGRlZmF1bHQgdmFsdWUgb2YgaW5ub2RiX2ZpbGVfcGVyX3RhYmxl
IGZyb20gMCB0byAKMSB3aXRoIHZlcnNpb24gNS42LgpodHRwczovL2Rldi5teXNxbC5jb20vZG9j
L3JlZm1hbi81LjYvZW4vc2VydmVyLWRlZmF1bHQtY2hhbmdlcy5odG1sCgpUaGUgcGFyYW1ldGVy
IGlzbid0IG1lbnRpb25lZCBpbiBhbnkgb2YgdGhlIG9ubGluZSBaRlMvTXlTUUwgd2lraXMgb3Ig
CmJsb2dzIHRoYXQgSSd2ZSBmb3VuZCwgbm90IGV2ZW4gRnJlZUJTRCdzIG93biB3aWtpLiBJIGFz
c3VtZSB0aGlzIGNoYW5nZSAKY291bGQgaW50ZXJmZXJlIHdpdGggcGVvcGxlIHJ1bm5pbmcgcHJv
ZHVjdGlvbiBzeXN0ZW1zIG9uIFpGUy4gClBlcnNvbmFsbHkgSSdtIHJlbHVjdGFudCB0byBjaGFu
Z2UgZGVmYXVsdCB2YWx1ZXMgdW5sZXNzIEkgaGF2ZSBhIHZlcnkgCmdvb2QgcmVhc29uIHRvIGRv
IHNvLCBzbyBJIHdpbGwgdHJ5IHRvIGZpbmQgYSB3YXkgdG8gYWRhcHQgdG8gaXQuIFlvdXIgCnN1
Z2dlc3Rpb24gdG8gcHV0IHRoZSB3aG9sZSBvZiAvdmFyL2RiL215c3FsIG9uIGEgMTZLIHJlY29y
ZHNpemUgKGV4Y2VwdCAKZm9yIHRoZSBsb2dzIGRpcmVjdG9yeSkgaXMgcHJvYmFibHkgdGhlIHdh
eSB0byBnby4gSSBqdXN0IG5lZWQgdG8gZGVsdmUgCmEgbGl0dGxlIGJpdCBmdXJ0aGVyIGludG8g
dGhlIHN1YmplY3QgYmVmb3JlIEkgbWFrZSB1cCBteSBtaW5kLiBUaGFuayAKeW91IGFnYWluIGZv
ciBwb2ludGluZyBtZSBpbiB0aGUgcmlnaHQgZGlyZWN0aW9uLgoKTW9yZ2FuCl9fX19fX19fX19f
X19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fCmZyZWVic2QtZGF0YWJhc2VAZnJl
ZWJzZC5vcmcgbWFpbGluZyBsaXN0Cmh0dHBzOi8vbGlzdHMuZnJlZWJzZC5vcmcvbWFpbG1hbi9s
aXN0aW5mby9mcmVlYnNkLWRhdGFiYXNlClRvIHVuc3Vic2NyaWJlLCBzZW5kIGFueSBtYWlsIHRv
ICJmcmVlYnNkLWRhdGFiYXNlLXVuc3Vic2NyaWJlQGZyZWVic2Qub3JnIg==