From: Hendrik Woltersdorf Date: January 29 2010 2:21pm Subject: Re: howto implement a fifo queue in MySQL Cluster ? List-Archive: http://lists.mysql.com/cluster/7425 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; Boundary="0__=4EBBFC29DFDED3308f9e8a93df938690918c4EBBFC29DFDED330" --0__=4EBBFC29DFDED3308f9e8a93df938690918c4EBBFC29DFDED330 Content-type: text/plain; charset=ISO-8859-15 Content-transfer-encoding: base64 Tm8sIEkgYW0gdXNpbmcgdmVyc2lvbiA3LjAuNyAoYW5kIHdhaXRpbmcgZm9yIHRoZSBiaW5hcmll cyBvZiA3LjAuMTApLg0KVGhlIERBVEVUSU1FICg9IE5PVygpKSBhbmQgdGhlIEFVVE9fSU5DUkVN RU5UIGNvbHVtbiBhcmUgaW4gdGhlIHNhbWUgdGFibGUNCihRMlhfSEVBRCkuIFdlIGRvIG9ubHkg c2luZ2xlIHJvdyBpbnNlcnRzIGluIHRoZXNlIGFwcGxpY2F0aW9ucy4NClRoZSBBVVRPX0lOQ1JF TUVOVCBjb2x1bW4gaW4gdGFibGUgUTJYX0hFQUQgaXMgKHBlciBkZWZhdWx0KSBpbmNyZW1lbnRl ZCBieQ0KMS4NClNldHRpbmcgbmRiX2F1dG9pbmNyZW1lbnRfcHJlZmV0Y2hfc3ogdG8gMSBtYWRl IHRoZSAianVtcHMiIGluIHRoZSBJRA0KdmFsdWVzIHNtYWxsZXIgKDwgMzApLiBXaXRoIG5kYl9h dXRvaW5jcmVtZW50X3ByZWZldGNoX3N6ID0gMjU2ICh5ZXN0ZXJkYXkpDQpJIHNhdyAianVtcHMi IG9mID4gNTAwMDoNCg0KSUQgICAgREFURV9JTlNFUlQNCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLQ0KODQ4NCwgJzIwMTAtMDEtMjggMTU6MDA6MjgnDQo4NDgzLCAnMjAxMC0w MS0yOCAxNTowMDoyOCcNCjg0ODIsICcyMDEwLTAxLTI4IDE1OjAwOjI4Jw0KODQ4MSwgJzIwMTAt MDEtMjggMTU6MDA6MjgnDQoxMzk0NSwgJzIwMTAtMDEtMjggMTU6MDA6MjMnDQoxMzk0NCwgJzIw MTAtMDEtMjggMTU6MDA6MjMnDQouLi4NCjEzOTI4LCAnMjAxMC0wMS0yOCAxNTowMDoxMycNCjEz OTI3LCAnMjAxMC0wMS0yOCAxNTowMDoxMycNCjg0ODAsICcyMDEwLTAxLTI4IDE0OjU4OjU2Jw0K ODQ3OSwgJzIwMTAtMDEtMjggMTQ6NTg6NTYnDQoNCkkgd2lsbCByZXBlYXQgdGhpcyB0ZXN0cyBh cyBzb29uIGFzIEkgYW0gYWJsZSAoYW5kIGFsbG93ZWQpIHRvIGluc3RhbGwgYQ0KbmV3ZXIgdmVy c2lvbi4gSWYgdGhpcyBkb2VzIG5vdCBoZWxwLCBJIHdpbGwgaGF2ZSB0byBmYWxsIGJhY2sgdG8g dGhlDQoic2Vjb25kIGJlc3QiIG1ldGhvZC4gVGhhdCBtZWFucywgSSB3aWxsIG5vdCB1c2UgYXV0 b19pbmNyZW1lbnQgYnV0DQpnZW5lcmF0ZSB0aGUgbmV3IElEIHZhbHVlcyB3aXRoIHNlbGVjdCBt YXgoSUQpKzEgYW5kIGRlYWwgd2l0aCB0aGUNCmR1cGxpY2F0ZSBrZXkgYW5kIG5kYiB0aW1vdXQg ZXJyb3JzLiBUaGlzIHdpbGwgaHVydCBwZXJmb3JtYW5jZSBzZXZlcmVseQ0KYnV0IGlzIGd1YXJh bnRlZWQgdG8gd29yay4NCg0Ka2luZCByZWdhcmRzDQoNCkhlbmRyaWsgV29sdGVyc2RvcmYNClhD T00gQUcNClRlbC46IDAzNzUvMjcwMDgtNTgwDQpUZWwuIG1vYmlsOiAwMTc4LzU3MTAwNzgNCkVt YWlsOiBIZW5kcmlrLldvbHRlcnNkb3JmQHhjb20uZGUNCg0KTWFydGluLlNrb2xkQFN1bi5DT00g c2NocmllYiBhbSAyOS4wMS4yMDEwIDE1OjAzOjA4Og0KDQo+IE1hcnRpbiBTa29sZCA8TWFydGlu LlNrb2xkQFN1bi5DT00+DQo+IEdlc2VuZGV0IHZvbjogTWFydGluLlNrb2xkQFN1bi5DT00NCj4N Cj4gMjkuMDEuMjAxMCAxNTowMw0KPg0KPiBBbg0KPg0KPiBIZW5kcmlrIFdvbHRlcnNkb3JmIDxo ZW5kcmlrLndvbHRlcnNkb3JmQHhjb20uZGU+DQo+DQo+IEtvcGllDQo+DQo+IENsdXN0ZXIgPGNs dXN0ZXJAbGlzdHMubXlzcWwuY29tPg0KPg0KPiBUaGVtYQ0KPg0KPiBSZTogQW50d29ydDogUmU6 IFdHOiBSZTogQW50d29ydDogUmU6IGhvd3RvIGltcGxlbWVudCBhIGZpZm8gcXVldWUNCj4gaW4g TXlTUUwgQ2x1c3RlciA/DQo+DQo+IEkgYXNzdW1lIHlvdSBhcmUgdXNpbmcgdGhlIGxhdGVzdCB2 ZXJzaW9uPw0KPiBUaGVyZSB3YXMgYSBidWcgZml4ZWQgc29tZSBtb250aHMgYWdvOg0KPiBCdWcg IzM4MDM0IGxhc3RfaW5zZXJ0X2lkKCkgdmFsdWUgbm90IHNob3duIGluIHRhYmxlIHdpdGggdHJp Z2dlcg0KPg0KPiBEbyBJIHVuZGVyc3RhbmQgdGhpcyBjb3JyZWN0bHksIHRoZSBEQVRFIChvciBU SU1FU1RBTVApDQo+IGlzIG9uIG9uZSB0YWJsZSBhbmQgdGhlIEFVVE9fSU5DUkVNRU5UIGlzIG9u IGFub3RoZXI/DQo+IFdoYXQgZG9lcyB5b3VyIGluc2VydHMgaW50byBTVEFURV9ISVNUT1JZIGxv b2sgbGlrZT8NCj4gQXJlIHlvdSBkb2luZyBhbnkgbXVsdGktaW5zZXJ0cyBhbnl3aGVyZT8gSWYg eW91IGRvDQo+IElOU0VSVCAuLi4gVkFMVUVTIDxtdWx0aXBsZSB2YWx1ZXM+OyB0aGVuIHRoZSBh dXRvX2luYyBwcmUtZmV0Y2gNCj4gd2lsbCBiZSB0aGUgbnVtYmVyIG9mIHZhbHVlcyBpbnNlcnRl ZC4gSWYgeW91IGRvIElOU0VSVCAuLi4gV0hFUkUNCj4gdGhlbiBpdCB3aWxsIG1pbmltdW0gMzIg b3IgdGhlIHZhbHVlIG9mIG5kYl9hdXRvaW5jcmVtZW50X3ByZWZldGNoX3N6DQo+IGlmIHRoYXQg aXMgPiAzMi4gVGhlIHRyaWdnZXIgd2lsbCBleGVjdXRlIGZvciBlYWNoIHJvdywgYnV0IHRoZQ0K PiBsYXN0X2luc2VydF9pZCgpIHdpbGwgc2VlIHRoZSB2YWx1ZSBhZnRlciBwcmVmZXRjaGluZy4N Cj4gRXZlbiBpZiB5b3Ugb25seSBkbyBzaW5nbGUgcm93IGluc2VydHMgdGhlbiB0aGlzIGNvdWxk IHN0aWxsIGJlIGENCj4gcHJvYmxlbSwgYnV0IG9mIGNvdXJzZSBkaWZmZXJlbmNlIHNob3VsZCBu byBiZSB0d28gbWludXRlcy4NCj4gVHJ5IGRlZmluaW5nIHRoZSBhdXRvX2luY3JlbWVudCBvbiB0 aGUgUTJYX0hFQUQgdGFibGUgaW5zdGVhZCwgdGhhdA0KPiBzaG91bGQgaW5jcmVhc2UgYnkgc3Rl cHMgb2YgMS4NCj4NCj4gQlINCj4gLS0gTWFydGluDQo+IEhlbmRyaWsgV29sdGVyc2RvcmYgd3Jv dGU6DQo+ID4gSGksDQo+ID4NCj4gPiBJIGRpZCBub3QgdHJ5IHRoaXMgd2l0aCBvdGhlciBzdG9y YWdlIGVuZ2luZXMuIEFuZCBJIG5lZWQgdG8gZG8gdGhpcw0KPiA+IGluc2lkZSBvZiB0aGUgbmRi Y2x1c3Rlci4gTG9ja2luZyB0YWJsZXMgZXhwbGljaXRseSBjb21taXRzIC0gc28gc2F5cw0KPiA+ IHRoZSBtYW51YWwgLSBhbnkgb3BlbiB0cmFuc2FjdGlvbnMuIEkgY2Fubm90IGNvbW1pdCB0cmFu c2FjdGlvbnMgaW4NCj4gPiB0aGVzZSB0cmlnZ2Vycy4gVGhpcyB3b3VsZCBicmVhayB0aGUgYXBw bGljYXRpb24gdHJhbnNhY3Rpb25zLiBidHcuIHRoZQ0KDQo+ID4gbWFudWFsIHRlbGxzIG1lIGFs c28sIHRoYXQgbG9jayB0YWJsZSB3b3JrcyBvbmx5IGZvciB0aGUgc3FsIG5vZGUgb24NCj4gPiB3 aGljaCB0aGUgbG9jayBzdGF0ZW1lbnQgaXMgaXNzdWVkLiBTbyB0aGUgc2Vjb25kIHNxbCBub2Rl IHdpbGwgbm90IHNlZQ0KaXQuDQo+ID4gSSBkbyBub3QgdGhpbmssIHRoYXQgbG9ja2luZyB3aWxs IGhlbHAuIEluIHRoZSByZXN1bHRzZXQsIEkgcG9zdGVkDQo+ID4gZWFybGllciwgdGhlIElEIDE0 NzE5IGFwcGVhcnMgbW9yZSB0aGFuIHR3byBtaW51dGVzKCEpIGFmdGVyIElEIDE0NzM5Lg0KPiA+ IEFuZCB0aGUgY2xvY2tzIG9mIHRoZSBtYWNoaW5lcyBhcmUgaW4gc3luYyB0b2RheS4NCj4gPg0K PiA+IGtpbmQgcmVnYXJkcw0KPiA+DQo+ID4gSGVuZHJpayBXb2x0ZXJzZG9yZg0KPiA+IFhDT00g QUcNCj4gPiBUZWwuOiAwMzc1LzI3MDA4LTU4MA0KPiA+IFRlbC4gbW9iaWw6IDAxNzgvNTcxMDA3 OA0KPiA+IEVtYWlsOiBIZW5kcmlrLldvbHRlcnNkb3JmQHhjb20uZGUNCj4gPg0KPiA+IEluYWN0 aXZlIGhpZGUgZGV0YWlscyBmb3IgTWFydGluIFNrb2xkIC0tLTI5LjAxLjIwMTAgMTQ6MDY6MTMt LS1IaQ0KPiA+IGFnYWluIU1hcnRpbiBTa29sZCAtLS0yOS4wMS4yMDEwIDE0OjA2OjEzLS0tSGkg YWdhaW4hDQo+ID4NCj4gPiAgICAgICAgICAgICAgICAgICAgICAgICAqTWFydGluIFNrb2xkIDxN YXJ0aW4uU2tvbGRAU3VuLkNPTT4qDQo+ID4gICAgICAgICAgICAgICAgICAgICAgICAgR2VzZW5k ZXQgdm9uOiBNYXJ0aW4uU2tvbGRAU3VuLkNPTQ0KPiA+DQo+ID4gICAgICAgICAgICAgICAgICAg ICAgICAgMjkuMDEuMjAxMCAxNDowNQ0KPiA+DQo+ID4NCj4gPg0KPiA+IEFuDQo+ID4NCj4gPiBI ZW5kcmlrIFdvbHRlcnNkb3JmIDxoZW5kcmlrLndvbHRlcnNkb3JmQHhjb20uZGU+DQo+ID4NCj4g PiBLb3BpZQ0KPiA+DQo+ID4gQ2x1c3RlciA8Y2x1c3RlckBsaXN0cy5teXNxbC5jb20+DQo+ID4N Cg0KDQoNCg0KKioqIFhDT00gQUcgTGVnYWwgRGlzY2xhaW1lciAqKioNCg0KRGllc2UgRS1NYWls IGVpbnNjaGxpZXNzbGljaCBpaHJlciBBbmhhZW5nZSBpc3QgdmVydHJhdWxpY2ggdW5kIGlzdCBh bGxlaW4NCmb8ciBkZW4gR2VicmF1Y2ggZHVyY2ggZGVuIHZvcmdlc2VoZW5lbiBFbXBmYWVuZ2Vy IGJlc3RpbW10LiBEcml0dGVuIGlzdA0KZGFzIExlc2VuLCBWZXJ0ZWlsZW4gb2RlciBXZWl0ZXJs ZWl0ZW4gZGllc2VyIEUtTWFpbCB1bnRlcnNhZ3QuIFdpciBiaXR0ZW4sDQplaW5lIGZlaGxnZWxl aXRldGUgRS1NYWlsIHVudmVyenVlZ2xpY2ggdm9sbHN0YWVuZGlnIHp1IGxvZXNjaGVuIHVuZCB1 bnMNCmVpbmUgTmFjaHJpY2h0IHp1a29tbWVuIHp1IGxhc3Nlbi4NCg0KVGhpcyBlbWFpbCBtYXkg Y29udGFpbiBtYXRlcmlhbCB0aGF0IGlzIGNvbmZpZGVudGlhbCBhbmQgZm9yIHRoZSBzb2xlIHVz ZQ0Kb2YgdGhlIGludGVuZGVkIHJlY2lwaWVudC4gQW55IHJldmlldywgZGlzdHJpYnV0aW9uIGJ5 IG90aGVycyBvciBmb3J3YXJkaW5nDQp3aXRob3V0IGV4cHJlc3MgcGVybWlzc2lvbiBpcyBzdHJp Y3RseSBwcm9oaWJpdGVkLiBJZiB5b3UgYXJlIG5vdCB0aGUNCmludGVuZGVkIHJlY2lwaWVudCwg cGxlYXNlIGNvbnRhY3QgdGhlIHNlbmRlciBhbmQgZGVsZXRlIGFsbCBjb3BpZXMuDQoNCkhhdXB0 c2l0ejogQmFobnN0cmFzc2UgMzcsIEQtNDc4NzcgV2lsbGljaCwgVVN0LUlkTnIuOiBERSA4MTIg ODg1IDY2NA0KS29tbXVuaWthdGlvbjogVGVsZWZvbiArNDkgMjE1NCA5MjA5LTcwLCBUZWxlZmF4 ICs0OSAyMTU0IDkyMDktOTAwLA0Kd3d3Lnhjb20uZGUNCkhhbmRlbHNyZWdpc3RlcjogQW10c2dl cmljaHQgS3JlZmVsZCwgSFJCIDEwMzQwDQpWb3JzdGFuZDogTWF0dGhpYXMgQWxicmVjaHQsIE1h cmNvIE1hcnR5LCBEci4gUmFpbmVyIEZ1Y2hzLCBEaXJrIFdlcm5lcg0KVm9yc2l0emVuZGVyIGRl cyBBdWZzaWNodHNyYXRlczogU3RlZmFuIEguIFRhcmFjaA== --0__=4EBBFC29DFDED3308f9e8a93df938690918c4EBBFC29DFDED330--