Repair Command takes too much time

--------------090202080803050308040303
Content-Type: multipart/alternative;
boundary="------------050004000501050609040209"


--------------050004000501050609040209
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Dear all,

I have a table a_src in a mysql database as :

12K ac_src.frm
25G ac_src.MYD
60M ac_src.MYI

Yesterday, near about 2 pm , I got the error :
Error 1602 (23000) : Duplicate '6204567' for key 1

I solve this issue before by repairing the table but this time the data
is very large.

When I issue *repair table ac_src command *it take more than 20 hours
to complete and still running.
Accidently, server power got down & my command destroyed.

Today I got stuck to it because I want to use that table & insert data
in it. When I check my table it shows :

mysql> check table hc_source;
+------------------------+-------+----------+--------------- ------------------------------------------------------------ ----------------+
| Table | Op | Msg_type |
Msg_text
|
+------------------------+-------+----------+--------------- ------------------------------------------------------------ ----------------+
| test_crawler.hc_source | check | error | Table
'./test_crawler/hc_source' is marked as crashed and last (automatic?)
repair failed |
+------------------------+-------+----------+--------------- ------------------------------------------------------------ ----------------+
1 row in set (0.00 sec)

If I issue the repair command again again I know it can take morw than a
day. I also attached my my.cnf file.
I test the command

myisamchk --silent --force --fast --update-state --key_buffer_size=512M
--sort_buffer_size=512M --read_buffer_size=4M --write_buffer_size=4M
/hrd2-2/myisam_data/test_crawler/hc_source.MYI

and it is still running.


Please help me to solve this problem and is there any simple solution to
solve this.

Thanks & best Regards,
Adarsh Sharma


--------------050004000501050609040209
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit






Dear all,



I have a table a_src in a mysql database as :



12K     ac_src.frm

25G     ac_src.MYD

60M     ac_src.MYI



Yesterday, near about 2 pm , I got the error :

Error 1602 (23000) : Duplicate '6204567' for key 1



I solve this issue before by repairing the table but this time the data
is very large.



When I issue repair table ac_src  command it take more than 20
hours to complete and still running.

Accidently, server power got down & my command destroyed.



Today I got stuck to it because I want to use that table & insert
data in it. When I check my table it shows :



mysql> check table hc_source;

+------------------------+-------+----------+--------------- ------------------------------------------------------------ ----------------+

| Table                  | Op    | Msg_type |
Msg_text                                                                                  
|

+------------------------+-------+----------+--------------- ------------------------------------------------------------ ----------------+

| test_crawler.hc_source | check | error    | Table
'./test_crawler/hc_source' is marked as crashed and last (automatic?)
repair failed |

+------------------------+-------+----------+--------------- ------------------------------------------------------------ ----------------+

1 row in set (0.00 sec)



If I issue the repair command again again I know it can take morw than
a day. I also attached my my.cnf file.

I test the command



myisamchk --silent --force --fast --update-state --key_buffer_size=512M
--sort_buffer_size=512M --read_buffer_size=4M --write_buffer_size=4M 
/hrd2-2/myisam_data/test_crawler/hc_source.MYI



and it is still running.





Please help me to solve this problem and is there any simple solution
to solve this.



Thanks & best Regards,

Adarsh Sharma






--------------050004000501050609040209--

--------------090202080803050308040303
Content-Type: text/plain;
name="my.cnf"
Content-Transfer-Encoding: base64
Content-Disposition: inline;
filename="my.cnf"

IyBFeGFtcGxlIE15U1FMIGNvbmZpZyBmaWxlIGZvciBtZWRpdW0gc3lzdGVt cy4NCiMNCiMg
VGhpcyBpcyBmb3IgYSBzeXN0ZW0gd2l0aCBsaXR0bGUgbWVtb3J5ICgzMk0g LSA2NE0pIHdo
ZXJlIE15U1FMIHBsYXlzDQojIGFuIGltcG9ydGFudCBwYXJ0LCBvciBzeXN0 ZW1zIHVwIHRv
IDEyOE0gd2hlcmUgTXlTUUwgaXMgdXNlZCB0b2dldGhlciB3aXRoDQojIG90 aGVyIHByb2dy
YW1zIChzdWNoIGFzIGEgd2ViIHNlcnZlcikNCiMNCiMgWW91IGNhbiBjb3B5 IHRoaXMgZmls
ZSB0bw0KIyAvZXRjL215LmNuZiB0byBzZXQgZ2xvYmFsIG9wdGlvbnMsDQoj IG15c3FsLWRh
dGEtZGlyL215LmNuZiB0byBzZXQgc2VydmVyLXNwZWNpZmljIG9wdGlvbnMg KGluIHRoaXMN
CiMgaW5zdGFsbGF0aW9uIHRoaXMgZGlyZWN0b3J5IGlzIC92YXIvbGliL215 c3FsKSBvcg0K
IyB+Ly5teS5jbmYgdG8gc2V0IHVzZXItc3BlY2lmaWMgb3B0aW9ucy4NCiMN CiMgSW4gdGhp
cyBmaWxlLCB5b3UgY2FuIHVzZSBhbGwgbG9uZyBvcHRpb25zIHRoYXQgYSBw cm9ncmFtIHN1
cHBvcnRzLg0KIyBJZiB5b3Ugd2FudCB0byBrbm93IHdoaWNoIG9wdGlvbnMg YSBwcm9ncmFt
IHN1cHBvcnRzLCBydW4gdGhlIHByb2dyYW0NCiMgd2l0aCB0aGUgIi0taGVs cCIgb3B0aW9u
Lg0KDQpbbXlzcWwuc2VydmVyXQ0Kc29ja2V0PS92YXIvbGliL215c3FsL215 c3FsLnNvY2sN
Cg0KDQoNCiMgVGhlIGZvbGxvd2luZyBvcHRpb25zIHdpbGwgYmUgcGFzc2Vk IHRvIGFsbCBN
eVNRTCBjbGllbnRzDQpbY2xpZW50XQ0KI3Bhc3N3b3JkCT0geW91cl9wYXNz d29yZA0KcG9y
dAkJPSAzMzA2DQpzb2NrZXQJPSAvdmFyL2xpYi9teXNxbC9teXNxbC5zb2Nr DQoNCiMgSGVy
ZSBmb2xsb3dzIGVudHJpZXMgZm9yIHNvbWUgc3BlY2lmaWMgcHJvZ3JhbXMN Cg0KIyBUaGUg
TXlTUUwgc2VydmVyDQpbbXlzcWxkXQ0KdXNlcj1teXNxbApwb3J0CQk9IDMz MDYNCnNvY2tl
dAkJPSAvdmFyL2xpYi9teXNxbC9teXNxbC5zb2NrCmxvZz0vdmFyL2xpYi9t eXNxbC9zZXJ2
ZXIubG9nCnBpZC1maWxlPS92YXIvbGliL215c3FsL3NlcnZlci01LnBpZA0K c2tpcC1sb2Nr
aW5nDQprZXlfYnVmZmVyX3NpemU9MjA0OE0KdGFibGVfY2FjaGU9MjA0OApu ZXRfYnVmZmVy
X2xlbmd0aD04CnJlYWRfYnVmZmVyX3NpemU9NTEyTQpyZWFkX3JuZF9idWZm ZXJfc2l6ZT02
NE0KbXlpc2FtX3NvcnRfYnVmZmVyX3NpemU9MjU2TQoNCg0KIyBUaGUgZGVm YXVsdCBjaGFy
YWN0ZXIgc2V0IHRoYXQgd2lsbCBiZSB1c2VkIHdoZW4gYSBuZXcgc2NoZW1h IG9yIHRhYmxl
IGlzDQojIGNyZWF0ZWQgYW5kIG5vIGNoYXJhY3RlciBzZXQgaXMgZGVmaW5l ZA0KZGVmYXVs
dC1jaGFyYWN0ZXItc2V0PWxhdGluMQ0KDQojIFRoZSBkZWZhdWx0IHN0b3Jh Z2UgZW5naW5l
IHRoYXQgd2lsbCBiZSB1c2VkIHdoZW4gIGNyZWF0ZSBuZXcgdGFibGVzIHdo ZW4NCmRlZmF1
bHQtc3RvcmFnZS1lbmdpbmU9bXlpc2FtCgojIGJhY2tfbG9nIGlzIHRoZSBu dW1iZXIgb2Yg
Y29ubmVjdGlvbnMgdGhlIG9wZXJhdGluZyBzeXN0ZW0gY2FuIGtlZXAgaW4N CiMgdGhlIGxp
c3RlbiBxdWV1ZSwgYmVmb3JlIHRoZSBNeVNRTCBjb25uZWN0aW9uIG1hbmFn ZXIgdGhyZWFk
IGhhcw0KIyBwcm9jZXNzZWQgdGhlbS4gSWYgeW91IGhhdmUgYSB2ZXJ5IGhp Z2ggY29ubmVj
dGlvbiByYXRlIGFuZCBleHBlcmllbmNlDQojICJjb25uZWN0aW9uIHJlZnVz ZWQiIGVycm9y
cywgeW91IG1pZ2h0IG5lZWQgdG8gaW5jcmVhc2UgdGhpcyB2YWx1ZS4NCiMg Q2hlY2sgeW91
ciBPUyBkb2N1bWVudGF0aW9uIGZvciB0aGUgbWF4aW11bSB2YWx1ZSBvZiB0 aGlzIHBhcmFt
ZXRlci4NCiMgQXR0ZW1wdGluZyB0byBzZXQgYmFja19sb2cgaGlnaGVyIHRo YW4geW91ciBv
cGVyYXRpbmcgc3lzdGVtIGxpbWl0DQojIHdpbGwgaGF2ZSBubyBlZmZlY3Qu DQpiYWNrX2xv
ZyA9IDUwDQoKIyBUaGUgbWF4aW11bSBhbW91bnQgb2YgY29uY3VycmVudCBz ZXNzaW9ucyB0
aGUgTXlTUUwgc2VydmVyIHdpbGwNCiMgYWxsb3cuIE9uZSBvZiB0aGVzZSBj b25uZWN0aW9u
cyB3aWxsIGJlIHJlc2VydmVkIGZvciBhIHVzZXIgd2l0aA0KIyBTVVBFUiBw cml2aWxlZ2Vz
IHRvIGFsbG93IHRoZSBhZG1pbmlzdHJhdG9yIHRvIGxvZ2luIGV2ZW4gaWYg dGhlDQojIGNv
bm5lY3Rpb24gbGltaXQgaGFzIGJlZW4gcmVhY2hlZC4NCm1heF9jb25uZWN0 aW9ucyA9IDEw
MAoKIyBUaGUgbWF4aW11bSBzaXplIG9mIGEgcXVlcnkgcGFja2V0IHRoZSBz ZXJ2ZXIgY2Fu
IGhhbmRsZSBhcyB3ZWxsIGFzDQojIG1heGltdW0gcXVlcnkgc2l6ZSBzZXJ2 ZXIgY2FuIHBy
b2Nlc3MgKEltcG9ydGFudCB3aGVuIHdvcmtpbmcgd2l0aA0KIyBsYXJnZSBC TE9CcykuICBl
bmxhcmdlZCBkeW5hbWljYWxseSwgZm9yIGVhY2ggY29ubmVjdGlvbi4NCm1h eF9hbGxvd2Vk
X3BhY2tldCA9IDMyTQoKIyBNYXhpbXVtIGFtb3VudCBvZiBlcnJvcnMgYWxs b3dlZCBwZXIg
aG9zdC4gSWYgdGhpcyBsaW1pdCBpcyByZWFjaGVkLA0KIyB0aGUgaG9zdCB3 aWxsIGJlIGJs
b2NrZWQgZnJvbSBjb25uZWN0aW5nIHRvIHRoZSBNeVNRTCBzZXJ2ZXIgdW50 aWwNCiMgIkZM
VVNIIEhPU1RTIiBoYXMgYmVlbiBydW4gb3IgdGhlIHNlcnZlciB3YXMgcmVz dGFydGVkLiBJ
bnZhbGlkDQojIHBhc3N3b3JkcyBhbmQgb3RoZXIgZXJyb3JzIGR1cmluZyB0 aGUgY29ubmVj
dCBwaGFzZSByZXN1bHQgaW4NCiMgaW5jcmVhc2luZyB0aGlzIHZhbHVlLiBT ZWUgdGhlICJB
Ym9ydGVkX2Nvbm5lY3RzIiBzdGF0dXMgdmFyaWFibGUgZm9yDQojIGdsb2Jh bCBjb3VudGVy
Lg0KI21heF9jb25uZWN0X2Vycm9ycyA9IDEwCgojIFRoZSBzaXplIG9mIHRo ZSBjYWNoZSB0
byBob2xkIHRoZSBTUUwgc3RhdGVtZW50cyBmb3IgdGhlIGJpbmFyeSBsb2cN CiMgZHVyaW5n
IGEgdHJhbnNhY3Rpb24uIElmIHlvdSBvZnRlbiB1c2UgYmlnLCBtdWx0aS1z dGF0ZW1lbnQN
CiMgdHJhbnNhY3Rpb25zIHlvdSBjYW4gaW5jcmVhc2UgdGhpcyB2YWx1ZSB0 byBnZXQgbW9y
ZSBwZXJmb3JtYW5jZS4gQWxsDQojIHN0YXRlbWVudHMgZnJvbSB0cmFuc2Fj dGlvbnMgYXJl
IGJ1ZmZlcmVkIGluIHRoZSBiaW5hcnkgbG9nIGNhY2hlIGFuZA0KIyBhcmUg YmVpbmcgd3Jp
dHRlbiB0byB0aGUgYmluYXJ5IGxvZyBhdCBvbmNlIGFmdGVyIHRoZSBDT01N SVQuICBJZiB0
aGUNCiMgdHJhbnNhY3Rpb24gaXMgbGFyZ2VyIHRoYW4gdGhpcyB2YWx1ZSwg dGVtcG9yYXJ5
IGZpbGUgb24gZGlzayBpcyB1c2VkDQojIGluc3RlYWQuICBUaGlzIGJ1ZmZl ciBpcyBhbGxv
Y2F0ZWQgcGVyIGNvbm5lY3Rpb24gb24gZmlyc3QgdXBkYXRlDQojIHN0YXRl bWVudCBpbiB0
cmFuc2FjdGlvbg0KYmlubG9nX2NhY2hlX3NpemUgPSAxNk0NCg0KIyBNYXhp bXVtIGFsbG93
ZWQgc2l6ZSBmb3IgYSBzaW5nbGUgSEVBUCAoaW4gbWVtb3J5KSB0YWJsZS4g VGhpcyBvcHRp
b24NCiMgaXMgYSBwcm90ZWN0aW9uIGFnYWluc3QgdGhlIGFjY2lkZW50aWFs IGNyZWF0aW9u
IG9mIGEgdmVyeSBsYXJnZSBIRUFQDQojIHRhYmxlIHdoaWNoIGNvdWxkIG90 aGVyd2lzZSB1
c2UgdXAgYWxsIG1lbW9yeSByZXNvdXJjZXMuDQptYXhfaGVhcF90YWJsZV9z aXplPTUxMk0K
DQojIFNvcnQgYnVmZmVyIGlzIHVzZWQgdG8gcGVyZm9ybSBzb3J0cyBmb3Ig c29tZSBPUkRF
UiBCWSBhbmQgR1JPVVAgQlkNCiMgcXVlcmllcy4gSWYgc29ydGVkIGRhdGEg ZG9lcyBub3Qg
Zml0IGludG8gdGhlIHNvcnQgYnVmZmVyLCBhIGRpc2sNCiMgYmFzZWQgbWVy Z2Ugc29ydCBp
cyB1c2VkIGluc3RlYWQgLSBTZWUgdGhlICJTb3J0X21lcmdlX3Bhc3NlcyIN CiMgc3RhdHVz
IHZhcmlhYmxlLiBBbGxvY2F0ZWQgcGVyIHRocmVhZCBpZiBzb3J0IGlzIG5l ZWRlZC4NCnNv
cnRfYnVmZmVyX3NpemU9NjRNCgojIFRoaXMgYnVmZmVyIGlzIHVzZWQgZm9y IHRoZSBvcHRp
bWl6YXRpb24gb2YgZnVsbCBKT0lOcyAoSk9JTnMgd2l0aG91dA0KIyBpbmRl eGVzKS4gU3Vj
aCBKT0lOcyBhcmUgdmVyeSBiYWQgZm9yIHBlcmZvcm1hbmNlIGluIG1vc3Qg Y2FzZXMNCiMg
YW55d2F5LCBidXQgc2V0dGluZyB0aGlzIHZhcmlhYmxlIHRvIGEgbGFyZ2Ug dmFsdWUgcmVk
dWNlcyB0aGUNCiMgcGVyZm9ybWFuY2UgaW1wYWN0LiBTZWUgdGhlICJTZWxl Y3RfZnVsbF9q
b2luIiBzdGF0dXMgdmFyaWFibGUgZm9yIGENCiMgY291bnQgb2YgZnVsbCBK T0lOcy4gQWxs
b2NhdGVkIHBlciB0aHJlYWQgaWYgZnVsbCBqb2luIGlzIGZvdW5kDQpqb2lu X2J1ZmZlcl9z
aXplPTMyTQoNCiMgSG93IG1hbnkgdGhyZWFkcyB3ZSBzaG91bGQga2VlcCBp biBhIGNhY2hl
IGZvciByZXVzZS4gV2hlbiBhIGNsaWVudA0KIyBkaXNjb25uZWN0cywgdGhl IGNsaWVudCdz
IHRocmVhZHMgYXJlIHB1dCBpbiB0aGUgY2FjaGUgaWYgdGhlcmUgYXJlbid0 DQojIG1vcmUg
dGhhbiB0aHJlYWRfY2FjaGVfc2l6ZSB0aHJlYWRzIGZyb20gYmVmb3JlLiAg VGhpcyBncmVh
dGx5IHJlZHVjZXMNCiMgdGhlIGFtb3VudCBvZiB0aHJlYWQgY3JlYXRpb25z IG5lZWRlZCBp
ZiB5b3UgaGF2ZSBhIGxvdCBvZiBuZXcNCiMgY29ubmVjdGlvbnMuIChOb3Jt YWxseSB0aGlz
IGRvZXNuJ3QgZ2l2ZSBhIG5vdGFibGUgcGVyZm9ybWFuY2UNCiMgaW1wcm92 ZW1lbnQgaWYg
eW91IGhhdmUgYSBnb29kIHRocmVhZCBpbXBsZW1lbnRhdGlvbi4pDQp0aHJl YWRfY2FjaGVf
c2l6ZT0xNQoKIyBiaW5hcnkgbG9nZ2luZyAtIG5vdCByZXF1aXJlZCBmb3Ig c2xhdmVzLCBi
dXQgcmVjb21tZW5kZWQNCiNsb2ctYmluPW15c3FsLWJpbgoKIyBUaGlzIHBl cm1pdHMgdGhl
IGFwcGxpY2F0aW9uIHRvIGdpdmUgdGhlIHRocmVhZHMgc3lzdGVtIGEgaGlu dCBmb3IgdGhl
DQojIGRlc2lyZWQgbnVtYmVyIG9mIHRocmVhZHMgdGhhdCBzaG91bGQgYmUg cnVuIGF0IHRo
ZSBzYW1lIHRpbWUuICBUaGlzDQojIHZhbHVlIG9ubHkgbWFrZXMgc2Vuc2Ug b24gc3lzdGVt
cyB0aGF0IHN1cHBvcnQgdGhlIHRocmVhZF9jb25jdXJyZW5jeSgpDQojIGZ1 bmN0aW9uIGNh
bGwgKFN1biBTb2xhcmlzLCBmb3IgZXhhbXBsZSkuDQojIFlvdSBzaG91bGQg dHJ5IFtudW1i
ZXIgb2YgQ1BVc10qKDIuLjQpIGZvciB0aHJlYWRfY29uY3VycmVuY3kNCnRo cmVhZF9jb25j
dXJyZW5jeSA9IDEwDQoNCiMgUXVlcnkgY2FjaGUgaXMgdXNlZCB0byBjYWNo ZSBTRUxFQ1Qg
cmVzdWx0cyBhbmQgbGF0ZXIgcmV0dXJuIHRoZW0NCiMgd2l0aG91dCBhY3R1 YWwgZXhlY3V0
aW5nIHRoZSBzYW1lIHF1ZXJ5IG9uY2UgYWdhaW4uIEhhdmluZyB0aGUgcXVl cnkNCiMgY2Fj
aGUgZW5hYmxlZCBtYXkgcmVzdWx0IGluIHNpZ25pZmljYW50IHNwZWVkIGlt cHJvdmVtZW50
cywgaWYgeW91cg0KIyBoYXZlIGEgbG90IG9mIGlkZW50aWNhbCBxdWVyaWVz IGFuZCByYXJl
bHkgY2hhbmdpbmcgdGFibGVzLiBTZWUgdGhlDQojICJRY2FjaGVfbG93bWVt X3BydW5lcyIg
c3RhdHVzIHZhcmlhYmxlIHRvIGNoZWNrIGlmIHRoZSBjdXJyZW50IHZhbHVl DQojIGlzIGhp
Z2ggZW5vdWdoIGZvciB5b3VyIGxvYWQuDQojIE5vdGU6IEluIGNhc2UgeW91 ciB0YWJsZXMg
Y2hhbmdlIHZlcnkgb2Z0ZW4gb3IgaWYgeW91ciBxdWVyaWVzIGFyZQ0KIyB0 ZXh0dWFsbHkg
ZGlmZmVyZW50IGV2ZXJ5IHRpbWUsIHRoZSBxdWVyeSBjYWNoZSBtYXkgcmVz dWx0IGluIGEN
CiMgc2xvd2Rvd24gaW5zdGVhZCBvZiBhIHBlcmZvcm1hbmNlIGltcHJvdmVt ZW50Lg0KcXVl
cnlfY2FjaGVfc2l6ZT0yMDQ4TQoKIyBPbmx5IGNhY2hlIHJlc3VsdCBzZXRz IHRoYXQgYXJl
IHNtYWxsZXIgdGhhbiB0aGlzIGxpbWl0LiBUaGlzIGlzIHRvDQojIHByb3Rl Y3QgdGhlIHF1
ZXJ5IGNhY2hlIG9mIGEgdmVyeSBsYXJnZSByZXN1bHQgc2V0IG92ZXJ3cml0 aW5nIGFsbA0K
IyBvdGhlciBxdWVyeSByZXN1bHRzLg0KcXVlcnlfY2FjaGVfbGltaXQ9MTI4 TQoKIyBUaHJl
YWQgc3RhY2sgc2l6ZSB0byB1c2UuIFRoaXMgYW1vdW50IG9mIG1lbW9yeSBp cyBhbHdheXMg
cmVzZXJ2ZWQgYXQNCiMgY29ubmVjdGlvbiB0aW1lLiBNeVNRTCBpdHNlbGYg dXN1YWxseSBu
ZWVkcyBubyBtb3JlIHRoYW4gNjRLIG9mDQojIG1lbW9yeSwgd2hpbGUgaWYg eW91IHVzZSB5
b3VyIG93biBzdGFjayBodW5ncnkgVURGIGZ1bmN0aW9ucyBvciB5b3VyDQoj IE9TIHJlcXVp
cmVzIG1vcmUgc3RhY2sgZm9yIHNvbWUgb3BlcmF0aW9ucywgeW91IG1pZ2h0 IG5lZWQgdG8g
c2V0IHRoaXMNCiMgdG8gYSBoaWdoZXIgdmFsdWUuDQp0aHJlYWRfc3RhY2s9 MTkyTQoKIyBN
YXhpbXVtIHNpemUgZm9yIGludGVybmFsIChpbi1tZW1vcnkpIHRlbXBvcmFy eSB0YWJsZXMu
IElmIGEgdGFibGUNCiMgZ3Jvd3MgbGFyZ2VyIHRoYW4gdGhpcyB2YWx1ZSwg aXQgaXMgYXV0
b21hdGljYWxseSBjb252ZXJ0ZWQgdG8gZGlzaw0KIyBiYXNlZCB0YWJsZSBU aGlzIGxpbWl0
YXRpb24gaXMgZm9yIGEgc2luZ2xlIHRhYmxlLiBUaGVyZSBjYW4gYmUgbWFu eQ0KIyBvZiB0
aGVtLg0KdG1wX3RhYmxlX3NpemU9NTEyTQoNCiMgTWluaW11bSB3b3JkIGxl bmd0aCB0byBi
ZSBpbmRleGVkIGJ5IHRoZSBmdWxsIHRleHQgc2VhcmNoIGluZGV4Lg0KIyBZ b3UgbWlnaHQg
d2lzaCB0byBkZWNyZWFzZSBpdCBpZiB5b3UgbmVlZCB0byBzZWFyY2ggZm9y IHNob3J0ZXIg
d29yZHMuDQojIE5vdGUgdGhhdCB5b3UgbmVlZCB0byByZWJ1aWxkIHlvdXIg RlVMTFRFWFQg
aW5kZXgsIGFmdGVyIHlvdSBoYXZlDQojIG1vZGlmaWVkIHRoaXMgdmFsdWUu DQojZnRfbWlu
X3dvcmRfbGVuID0gNAoNCiMgRG9uJ3QgbGlzdGVuIG9uIGEgVENQL0lQIHBv cnQgYXQgYWxs
LiBUaGlzIGNhbiBiZSBhIHNlY3VyaXR5IGVuaGFuY2VtZW50LA0KIyBpZiBh bGwgcHJvY2Vz
c2VzIHRoYXQgbmVlZCB0byBjb25uZWN0IHRvIG15c3FsZCBydW4gb24gdGhl IHNhbWUgaG9z
dC4NCiMgQWxsIGludGVyYWN0aW9uIHdpdGggbXlzcWxkIG11c3QgYmUgbWFk ZSB2aWEgVW5p
eCBzb2NrZXRzIG9yIG5hbWVkIHBpcGVzLg0KIyBOb3RlIHRoYXQgdXNpbmcg dGhpcyBvcHRp
b24gd2l0aG91dCBlbmFibGluZyBuYW1lZCBwaXBlcyBvbiBXaW5kb3dzDQoj ICh2aWEgdGhl
ICJlbmFibGUtbmFtZWQtcGlwZSIgb3B0aW9uKSB3aWxsIHJlbmRlciBteXNx bGQgdXNlbGVz
cyENCiMgDQojc2tpcC1uZXR3b3JraW5nDQoNCiMgUmVwbGljYXRpb24gTWFz dGVyIFNlcnZl
ciAoZGVmYXVsdCkNCiMgYmluYXJ5IGxvZ2dpbmcgaXMgcmVxdWlyZWQgZm9y IHJlcGxpY2F0
aW9uDQojbG9nLWJpbj1teXNxbC1iaW4NCg0KIyByZXF1aXJlZCB1bmlxdWUg aWQgYmV0d2Vl
biAxIGFuZCAyXjMyIC0gMQ0KIyBkZWZhdWx0cyB0byAxIGlmIG1hc3Rlci1o b3N0IGlzIG5v
dCBzZXQNCiMgYnV0IHdpbGwgbm90IGZ1bmN0aW9uIGFzIGEgbWFzdGVyIGlm IG9taXR0ZWQN
CnNlcnZlci1pZAk9IDEwDQoNCiMgUmVwbGljYXRpb24gU2xhdmUgKGNvbW1l bnQgb3V0IG1h
c3RlciBzZWN0aW9uIHRvIHVzZSB0aGlzKQ0KIw0KIyBUbyBjb25maWd1cmUg dGhpcyBob3N0
IGFzIGEgcmVwbGljYXRpb24gc2xhdmUsIHlvdSBjYW4gY2hvb3NlIGJldHdl ZW4NCiMgdHdv
IG1ldGhvZHMgOg0KIw0KIyAxKSBVc2UgdGhlIENIQU5HRSBNQVNURVIgVE8g Y29tbWFuZCAo
ZnVsbHkgZGVzY3JpYmVkIGluIG91ciBtYW51YWwpIC0NCiMgICAgdGhlIHN5 bnRheCBpczoN
CiMNCiMgICAgQ0hBTkdFIE1BU1RFUiBUTyBNQVNURVJfSE9TVD08aG9zdD4s IE1BU1RFUl9Q
T1JUPTxwb3J0PiwNCiMgICAgTUFTVEVSX1VTRVI9PHVzZXI+LCBNQVNURVJf UEFTU1dPUkQ9
PHBhc3N3b3JkPiA7DQojDQojICAgIHdoZXJlIHlvdSByZXBsYWNlIDxob3N0 PiwgPHVzZXI+
LCA8cGFzc3dvcmQ+IGJ5IHF1b3RlZCBzdHJpbmdzIGFuZA0KIyAgICA8cG9y dD4gYnkgdGhl
IG1hc3RlcidzIHBvcnQgbnVtYmVyICgzMzA2IGJ5IGRlZmF1bHQpLg0KIw0K IyAgICBFeGFt
cGxlOg0KIw0KIyAgICBDSEFOR0UgTUFTVEVSIFRPIE1BU1RFUl9IT1NUPScx MjUuNTY0LjEy
LjEnLCBNQVNURVJfUE9SVD0zMzA2LA0KIyAgICBNQVNURVJfVVNFUj0nam9l JywgTUFTVEVS
X1BBU1NXT1JEPSdzZWNyZXQnOw0KIw0KIyBPUg0KIw0KIyAyKSBTZXQgdGhl IHZhcmlhYmxl
cyBiZWxvdy4gSG93ZXZlciwgaW4gY2FzZSB5b3UgY2hvb3NlIHRoaXMgbWV0 aG9kLCB0aGVu
DQojICAgIHN0YXJ0IHJlcGxpY2F0aW9uIGZvciB0aGUgZmlyc3QgdGltZSAo ZXZlbiB1bnN1
Y2Nlc3NmdWxseSwgZm9yIGV4YW1wbGUNCiMgICAgaWYgeW91IG1pc3R5cGVk IHRoZSBwYXNz
d29yZCBpbiBtYXN0ZXItcGFzc3dvcmQgYW5kIHRoZSBzbGF2ZSBmYWlscyB0 bw0KIyAgICBj
b25uZWN0KSwgdGhlIHNsYXZlIHdpbGwgY3JlYXRlIGEgbWFzdGVyLmluZm8g ZmlsZSwgYW5k
IGFueSBsYXRlcg0KIyAgICBjaGFuZ2UgaW4gdGhpcyBmaWxlIHRvIHRoZSB2 YXJpYWJsZXMn
IHZhbHVlcyBiZWxvdyB3aWxsIGJlIGlnbm9yZWQgYW5kDQojICAgIG92ZXJy aWRkZW4gYnkg
dGhlIGNvbnRlbnQgb2YgdGhlIG1hc3Rlci5pbmZvIGZpbGUsIHVubGVzcyB5 b3Ugc2h1dGRv
d24NCiMgICAgdGhlIHNsYXZlIHNlcnZlciwgZGVsZXRlIG1hc3Rlci5pbmZv IGFuZCByZXN0
YXJ0IHRoZSBzbGF2ZXIgc2VydmVyLg0KIyAgICBGb3IgdGhhdCByZWFzb24s IHlvdSBtYXkg
d2FudCB0byBsZWF2ZSB0aGUgbGluZXMgYmVsb3cgdW50b3VjaGVkDQojICAg IChjb21tZW50
ZWQpIGFuZCBpbnN0ZWFkIHVzZSBDSEFOR0UgTUFTVEVSIFRPIChzZWUgYWJv dmUpDQojDQoj
IHJlcXVpcmVkIHVuaXF1ZSBpZCBiZXR3ZWVuIDIgYW5kIDJeMzIgLSAxDQoj IChhbmQgZGlm
ZmVyZW50IGZyb20gdGhlIG1hc3RlcikNCiMgZGVmYXVsdHMgdG8gMiBpZiBt YXN0ZXItaG9z
dCBpcyBzZXQNCiMgYnV0IHdpbGwgbm90IGZ1bmN0aW9uIGFzIGEgc2xhdmUg aWYgb21pdHRl
ZA0KI3NlcnZlci1pZCAgICAgICA9IDINCiMNCiMgVGhlIHJlcGxpY2F0aW9u IG1hc3RlciBm
b3IgdGhpcyBzbGF2ZSAtIHJlcXVpcmVkDQojbWFzdGVyLWhvc3QgICAgID0g ICA8aG9zdG5h
bWU+DQojDQojIFRoZSB1c2VybmFtZSB0aGUgc2xhdmUgd2lsbCB1c2UgZm9y IGF1dGhlbnRp
Y2F0aW9uIHdoZW4gY29ubmVjdGluZw0KIyB0byB0aGUgbWFzdGVyIC0gcmVx dWlyZWQNCiNt
YXN0ZXItdXNlciAgICAgPSAgIDx1c2VybmFtZT4NCiMNCiMgVGhlIHBhc3N3 b3JkIHRoZSBz
bGF2ZSB3aWxsIGF1dGhlbnRpY2F0ZSB3aXRoIHdoZW4gY29ubmVjdGluZyB0 bw0KIyB0aGUg
bWFzdGVyIC0gcmVxdWlyZWQNCiNtYXN0ZXItcGFzc3dvcmQgPSAgIDxwYXNz d29yZD4NCiMN
CiMgVGhlIHBvcnQgdGhlIG1hc3RlciBpcyBsaXN0ZW5pbmcgb24uDQojIG9w dGlvbmFsIC0g
ZGVmYXVsdHMgdG8gMzMwNg0KI21hc3Rlci1wb3J0ICAgICA9ICA8cG9ydD4N CiMNCiMgYmlu
YXJ5IGxvZ2dpbmcgLSBub3QgcmVxdWlyZWQgZm9yIHNsYXZlcywgYnV0IHJl Y29tbWVuZGVk
DQojbG9nLWJpbj1teXNxbC1iaW4NCg0KIyBQb2ludCB0aGUgZm9sbG93aW5n IHBhdGhzIHRv
IGRpZmZlcmVudCBkZWRpY2F0ZWQgZGlza3MNCnRtcGRpcgkJPSAvdG1wLwkJ DQojbG9nLXVw
ZGF0ZSAJPSAvcGF0aC10by1kZWRpY2F0ZWQtZGlyZWN0b3J5L2hvc3RuYW1l DQoNCiMgVW5j
b21tZW50IHRoZSBmb2xsb3dpbmcgaWYgeW91IGFyZSB1c2luZyBCREIgdGFi bGVzDQojYmRi
X2NhY2hlX3NpemUgPSA0TQ0KI2JkYl9tYXhfbG9jayA9IDEwMDAwDQojIFVu Y29tbWVudCB0
aGUgZm9sbG93aW5nIGlmIHlvdSBhcmUgdXNpbmcgSW5ub0RCIHRhYmxlcw0K aW5ub2RiX2Rh
dGFfaG9tZV9kaXIgPSANCmlubm9kYl9kYXRhX2ZpbGVfcGF0aCA9IC92YXIv bGliL215c3Fs
L2liZGF0YTE6MTBNOy9ocmQyLTEvbXlzcWxfZGF0YS9pYmRhdGEyOjIwME07 L2hyZDItMi9t
eXNxbF9kYXRhL2liZGF0YTM6MjAwTTphdXRvZXh0ZW5kDQppbm5vZGJfbG9n X2dyb3VwX2hv
bWVfZGlyID0gL3Zhci9saWIvbXlzcWwvDQppbm5vZGJfbG9nX2FyY2hfZGly ID0gL3Zhci9s
aWIvbXlzcWwvDQojIFlvdSBjYW4gc2V0IC4uX2J1ZmZlcl9wb29sX3NpemUg dXAgdG8gNTAg
LSA4MCAlDQojIG9mIFJBTSBidXQgYmV3YXJlIG9mIHNldHRpbmcgbWVtb3J5 IHVzYWdlIHRv
byBoaWdoDQppbm5vZGJfYnVmZmVyX3Bvb2xfc2l6ZT0zNTAwTQppbm5vZGJf YWRkaXRpb25h
bF9tZW1fcG9vbF9zaXplPTUxMk0KIyBTZXQgLi5fbG9nX2ZpbGVfc2l6ZSB0 byAyNSAlIG9m
IGJ1ZmZlciBwb29sIHNpemUNCmlubm9kYl9sb2dfZmlsZV9zaXplPTEwME0K aW5ub2RiX2xv
Z19idWZmZXJfc2l6ZT0xNgojaW5ub2RiX2ZsdXNoX2xvZ19hdF90cnhfY29t bWl0ID0gMQ0K
aW5ub2RiX2xvY2tfd2FpdF90aW1lb3V0ID0gMTIwCiMgVG90YWwgbnVtYmVy IG9mIGZpbGVz
IGluIHRoZSBsb2cgZ3JvdXAuIEEgdmFsdWUgb2YgMi0zIGlzIHVzdWFsbHkg Z29vZA0KIyBl
bm91Z2guDQppbm5vZGJfbG9nX2ZpbGVzX2luX2dyb3VwID0gMwoKIyBOdW1i ZXIgb2YgSU8g
dGhyZWFkcyB0byB1c2UgZm9yIGFzeW5jIElPIG9wZXJhdGlvbnMuIFRoaXMg dmFsdWUgaXMN
CiMgaGFyZGNvZGVkIHRvIDQgb24gVW5peCwgYnV0IG9uIFdpbmRvd3MgZGlz ayBJL08gbWF5
IGJlbmVmaXQgZnJvbSBhDQojIGxhcmdlciBudW1iZXIuDQppbm5vZGJfZmls ZV9pb190aHJl
YWRzPTEwCg0KIyBJZiB5b3UgcnVuIGludG8gSW5ub0RCIHRhYmxlc3BhY2Ug Y29ycnVwdGlv
biwgc2V0dGluZyB0aGlzIHRvIGEgbm9uemVybw0KIyB2YWx1ZSB3aWxsIGxp a2VseSBoZWxw
IHlvdSB0byBkdW1wIHlvdXIgdGFibGVzLiBTdGFydCBmcm9tIHZhbHVlIDEg YW5kDQojIGlu
Y3JlYXNlIGl0IHVudGlsIHlvdSdyZSBhYmxlIHRvIGR1bXAgdGhlIHRhYmxl IHN1Y2Nlc3Nm
dWxseS4NCiNpbm5vZGJfZm9yY2VfcmVjb3Zlcnk9MQ0KDQojIE51bWJlciBv ZiB0aHJlYWRz
IGFsbG93ZWQgaW5zaWRlIHRoZSBJbm5vREIga2VybmVsLiBUaGUgb3B0aW1h bCB2YWx1ZQ0K
IyBkZXBlbmRzIGhpZ2hseSBvbiB0aGUgYXBwbGljYXRpb24sIGhhcmR3YXJl IGFzIHdlbGwg
YXMgdGhlIE9TDQojIHNjaGVkdWxlciBwcm9wZXJ0aWVzLiBBIHRvbyBoaWdo IHZhbHVlIG1h
eSBsZWFkIHRvIHRocmVhZCB0aHJhc2hpbmcuDQppbm5vZGJfdGhyZWFkX2Nv bmN1cnJlbmN5
ID0gMTYNCgojIElmIHlvdSdyZSB1c2luZyByZXBsaWNhdGlvbiB3aXRoIGNo YWluZWQgc2xh
dmVzIChBLT5CLT5DKSwgeW91IG5lZWQgdG8NCiMgZW5hYmxlIHRoaXMgb3B0 aW9uIG9uIHNl
cnZlciBCLiBJdCBlbmFibGVzIGxvZ2dpbmcgb2YgdXBkYXRlcyBkb25lIGJ5 DQojIHRoZSBz
bGF2ZSB0aHJlYWQgaW50byB0aGUgc2xhdmUncyBiaW5hcnkgbG9nLg0KI2xv Z19zbGF2ZV91
cGRhdGVzDQoNCiMgRW5hYmxlIHRoZSBmdWxsIHF1ZXJ5IGxvZy4gRXZlcnkg cXVlcnkgKGV2
ZW4gb25lcyB3aXRoIGluY29ycmVjdA0KIyBzeW50YXgpIHRoYXQgdGhlIHNl cnZlciByZWNl
aXZlcyB3aWxsIGJlIGxvZ2dlZC4gVGhpcyBpcyB1c2VmdWwgZm9yDQojIGRl YnVnZ2luZywg
aXQgaXMgdXN1YWxseSBkaXNhYmxlZCBpbiBwcm9kdWN0aW9uIHVzZS4NCiNs b2cNCg0KIyBQ
cmludCB3YXJuaW5ncyB0byB0aGUgZXJyb3IgbG9nIGZpbGUuICBJZiB5b3Ug aGF2ZSBhbnkg
cHJvYmxlbSB3aXRoDQojIE15U1FMIHlvdSBzaG91bGQgZW5hYmxlIGxvZ2dp bmcgb2Ygd2Fy
bmluZ3MgYW5kIGV4YW1pbmUgdGhlIGVycm9yIGxvZw0KIyBmb3IgcG9zc2li bGUgZXhwbGFu
YXRpb25zLiANCiNsb2dfd2FybmluZ3MNCg0KIyBMb2cgc2xvdyBxdWVyaWVz LiBTbG93IHF1
ZXJpZXMgYXJlIHF1ZXJpZXMgd2hpY2ggdGFrZSBtb3JlIHRoYW4gdGhlDQoj IGFtb3VudCBv
ZiB0aW1lIGRlZmluZWQgaW4gImxvbmdfcXVlcnlfdGltZSIgb3Igd2hpY2gg ZG8gbm90IHVz
ZQ0KIyBpbmRleGVzIHdlbGwsIGlmIGxvZ19sb25nX2Zvcm1hdCBpcyBlbmFi bGVkLiBJdCBp
cyBub3JtYWxseSBnb29kIGlkZWENCiMgdG8gaGF2ZSB0aGlzIHR1cm5lZCBv biBpZiB5b3Ug
ZnJlcXVlbnRseSBhZGQgbmV3IHF1ZXJpZXMgdG8gdGhlDQojIHN5c3RlbS4N CmxvZ19zbG93
X3F1ZXJpZXM9L3Zhci9saWIvbXlzcWwvc2VydmVyLTUtc2xvdy5sb2cNCg0K IyBBbGwgcXVl
cmllcyB0YWtpbmcgbW9yZSB0aGFuIHRoaXMgYW1vdW50IG9mIHRpbWUgKGlu IHNlY29uZHMp
IHdpbGwgYmUNCiMgdHJhdGVkIGFzIHNsb3cuIERvIG5vdCB1c2UgIjEiIGFz IGEgdmFsdWUg
aGVyZSwgYXMgdGhpcyB3aWxsIHJlc3VsdCBpbg0KIyBldmVuIHZlcnkgZmFz dCBxdWVyaWVz
IGJlaW5nIGxvZ2dlZCBmcm9tIHRpbWUgdG8gdGltZSAoYXMgTXlTUUwNCiMg Y3VycmVudGx5
IG1lYXN1cmVzIHRpbWUgd2l0aCBzZWNvbmQgYWNjdXJhY3kgb25seSkuDQps b25nX3F1ZXJ5
X3RpbWU9MwoNCiMgTG9nIG1vcmUgaW5mb3JtYXRpb24gaW4gdGhlIHNsb3cg cXVlcnkgbG9n
LiBOb3JtYWxseSBpdCBpcyBnb29kIHRvDQojIGhhdmUgdGhpcyB0dXJuZWQg b24uIFRoaXMg
d2lsbCBlbmFibGUgbG9nZ2luZyBvZiBxdWVyaWVzIHRoYXQgYXJlIG5vdA0K IyB1c2luZyBp
bmRleGVzIGluIGFkZGl0aW9uIHRvIGxvbmcgcnVubmluZyBxdWVyaWVzLg0K bG9nX2xvbmdf
Zm9ybWF0DQoNCiMgVGhlIGRpcmVjdG9yeSB1c2VkIGJ5IE15U1FMIGZvciBz dG9yaW5nIHRl
bXBvcmFyeSBmaWxlcy4gRm9yIGV4YW1wbGUsDQojIGl0IGlzIHVzZWQgdG8g cGVyZm9ybSBk
aXNrIGJhc2VkIGxhcmdlIHNvcnRzLCBhcyB3ZWxsIGFzIGZvciBpbnRlcm5h bA0KIyBhbmQg
ZXhwbGljaXQgdGVtcG9yYXJ5IHRhYmxlcy4gSXQgbWlnaHQgYmUgZ29vZCB0 byBwdXQgaXQg
b24gYQ0KIyBzd2FwZnMvdG1wZnMgZmlsZXN5c3RlbSwgaWYgeW91IGRvIG5v dCBjcmVhdGUg
dmVyeSBsYXJnZSB0ZW1wb3JhcnkNCiMgZmlsZXMuIEFsdGVybmF0aXZlbHkg eW91IGNhbiBw
dXQgaXQgb24gZGVkaWNhdGVkIGRpc2suIFlvdSBjYW4NCiMgc3BlY2lmeSBt dWx0aXBsZSBw
YXRocyBoZXJlIGJ5IHNlcGFyYXRpbmcgdGhlbSBieSAiOyIgLSB0aGV5IHdp bGwgdGhlbg0K
IyBiZSB1c2VkIGluIGEgcm91bmQtcm9iaW4gZmFzaGlvbi4NCiN0bXBkaXIg PSAvdG1wDQoN
CgoKCgoKCiNQYXRoIHRvIHRoZSBkYXRhYmFzZSByb290CmRhdGFkaXI9L2hy ZDItMi9teWlz
YW1fZGF0YQoKCgoKW215c3FsZHVtcF0NCnF1aWNrDQptYXhfYWxsb3dlZF9w YWNrZXQgPSAz
Mk0NCg0KW215c3FsXQ0Kbm8tYXV0by1yZWhhc2gNCiMgUmVtb3ZlIHRoZSBu ZXh0IGNvbW1l
bnQgY2hhcmFjdGVyIGlmIHlvdSBhcmUgbm90IGZhbWlsaWFyIHdpdGggU1FM DQojc2FmZS11
cGRhdGVzDQpzb2NrZXQ9L3Zhci9saWIvbXlzcWwvbXlzcWwuc29jaw0KZGVm YXVsdC1jaGFy
YWN0ZXItc2V0PWxhdGluMQ0KDQpbaXNhbWNoa10NCmtleV9idWZmZXIgPSAy ME0NCnNvcnRf
YnVmZmVyX3NpemUgPSAyME0NCnJlYWRfYnVmZmVyID0gMk0NCndyaXRlX2J1 ZmZlciA9IDJN
DQoNCltteWlzYW1jaGtdDQprZXlfYnVmZmVyID0gMjBNDQpzb3J0X2J1ZmZl cl9zaXplID0g
MjBNDQpyZWFkX2J1ZmZlciA9IDJNDQp3cml0ZV9idWZmZXIgPSAyTQ0KDQpb bXlzcWxob3Rj
b3B5XQ0KaW50ZXJhY3RpdmUtdGltZW91dA0KDQpbbXlzcWxhZG1pbl0NCnNv Y2tldD0vdmFy
L2xpYi9teXNxbC9teXNxbC5zb2NrDQoNCg==

--------------090202080803050308040303
Content-Type: text/plain; charset=us-ascii


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
--------------090202080803050308040303--