From: Hendrik Woltersdorf Date: November 23 2010 1:16pm Subject: reason for slow query ? List-Archive: http://lists.mysql.com/cluster/7897 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; Boundary="0__=4EBBFD77DFD45F3A8f9e8a93df938690918c4EBBFD77DFD45F3A" --0__=4EBBFD77DFD45F3A8f9e8a93df938690918c4EBBFD77DFD45F3A Content-type: text/plain; charset=ISO-8859-15 Content-transfer-encoding: base64 DQpIaSwNCg0KSSBoYXZlIGEgTXlTUUwgY2x1c3RlciB2ZXJzaW9uIDcuMC4xMyBydW5uaW5nIG9u IDQgbWFjaGluZXMgKDJ4IG15c3FsZCBhcw0KQVBJIG5vZGUsIDJ4IGRhdGEgbm9kZSB3aXRoIG5k Ym10ZCkuIE9uZSBBUEkgbm9kZSBsb2dnZWQgYSBzbG93IHF1ZXJ5Og0KDQojIFRpbWU6IDEwMTEy MyAxMzozMzo0MA0KIyBVc2VyQEhvc3Q6IHBpdGFzZVtwaXRhc2VdIEAgIFs2Mi4xOTIuMjA0LjE0 XQ0KIyBRdWVyeV90aW1lOiAzLjQ0Njc3OSAgTG9ja190aW1lOiAwLjAwMDA1NyBSb3dzX3NlbnQ6 IDAgIFJvd3NfZXhhbWluZWQ6IDANClNFVCB0aW1lc3RhbXA9MTI5MDUxNTYyMDsNClNFTEVDVCAg KiAgRlJPTSB0YW5fbGlzdCBXSEVSRSAoU0VDX1RZUEU9J0NhcmQnIEFORCBUQU5fTElTVF9OVU1C RVI9JzEnIEFORA0KVVNFUl9JRD0nMTAyMzAyOScgQU5EIENMSUVOVF9JRD0nMScgKTsNCg0KV2hl biBJIGV4ZWN1dGUgdGhpcyBxdWVyeSBtYW51YWxseSBpdCBpcyBfdmVyeV8gZmFzdCBhbmQgImV4 cGxhaW4gZXh0ZW5kZWQiDQp0ZWxscyBtZSwgdGhhdCBpdCB1c2VzIHRoZSBwcmltYXJ5IGtleSBv ZiB0aGUgdGFibGU6DQoNCkNSRUFURSBUQUJMRSBgdGFuX2xpc3RgICgNCiAgYGNsaWVudF9pZGAg dmFyY2hhcigxMCkgTk9UIE5VTEwsDQogIGBzZWNfdHlwZWAgdmFyY2hhcigxMCkgTk9UIE5VTEws DQogIGB1c2VyX2lkYCB2YXJjaGFyKDMwKSBOT1QgTlVMTCwNCiAgYHN0YXRlYCBpbnQoMTEpIE5P VCBOVUxMLA0KICBgdGFuX2xpc3RfbnVtYmVyYCB2YXJjaGFyKDgpIE5PVCBOVUxMLA0KICBgdGFu X2RhdGFgIGJsb2IsDQogIGB0YW5fY291bnRgIGludCgxMSkgREVGQVVMVCBOVUxMLA0KICBgb3Bl bl90YW5fY291bnRgIGludCgxMSkgREVGQVVMVCBOVUxMLA0KICBgZXJyb3JfY291bnRgIGludCgx MSkgREVGQVVMVCBOVUxMLA0KICBgbGV0dGVyX3JlcXVlc3RfdGltZWAgZGF0ZXRpbWUgREVGQVVM VCBOVUxMLA0KICBgYWN0aXZhdGlvbl90aW1lYCBkYXRldGltZSBERUZBVUxUIE5VTEwsDQogIGBs ZXR0ZXJfcmVjaXBpZW50YCB2YXJjaGFyKDEwMjQpIERFRkFVTFQgTlVMTCwNCiAgYGxldHRlcl9y ZXF1ZXN0X3R5cGVgIHZhcmNoYXIoNTApIERFRkFVTFQgTlVMTCwNCiAgYHRpbWVfaW5zZXJ0YCBk YXRldGltZSBERUZBVUxUIE5VTEwsDQogIGBsZXR0ZXJfc2VudF90aW1lYCBkYXRldGltZSBERUZB VUxUIE5VTEwsDQogIGBjYXJkX251bWJlcmAgdmFyY2hhcigxNikgREVGQVVMVCBOVUxMLA0KICBg cmVmX2lkYCB2YXJjaGFyKDM2KSBERUZBVUxUIE5VTEwsDQogIGByZWZfaWRfbmV4dGAgdmFyY2hh cigzNikgREVGQVVMVCBOVUxMLA0KICBQUklNQVJZIEtFWSAoYGNsaWVudF9pZGAsYHNlY190eXBl YCxgdXNlcl9pZGAsYHRhbl9saXN0X251bWJlcmApLA0KICBLRVkgYHRhbl9saXN0YCAoYHVzZXJf aWRgLGBjbGllbnRfaWRgLGBzZWNfdHlwZWAsYHRhbl9saXN0X251bWJlcmApLA0KICBLRVkgYHRh bl9saXN0X2lkeDFgIChgY2FyZF9udW1iZXJgKSwNCiAgS0VZIGB0YW5fbGlzdF9pZHgyYCAoYHN0 YXRlYCksDQogIEtFWSBgdGFuX2xpc3RfaWR4M2AgKGBvcGVuX3Rhbl9jb3VudGApDQopIEVOR0lO RT1uZGJjbHVzdGVyIERFRkFVTFQgQ0hBUlNFVD1sYXRpbjE7DQoNClRoaXMgdGFibGUgY29udGFp bnMgPiAxOTQwMDAgcm93cy4gVGhlcmUgd2VyZSBubyBvdGhlciBzbG93IHF1ZXJpZXMgbG9nZ2Vk DQphdCB0aGlzIHRpbWUgb24gdGhlIHR3byBBUEkgbm9kZXMuDQoNClRoZSBBUEkgbm9kZXMgdXNl IG5kYi1jbHVzdGVyLWNvbm5lY3Rpb24tcG9vbD00Lg0KDQpEb2VzIGFueW9uZSBoYXZlIGFuIGlk ZWEsIHdoYXQgY2F1c2VzIHRoaXMgbG9uZyBxdWVyeSB0aW1lID8NCg0Ka2luZCByZWdhcmRzDQoN CkhlbmRyaWsgV29sdGVyc2RvcmYNClhDT00gQUcNCkVtYWlsOiBIZW5kcmlrLldvbHRlcnNkb3Jm QHhjb20uZGUNCg0KDQoqKiogWENPTSBBRyBMZWdhbCBEaXNjbGFpbWVyICoqKg0KDQpEaWVzZSBF LU1haWwgZWluc2NobGllc3NsaWNoIGlocmVyIEFuaGFlbmdlIGlzdCB2ZXJ0cmF1bGljaCB1bmQg aXN0IGFsbGVpbg0KZvxyIGRlbiBHZWJyYXVjaCBkdXJjaCBkZW4gdm9yZ2VzZWhlbmVuIEVtcGZh ZW5nZXIgYmVzdGltbXQuIERyaXR0ZW4gaXN0DQpkYXMgTGVzZW4sIFZlcnRlaWxlbiBvZGVyIFdl aXRlcmxlaXRlbiBkaWVzZXIgRS1NYWlsIHVudGVyc2FndC4gV2lyIGJpdHRlbiwNCmVpbmUgZmVo bGdlbGVpdGV0ZSBFLU1haWwgdW52ZXJ6dWVnbGljaCB2b2xsc3RhZW5kaWcgenUgbG9lc2NoZW4g dW5kIHVucw0KZWluZSBOYWNocmljaHQgenVrb21tZW4genUgbGFzc2VuLg0KDQpUaGlzIGVtYWls IG1heSBjb250YWluIG1hdGVyaWFsIHRoYXQgaXMgY29uZmlkZW50aWFsIGFuZCBmb3IgdGhlIHNv bGUgdXNlDQpvZiB0aGUgaW50ZW5kZWQgcmVjaXBpZW50LiBBbnkgcmV2aWV3LCBkaXN0cmlidXRp b24gYnkgb3RoZXJzIG9yIGZvcndhcmRpbmcNCndpdGhvdXQgZXhwcmVzcyBwZXJtaXNzaW9uIGlz IHN0cmljdGx5IHByb2hpYml0ZWQuIElmIHlvdSBhcmUgbm90IHRoZQ0KaW50ZW5kZWQgcmVjaXBp ZW50LCBwbGVhc2UgY29udGFjdCB0aGUgc2VuZGVyIGFuZCBkZWxldGUgYWxsIGNvcGllcy4NCg0K SGF1cHRzaXR6OiBCYWhuc3RyYXNzZSAzNywgRC00Nzg3NyBXaWxsaWNoLCBVU3QtSWROci46IERF IDgxMiA4ODUgNjY0DQpLb21tdW5pa2F0aW9uOiBUZWxlZm9uICs0OSAyMTU0IDkyMDktNzAsIFRl bGVmYXggKzQ5IDIxNTQgOTIwOS05MDAsDQp3d3cueGNvbS5kZQ0KSGFuZGVsc3JlZ2lzdGVyOiBB bXRzZ2VyaWNodCBLcmVmZWxkLCBIUkIgMTAzNDANClZvcnN0YW5kOiBNYXR0aGlhcyBBbGJyZWNo dCwgRGlyayBGcmFuem1leWVyLCBEci4gUmFpbmVyIEZ1Y2hzLCBNYXJjbw0KTWFydHksIERpcmsg V2VybmVyDQpWb3JzaXR6ZW5kZXIgZGVzIEF1ZnNpY2h0c3JhdGVzOiBTdGVmYW4gSC4gVGFyYWNo --0__=4EBBFD77DFD45F3A8f9e8a93df938690918c4EBBFD77DFD45F3A--