From: Hendrik Woltersdorf Date: November 25 2010 11:11am Subject: Antwort: Re: reason for slow query ? List-Archive: http://lists.mysql.com/cluster/7899 Message-Id: MIME-Version: 1.0 Content-Type: multipart/related; Boundary="0__=4EBBFD75DFAF40128f9e8a93df938690918c4EBBFD75DFAF4012" --0__=4EBBFD75DFAF40128f9e8a93df938690918c4EBBFD75DFAF4012 Content-type: multipart/alternative; Boundary="1__=4EBBFD75DFAF40128f9e8a93df938690918c4EBBFD75DFAF4012" --1__=4EBBFD75DFAF40128f9e8a93df938690918c4EBBFD75DFAF4012 Content-type: text/plain; charset=ISO-8859-15 Content-transfer-encoding: base64 SGkgSm9oYW4sDQoNCnRoZSBwcmltYXJ5IGluZGV4IGlzIHZlcnkgZ29vZC4gTWFueSBvZiB0aGVz ZSBxdWVyaWVzIHJ1biBmYXN0LCBidXQgYSBmZXcNCmRvbid0LiBBbmQgd2hlbiBJIHJlcGVhdCBh IHNsb3cgcXVlcnkgbWFudWFsbHkgaXQgcnVucyB2ZXJ5IGZhc3QgdG9vLiBBdA0KdGhlIG1vbWVu dCBJIGFtIGxvb2tpbmcgZm9yIG90aGVyIHJlYXNvbnMsIHRoYXQgc2xvdyBkb3duIHF1ZXJpZXMN Cl9zb21ldGltZXNfLiBJIGNoZWNrZWQgdGhlIGxvZ3MgZm9yIExDUHMgYnV0IHRoZSBMQ1AtdGlt ZXMgZG8gbm90IGNvcnJlbGF0ZQ0Kd2l0aCB0aGUgZW50cmllcyBpbiB0aGUgc2xvdy1xdWVyeSBs b2cuDQoNCkFueSBvdGhlciBpZGVhcyA/DQoNCmtpbmQgcmVnYXJkcw0KDQpIZW5kcmlrIFdvbHRl cnNkb3JmDQpYQ09NIEFHDQpUZWwuOiAwMzc1LzI3MDA4LTU4MA0KVGVsLiBtb2JpbDogMDE3OC81 NzEwMDc4DQpFbWFpbDogSGVuZHJpay5Xb2x0ZXJzZG9yZkB4Y29tLmRlDQoNCg0KDQoNCioqKiBY Q09NIEFHIExlZ2FsIERpc2NsYWltZXIgKioqDQoNCkRpZXNlIEUtTWFpbCBlaW5zY2hsaWVzc2xp Y2ggaWhyZXIgQW5oYWVuZ2UgaXN0IHZlcnRyYXVsaWNoIHVuZCBpc3QgYWxsZWluDQpm/HIgZGVu IEdlYnJhdWNoIGR1cmNoIGRlbiB2b3JnZXNlaGVuZW4gRW1wZmFlbmdlciBiZXN0aW1tdC4gRHJp dHRlbiBpc3QNCmRhcyBMZXNlbiwgVmVydGVpbGVuIG9kZXIgV2VpdGVybGVpdGVuIGRpZXNlciBF LU1haWwgdW50ZXJzYWd0LiBXaXIgYml0dGVuLA0KZWluZSBmZWhsZ2VsZWl0ZXRlIEUtTWFpbCB1 bnZlcnp1ZWdsaWNoIHZvbGxzdGFlbmRpZyB6dSBsb2VzY2hlbiB1bmQgdW5zDQplaW5lIE5hY2hy aWNodCB6dWtvbW1lbiB6dSBsYXNzZW4uDQoNClRoaXMgZW1haWwgbWF5IGNvbnRhaW4gbWF0ZXJp YWwgdGhhdCBpcyBjb25maWRlbnRpYWwgYW5kIGZvciB0aGUgc29sZSB1c2UNCm9mIHRoZSBpbnRl bmRlZCByZWNpcGllbnQuIEFueSByZXZpZXcsIGRpc3RyaWJ1dGlvbiBieSBvdGhlcnMgb3IgZm9y d2FyZGluZw0Kd2l0aG91dCBleHByZXNzIHBlcm1pc3Npb24gaXMgc3RyaWN0bHkgcHJvaGliaXRl ZC4gSWYgeW91IGFyZSBub3QgdGhlDQppbnRlbmRlZCByZWNpcGllbnQsIHBsZWFzZSBjb250YWN0 IHRoZSBzZW5kZXIgYW5kIGRlbGV0ZSBhbGwgY29waWVzLg0KDQpIYXVwdHNpdHo6IEJhaG5zdHJh c3NlIDM3LCBELTQ3ODc3IFdpbGxpY2gsIFVTdC1JZE5yLjogREUgODEyIDg4NSA2NjQNCktvbW11 bmlrYXRpb246IFRlbGVmb24gKzQ5IDIxNTQgOTIwOS03MCwgVGVsZWZheCArNDkgMjE1NCA5MjA5 LTkwMCwNCnd3dy54Y29tLmRlDQpIYW5kZWxzcmVnaXN0ZXI6IEFtdHNnZXJpY2h0IEtyZWZlbGQs IEhSQiAxMDM0MA0KVm9yc3RhbmQ6IE1hdHRoaWFzIEFsYnJlY2h0LCBEaXJrIEZyYW56bWV5ZXIs IERyLiBSYWluZXIgRnVjaHMsIE1hcmNvDQpNYXJ0eSwgRGlyayBXZXJuZXINClZvcnNpdHplbmRl ciBkZXMgQXVmc2ljaHRzcmF0ZXM6IFN0ZWZhbiBILiBUYXJhY2gNCiAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg IA0KICAgICAgICAgICAgIEpvaGFuIEFuZGVyc3NvbiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgDQogICAgICAgICAgICAgPGpvaGFuQHNldmVyYWxuaW4gICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICBl cy5jb20+ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg IEFuIA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEhlbmRyaWsgV29s dGVyc2RvcmYgICAgICAgICAgICAgICAgDQogICAgICAgICAgICAgMjUuMTEuMjAxMCAxMTo0MCAg ICAgICAgICAgPGhlbmRyaWsud29sdGVyc2RvcmZAeGNvbS5kZT4gICAgICANCiAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg IEtvcGllIA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIGNsdXN0ZXJA bGlzdHMubXlzcWwuY29tICAgICAgICAgICAgDQogICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBUaGVtYSANCiAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBSZTogcmVhc29uIGZvciBzbG93IHF1ZXJ5 ID8gICAgICAgIA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQogICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCiAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQogICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCiAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgIA0KDQoNCg0KDQpIaSwNCg0KUGVyaGFwcyBQUklNQVJZIGlzIG5vdCB0 aGUgYmVzdCBpbmRleC4NCg0KVHJ5IHRvIHVzZSAndGFuX2xpc3QnIGluc3RlYWQuDQoNClNFTEVD VCAgKiAgRlJPTSB0YW5fbGlzdCBGT1JDRSBJTkRFWCh0YW5fbGlzdCkgV0hFUkUgKFNFQ19UWVBF PSdDYXJkJyBBTkQNClRBTl9MSVNUX05VTUJFUj0nMScgQU5EIFVTRVJfSUQ9JzEwMjMwMjknIEFO RCBDTElFTlRfSUQ9JzEnICk7DQoNCkJSDQpqb2hhbg0KDQoyMyBub3YgMjAxMCBrbC4gMTQuMTYg c2tyZXYgSGVuZHJpayBXb2x0ZXJzZG9yZjoNCg0K --1__=4EBBFD75DFAF40128f9e8a93df938690918c4EBBFD75DFAF4012 Content-type: text/html; charset=ISO-8859-15 Content-Disposition: inline Content-transfer-encoding: base64 PGh0bWw+PGJvZHk+DQo8cD5IaSBKb2hhbiw8YnI+DQo8YnI+DQp0aGUgcHJpbWFyeSBpbmRleCBp cyB2ZXJ5IGdvb2QuIE1hbnkgb2YgdGhlc2UgcXVlcmllcyBydW4gZmFzdCwgYnV0IGEgZmV3IGRv bid0LiBBbmQgd2hlbiBJIHJlcGVhdCBhIHNsb3cgcXVlcnkgbWFudWFsbHkgaXQgcnVucyB2ZXJ5 IGZhc3QgdG9vLiBBdCB0aGUgbW9tZW50IEkgYW0gbG9va2luZyBmb3Igb3RoZXIgcmVhc29ucywg dGhhdCBzbG93IGRvd24gcXVlcmllcyBfc29tZXRpbWVzXy4gSSBjaGVja2VkIHRoZSBsb2dzIGZv ciBMQ1BzIGJ1dCB0aGUgTENQLXRpbWVzIGRvIG5vdCBjb3JyZWxhdGUgd2l0aCB0aGUgZW50cmll cyBpbiB0aGUgc2xvdy1xdWVyeSBsb2cuIDxicj4NCjxicj4NCkFueSBvdGhlciBpZGVhcyA/PGJy Pg0KPGJyPg0Ka2luZCByZWdhcmRzPGJyPg0KPGJyPg0KSGVuZHJpayBXb2x0ZXJzZG9yZjxicj4N ClhDT00gQUc8YnI+DQpUZWwuOiAwMzc1LzI3MDA4LTU4MDxicj4NClRlbC4gbW9iaWw6IDAxNzgv NTcxMDA3ODxicj4NCkVtYWlsOiBIZW5kcmlrLldvbHRlcnNkb3JmQHhjb20uZGU8YnI+DQo8YnI+ DQo8YnI+DQo8Zm9udCBzaXplPSIyIiBmYWNlPSJBcmlhbCI+PGJyPg0KPGJyPg0KPC9mb250Pjxm b250IHNpemU9IjIiIGZhY2U9IkFyaWFsIj4qKiogWENPTSBBRyBMZWdhbCBEaXNjbGFpbWVyICoq Kjxicj4NCjxicj4NCkRpZXNlIEUtTWFpbCBlaW5zY2hsaWVzc2xpY2ggaWhyZXIgQW5oYWVuZ2Ug aXN0IHZlcnRyYXVsaWNoIHVuZCBpc3QgYWxsZWluIGb8ciBkZW4gR2VicmF1Y2ggZHVyY2ggZGVu IHZvcmdlc2VoZW5lbiBFbXBmYWVuZ2VyIGJlc3RpbW10LiBEcml0dGVuIGlzdCBkYXMgTGVzZW4s IFZlcnRlaWxlbiBvZGVyIFdlaXRlcmxlaXRlbiBkaWVzZXIgRS1NYWlsIHVudGVyc2FndC4gV2ly IGJpdHRlbiwgZWluZSBmZWhsZ2VsZWl0ZXRlIEUtTWFpbCB1bnZlcnp1ZWdsaWNoIHZvbGxzdGFl bmRpZyB6dSBsb2VzY2hlbiB1bmQgdW5zIGVpbmUgTmFjaHJpY2h0IHp1a29tbWVuIHp1IGxhc3Nl bi48YnI+DQo8YnI+DQpUaGlzIGVtYWlsIG1heSBjb250YWluIG1hdGVyaWFsIHRoYXQgaXMgY29u ZmlkZW50aWFsIGFuZCBmb3IgdGhlIHNvbGUgdXNlIG9mIHRoZSBpbnRlbmRlZCByZWNpcGllbnQu IEFueSByZXZpZXcsIGRpc3RyaWJ1dGlvbiBieSBvdGhlcnMgb3IgZm9yd2FyZGluZyB3aXRob3V0 IGV4cHJlc3MgcGVybWlzc2lvbiBpcyBzdHJpY3RseSBwcm9oaWJpdGVkLiBJZiB5b3UgYXJlIG5v dCB0aGUgaW50ZW5kZWQgcmVjaXBpZW50LCBwbGVhc2UgY29udGFjdCB0aGUgc2VuZGVyIGFuZCBk ZWxldGUgYWxsIGNvcGllcy48YnI+DQo8YnI+DQpIYXVwdHNpdHo6IEJhaG5zdHJhc3NlIDM3LCBE LTQ3ODc3IFdpbGxpY2gsIFVTdC1JZE5yLjogREUgODEyIDg4NSA2NjQ8YnI+DQpLb21tdW5pa2F0 aW9uOiBUZWxlZm9uICs0OSAyMTU0IDkyMDktNzAsIFRlbGVmYXggKzQ5IDIxNTQgOTIwOS05MDAs IHd3dy54Y29tLmRlPGJyPg0KSGFuZGVsc3JlZ2lzdGVyOiBBbXRzZ2VyaWNodCBLcmVmZWxkLCBI UkIgMTAzNDA8YnI+DQpWb3JzdGFuZDogTWF0dGhpYXMgQWxicmVjaHQsIERpcmsgRnJhbnptZXll ciwgRHIuIFJhaW5lciBGdWNocywgTWFyY28gTWFydHksIERpcmsgV2VybmVyPGJyPg0KVm9yc2l0 emVuZGVyIGRlcyBBdWZzaWNodHNyYXRlczogU3RlZmFuIEguIFRhcmFjaDwvZm9udD48aW1nIHdp ZHRoPSIxNiIgaGVpZ2h0PSIxNiIgc3JjPSJjaWQ6MV9fPTRFQkJGRDc1REZBRjQwMTI4ZjllOGE5 M2RmOTM4NjkwQHhjb20uZGUiIGJvcmRlcj0iMCIgYWx0PSJJbmFjdGl2ZSBoaWRlIGRldGFpbHMg Zm9yIEpvaGFuIEFuZGVyc3NvbiAtLS0yNS4xMS4yMDEwIDExOjQwOjQ2LS0tSGksIj48Zm9udCBj b2xvcj0iIzQyNDI4MiI+Sm9oYW4gQW5kZXJzc29uIC0tLTI1LjExLjIwMTAgMTE6NDA6NDYtLS1I aSw8L2ZvbnQ+DQo8cD4NCjx0YWJsZSB3aWR0aD0iMTAwJSIgYm9yZGVyPSIwIiBjZWxsc3BhY2lu Zz0iMCIgY2VsbHBhZGRpbmc9IjAiPg0KPHRyIHZhbGlnbj0idG9wIj48dGQgc3R5bGU9ImJhY2tn cm91bmQtaW1hZ2U6dXJsKGNpZDoyX189NEVCQkZENzVERkFGNDAxMjhmOWU4YTkzZGY5Mzg2OTBA eGNvbS5kZSk7IGJhY2tncm91bmQtcmVwZWF0OiBuby1yZXBlYXQ7ICIgd2lkdGg9IjQwJSI+DQo8 dWw+DQo8dWw+DQo8dWw+DQo8dWw+PGI+PGZvbnQgc2l6ZT0iMiI+Sm9oYW4gQW5kZXJzc29uICZs dDtqb2hhbkBzZXZlcmFsbmluZXMuY29tJmd0OzwvZm9udD48L2I+PGZvbnQgc2l6ZT0iMiI+IDwv Zm9udD4NCjxwPjxmb250IHNpemU9IjIiPjI1LjExLjIwMTAgMTE6NDA8L2ZvbnQ+PC91bD4NCjwv dWw+DQo8L3VsPg0KPC91bD4NCjwvdGQ+PHRkIHdpZHRoPSI2MCUiPg0KPHRhYmxlIHdpZHRoPSIx MDAlIiBib3JkZXI9IjAiIGNlbGxzcGFjaW5nPSIwIiBjZWxscGFkZGluZz0iMCI+DQo8dHIgdmFs aWduPSJ0b3AiPjx0ZCB3aWR0aD0iMSUiIHZhbGlnbj0ibWlkZGxlIj48aW1nIHdpZHRoPSI2MyIg aGVpZ2h0PSIxIiBzcmM9ImNpZDozX189NEVCQkZENzVERkFGNDAxMjhmOWU4YTkzZGY5Mzg2OTBA eGNvbS5kZSIgYm9yZGVyPSIwIiBhbHQ9IiI+PGJyPg0KPGRpdiBhbGlnbj0icmlnaHQiPjxmb250 IHNpemU9IjIiPkFuPC9mb250PjwvZGl2PjwvdGQ+PHRkIHdpZHRoPSIxMDAlIj48aW1nIHdpZHRo PSIxIiBoZWlnaHQ9IjEiIHNyYz0iY2lkOjNfXz00RUJCRkQ3NURGQUY0MDEyOGY5ZThhOTNkZjkz ODY5MEB4Y29tLmRlIiBib3JkZXI9IjAiIGFsdD0iIj48YnI+DQo8Zm9udCBzaXplPSIyIj5IZW5k cmlrIFdvbHRlcnNkb3JmICZsdDtoZW5kcmlrLndvbHRlcnNkb3JmQHhjb20uZGUmZ3Q7PC9mb250 PjwvdGQ+PC90cj4NCg0KPHRyIHZhbGlnbj0idG9wIj48dGQgd2lkdGg9IjElIiB2YWxpZ249Im1p ZGRsZSI+PGltZyB3aWR0aD0iNjMiIGhlaWdodD0iMSIgc3JjPSJjaWQ6M19fPTRFQkJGRDc1REZB RjQwMTI4ZjllOGE5M2RmOTM4NjkwQHhjb20uZGUiIGJvcmRlcj0iMCIgYWx0PSIiPjxicj4NCjxk aXYgYWxpZ249InJpZ2h0Ij48Zm9udCBzaXplPSIyIj5Lb3BpZTwvZm9udD48L2Rpdj48L3RkPjx0 ZCB3aWR0aD0iMTAwJSI+PGltZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiBzcmM9ImNpZDozX189NEVC QkZENzVERkFGNDAxMjhmOWU4YTkzZGY5Mzg2OTBAeGNvbS5kZSIgYm9yZGVyPSIwIiBhbHQ9IiI+ PGJyPg0KPGZvbnQgc2l6ZT0iMiI+Y2x1c3RlckBsaXN0cy5teXNxbC5jb208L2ZvbnQ+PC90ZD48 L3RyPg0KDQo8dHIgdmFsaWduPSJ0b3AiPjx0ZCB3aWR0aD0iMSUiIHZhbGlnbj0ibWlkZGxlIj48 aW1nIHdpZHRoPSI2MyIgaGVpZ2h0PSIxIiBzcmM9ImNpZDozX189NEVCQkZENzVERkFGNDAxMjhm OWU4YTkzZGY5Mzg2OTBAeGNvbS5kZSIgYm9yZGVyPSIwIiBhbHQ9IiI+PGJyPg0KPGRpdiBhbGln bj0icmlnaHQiPjxmb250IHNpemU9IjIiPlRoZW1hPC9mb250PjwvZGl2PjwvdGQ+PHRkIHdpZHRo PSIxMDAlIj48aW1nIHdpZHRoPSIxIiBoZWlnaHQ9IjEiIHNyYz0iY2lkOjNfXz00RUJCRkQ3NURG QUY0MDEyOGY5ZThhOTNkZjkzODY5MEB4Y29tLmRlIiBib3JkZXI9IjAiIGFsdD0iIj48YnI+DQo8 Zm9udCBzaXplPSIyIj5SZTogcmVhc29uIGZvciBzbG93IHF1ZXJ5ID88L2ZvbnQ+PC90ZD48L3Ry Pg0KPC90YWJsZT4NCg0KPHRhYmxlIGJvcmRlcj0iMCIgY2VsbHNwYWNpbmc9IjAiIGNlbGxwYWRk aW5nPSIwIj4NCjx0ciB2YWxpZ249InRvcCI+PHRkIHdpZHRoPSI1OCI+PGltZyB3aWR0aD0iMSIg aGVpZ2h0PSIxIiBzcmM9ImNpZDozX189NEVCQkZENzVERkFGNDAxMjhmOWU4YTkzZGY5Mzg2OTBA eGNvbS5kZSIgYm9yZGVyPSIwIiBhbHQ9IiI+PC90ZD48dGQgd2lkdGg9IjMzNiI+PGltZyB3aWR0 aD0iMSIgaGVpZ2h0PSIxIiBzcmM9ImNpZDozX189NEVCQkZENzVERkFGNDAxMjhmOWU4YTkzZGY5 Mzg2OTBAeGNvbS5kZSIgYm9yZGVyPSIwIiBhbHQ9IiI+PC90ZD48L3RyPg0KPC90YWJsZT4NCjwv dGQ+PC90cj4NCjwvdGFibGU+DQo8YnI+DQo8dHQ+SGksPGJyPg0KPGJyPg0KUGVyaGFwcyBQUklN QVJZIGlzIG5vdCB0aGUgYmVzdCBpbmRleC48YnI+DQo8YnI+DQpUcnkgdG8gdXNlICd0YW5fbGlz dCcgaW5zdGVhZC48YnI+DQo8YnI+DQpTRUxFQ1QgJm5ic3A7KiAmbmJzcDtGUk9NIHRhbl9saXN0 IEZPUkNFIElOREVYKHRhbl9saXN0KSBXSEVSRSAoU0VDX1RZUEU9J0NhcmQnIEFORCBUQU5fTElT VF9OVU1CRVI9JzEnIEFORCBVU0VSX0lEPScxMDIzMDI5JyBBTkQgQ0xJRU5UX0lEPScxJyApOzxi cj4NCjxicj4NCkJSPGJyPg0Kam9oYW48YnI+DQo8YnI+DQoyMyBub3YgMjAxMCBrbC4gMTQuMTYg c2tyZXYgSGVuZHJpayBXb2x0ZXJzZG9yZjo8YnI+DQo8YnI+DQo8L3R0Pjxicj4NCjwvYm9keT48 L2h0bWw+ --1__=4EBBFD75DFAF40128f9e8a93df938690918c4EBBFD75DFAF4012-- --0__=4EBBFD75DFAF40128f9e8a93df938690918c4EBBFD75DFAF4012--