mysql> show processlist; +-----+------+------+------+---------+------+--------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+------+------+------+---------+------+--------+------------------------------------------------------------------------------------------------------+ | 1 | root | | test | Query | 0 | NULL | show processlist | | 45 | root | | test | Sleep | 10 | | NULL | | 46 | root | | test | Query | 876 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('LYOEKkqSGwAKaHmv9ogKFRUCvmqadYYUEgmyq3KL6qtwSUyjmKo4mKKYK | | 47 | root | | test | Query | 887 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('yemmgQahwrujHOKEFs2cw606KwswqSa2qIWfEzZWW6lCLSCS2uyqsW7Sk | | 48 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('',1,15), `col1` = SUBSTR('i6g',1,105), `col2` = SUB | | 49 | root | | test | Query | 876 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('GbieQ26CfN4B6sCCMamY6WHMjnAliMOI i622VDwMsVfC4Gq6E yYlYiP | | 50 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('wMZie6m691ESaxE 0kC2iGqeSm8uaxOG0MAsPSia0 aSCOk606W | | 51 | root | | test | Query | 887 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('2Ze6FcoK6IyvcXSyAkyP6sK66aYiW aeaUK0W6fO45Geo6 wHQOnGGMo6 | | 52 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('WG4jIaoI5Ge7aPOtDSjT6YRMKcEKO5icmQ8K1cKc swva60lqEy | | 53 | root | | test | Query | 876 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('A2eOGB2w NS uyfFYb6MOQLi3ra gH6aiIu6a2Uu6aSYrgqmIc',1,15 | | 54 | root | | test | Query | 887 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('IjKykmwsiiEdwSxHaylzxyQ2qmduqi oESSKICYLYuqCoOOw1obKe96ky | | 55 | root | | test | Query | 888 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('',1,15), `col1` = SUBSTR('qG04uGWdHKsrCz1NquaIW0NWI | | 56 | root | | test | Query | 888 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('HiSGU0KYoe6iIKgUCqYW6SUgIiFkHJ0YI7CiRyjKiGEcuHK0KjK | | 57 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('GGh74GYaR1K v7YTGK2uwwih6VKc6rEaQCiXt AzwY22Q6aKreA | | 58 | root | | test | Query | 876 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('avFKC6yS y',1,15), `col1` = SUBSTR('eiwyZXFwp8rte0',1,105 | | 59 | root | | test | Query | 878 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('yuW0SKUSIGrW8o90',1,15), `col1` = SUBSTR('lqy4A1YaD | | 60 | root | | test | Query | 876 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('b8u6ikAteZo677kUYKYPaOynjlgMMlgytq9EsSVS2alqYJk0acv | | 61 | root | | test | Query | 876 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('oB2olsq05UKLcGqsaiW9iZDzAWmEUcqeEP2euMwzaOa8 scCa7Syk21su | | 62 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('KTEsNea6EqwOUDYSoawWmAnW56eZaymQzKbdV3Mc',1,15), `c | | 63 | root | | test | Query | 891 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('1aaHqL6aOGgOeazqSOnsaAX7lDG2qCsO0SrJ48ta2CCKaE8a0mA | | 64 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('Syoy4samRZIU0tawK6QjB oYqueuC7sSKyki6PZjcaO05m0C68a | | 65 | root | | test | Query | 886 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('rrwluiayPM IiIQa6Sa1gu6aCSr6mm926eyg z48aQX1NSOy6vb | | 66 | root | | test | Query | 886 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('SQa86a7QssWwaaaaucoDGks7ICiihX4aiqnlqP9uauKWXCaUKMp6JW6or | | 67 | root | | test | Query | 798 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('wHVKHAee k2ym JgROaiL62VSdXsqaguYBS6CG8nsCUw2Wra61CqmPlnS | | 68 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('ZWIaOvug 6aqMaCy8EgGAISQ LsCO6QsmepGta3eOIt08oaFoJS | | 69 | root | | test | Query | 887 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('p2qKWeEmRGKx',1,15), `col1` = SUBSTR('rlGYHuBpCUxBy0CNK5 | | 70 | root | | test | Query | 876 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR(' M7fc2Pa4ciHjyWA4WeIDaaPb4A64AlouuhraSxAw6GaOdmmqam | | 71 | root | | test | Query | 884 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('peVaoqxUq7eG6mo6wIqnUIs1KaxKMKyaO2A4OK39iYW4uUiYafP | | 72 | root | | test | Query | 887 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('4UbCeq zS1GI62Pc c16Ga3AmouSatiqzwXeWUuaS1OY0oph4KaCEz8 A | | 73 | root | | test | Query | 798 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('aOWuQOC7qC92OO KOQBngMOGlKWkhC',1,15), `col1` = SUBSTR('q | | 74 | root | | test | Query | 889 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('yRkaA5MpsyazKaCydwYGD geEG6a6i6jiZ5Em6NO WNnDYwVca2hyjiK4 | | 75 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('ECz2yIku9G226Gnq AtcOGOq',1,15), `col1` = SUBSTR('p | | 76 | root | | test | Query | 876 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('UtI',1,15), `col1` = SUBSTR('u6 mOWcpxpqKSNh uCUqqI | | 77 | root | | test | Query | 876 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('kYSN0EAOy26e2gxSie2CQXsOmDh7',1,15), `col1` = SUBST | | 78 | root | | test | Query | 817 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('eWTXOeYqZRiE7gnwSj6ODz45XDMq 9a46My06 UiybeXpXjes8G | | 79 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('1CKaaJK2svqk9V6ugs',1,15), `col1` = SUBSTR('y oamIl | | 80 | root | | test | Query | 887 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('2sewKByqoqnCCfuVOqF meHahaOpWepbm62WoeqKweCKVO26cL9za8',1 | | 81 | root | | test | Query | 876 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('k6Um95AWIECvatpQJiOWuZAWMb456SWw8uQ5EqA0J t4uWh7yCE | | 82 | root | | test | Query | 876 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('amSAIKMk8KnGjFKFGqa6auRpOWF m2GhiICouraI1SUifc0fSzk | | 83 | root | | test | Query | 876 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('B3zDMQu7a2PseIYSgKAKSX6m2BRdSa8SuqHSaU4aaeU OSG u6z | | 84 | root | | test | Query | 889 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('KSQjCaNazemn65hqeIrzi6e2eam4CwCiWOuGah9nsyXq9q66 qj | | 85 | root | | test | Query | 888 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('G k6u5qXa',1,15), `col1` = SUBSTR('uWUqqKjkXy1TlNes | | 86 | root | | test | Query | 834 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('KIPKGchGuJ N6WUCZOw6avWq6ULegOm2S6uQ6gJOCUi10 YYqJ | | 87 | root | | test | Query | 888 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('gUyJugKlIsmq6zMKxQ6YCxq4QadWCxT3Ni0CdCpx6s',1,15), | | 88 | root | | test | Query | 877 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('g2dLlBuyqJ2o1Gar Si1OgR7eqL6OXCU2mHu2KqEHs6KVCSSqO2 | | 89 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('agpDO0D0kyaaaIcayHMGcBkFoyI0pMsKSzjSyWG2umUL06geSaN | | 90 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('FEz1PaTGyKpZQIe7eI07j6Aqav2K4aj6wiazGotgvauqiiUqPlt | | 91 | root | | test | Query | 853 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('ywQBOZpcar2H6tkmkwK8S9JLJvCaI26fMYaaqKk4qP3My3q4sGu | | 92 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('aSo6Cgb9qyiauWqFgpdaqyi4aK SSUQ cpOuAiqte6c8iB5wTRB | | 93 | root | | test | Query | 837 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('yMuOi2y',1,15), `col1` = SUBSTR('x4aWm9RA3Z cS tTak | | 94 | root | | test | Query | 878 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('YqhuwAq8Do oaW Wa3hugowPqaVUUS6YPeEb ekH8Oaa924dqwt | | 95 | root | | test | Query | 848 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('ivIfEXaW2yGioXk1v2QWm Pi1EeKcyPrKryOn66OfW6SeiE2L8E | | 96 | root | | test | Query | 878 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('kHd0xxQKVXVZDuaCW6FaufWhG6VCwaD6qGlKakyU766M DWrqh6KSWiKe | | 97 | root | | test | Query | 888 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('WMCUm4zCjkeqk2 aIovdyYeCOLizaCcEEcc4SKQbC8MW3WCIqeKdEMzK6 | | 98 | root | | test | Query | 886 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('wEiCC aGp62mWzHiYI26ec9e1a32Gp2oNA6QoiuvLHcCFcAgoWm | | 99 | root | | test | Query | 867 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('mQyIfda228CqGKpKK2aCyzaetUiWUVqMmiS2CrwK yqbc2Q7yiC | | 100 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('uT92U3vEJmGSetdm84mK',1,15), `col1` = SUBSTR(' qKqC | | 101 | root | | test | Query | 846 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('iKXCuWSDYWYUdt QMdbbCK6KywG2r1NXxKia6Sh0QaUqlb 5KyH | | 102 | root | | test | Query | 876 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('1ugnoyS6a4wygCSiKWAKDMsaayOC6jX oj7WcaaiCd3DGTxoR7y | | 103 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('nKGHyR64W wwy0Ya0a2Qgc5IHagSahZbED2s6ZMe7o1Sm6GCaa2 | | 104 | root | | test | Query | 812 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('MZaayqUq 46dwygOg6GoaCi2TCCaRSmqiRUKe60mvZGCe6Ey6ys | | 105 | root | | test | Query | 876 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('MmRXumakGk1SWaaa857WKaAaa4zniaKYWSZy2v6',1,15), `col1` = | | 106 | root | | test | Query | 886 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('kyK 1hAlYkSCwaIi2 8aIa6oOsqfvCAOjWiw',1,15), `col1` | | 107 | root | | test | Query | 785 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('EaKEhrmhKX03BiCaGCwQaufYcmyZiwQNfqao ayMCYiT6cyaW wzJemgG | | 108 | root | | test | Query | 845 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('O2ms fYYmaa T aBQaICqEoSRsuM 4iiOHuiaygG yk6kLbraZ8 | | 109 | root | | test | Query | 842 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('9Y 6IUCVVCGExSOk0CGTDcCyOOfCCp26WyG6ToaaK2Osa2q98tq | | 110 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('KYegB2Y dK36Ipk0i3aDIA Sfh0OkPK8a29Odu0ggigGFQZFQ8o | | 111 | root | | test | Query | 889 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('lgEQia6Yn6qG8lSiCy6iMCuHc7hiuHIa4QyaCGieiiss6Y7a2aB | | 112 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('aGScKO5W OfuUWy4WYYWChp56KzSy9zBeWaMcpaau6jFWKSkC42 | | 113 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('AA20ss63KRCygKa3oym6aNom6aeQmA9OzEQauaGia',1,15), ` | | 114 | root | | test | Query | 837 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('CXsCMGEf6yttJtihEBaytK0amPwqay5GQhiq3BKA3 w QC6yi28 | | 115 | root | | test | Query | 876 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('i314EtkCpGwLatUaouscG4a79iCdM0wAGQjn6yQQ9SQq7RQB0Sq | | 116 | root | | test | Query | 801 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('faqq8O6Rq0ai6zj kqZGaLdEtvdWaEMyiram u0wi9GkCma1NSe | | 117 | root | | test | Query | 886 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('q68lldWSzaboeB6MJ82aUqA64j6a6zUX6i3u06Y6ynSwuGJ6jCd | | 118 | root | | test | Query | 876 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('aqE6co9aqRUWkoqqm69KiQkai6olcuJ3Yy1D6a0aO6vMEaoEZu8Oiay5a | | 119 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('pLy2maFh0SrNnqHx2gpCqoqOC6K66wqj0aqCfaQ',1,15), `co | | 120 | root | | test | Query | 877 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('DYSdmG0aRa6IeVwcyoVGq3P 0yuLp4KUKScQB8mYqQdyyiK6GAr | | 121 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('M56FmERAJaTZGeCHy06Sqmoye0qS0c4aCZAvsumQCoXQ vYycrh | | 122 | root | | test | Query | 787 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('YC6G0D9Dwa6ScazIQub4cXWtiaLTn6YSSCygouX6SqCG6cFW4P3 | | 123 | root | | test | Query | 798 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('z H6pekD mIa3YRADeqJyiy6Vuq aXFeGiES4Ra06YiK SqidxK | | 124 | root | | test | Query | 863 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('W7 AQ46fw66io1ItqrOkSgKMu6qean XtaE6KfxeJKHEvnRi0IV | | 125 | root | | test | Query | 876 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('CmOq9CUbLzMYiKsps66eecI 15IOC2gHosVxTQmmHS0u64K4r5a | | 126 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('Znnk CsYnIiWOUHE7ijGsswX3eqqSOGOa86uKq5CeA90IqVpZqe | | 127 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('amaa1aA0G9qQeyeMvCFIGTy2A8CG74wlzGCc0LiQJeoxewmyqye | | 128 | root | | test | Query | 886 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('a4ArP1qn6mRKyHoUKaYw6QckR2maaSLuv50X4Ry2sDCffgaQxR6 | | 129 | root | | test | Query | 864 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('GT96kEeOCyQ7L5MCx6WyiyVaTsWSEMyaeAm',1,15), `col1` | | 130 | root | | test | Query | 888 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('AqVvc6N6dOmDsKmK7UySXUWIy10a6Ue7aaBcyJMa0kPiKsIOSWx4oqyqQ | | 131 | root | | test | Query | 876 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('SdgSKYKJU057Sdimg K i QtGKa1zaWuiyRzyMCjfok2BYKaM9R | | 132 | root | | test | Query | 886 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('oTs6pAxks KpNBq5UKJH yC0uNIqECXGtkiK67GWq6u2vszjgiUJOzCFu | | 133 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('AEub0ii yf606KqWO2u96yW2ayuoDg84ahYq',1,15), `col1` | | 134 | root | | test | Query | 830 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('Sb9I48KqW6aekmMui3Sp6SIwGz5ikc7quoGM9e0SuD ca6SDlka | | 135 | root | | test | Query | 857 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('taywYanadqm59ia0 XGFsq2qam8iXeQSuZYUC9wqUC859pqjl0SHeaqEq | | 136 | root | | test | Query | 877 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('VGEU6uSqq GYQOs uqKy JcaFyUSUAAdTUq0a8LSIWtw40ajR4F | | 137 | root | | test | Query | 876 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('nauBGlF2A8Gy qmaCk 4eahrbeX7EI0DawGqbKKIyFK6ycCkU4O | | 138 | root | | test | Query | 798 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('E7qOwBCu1yKS5UqSaK0mDK12KBSmeugqg0xO2sTWqa7xy76a0iWiHrgY6 | | 139 | root | | test | Query | 878 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('6j0WOkizSwaYKOjaQugA FCgGAp2eMWRROCqqOtSM8aaa0acrUK | | 140 | root | | test | Query | 817 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('CkOkWigPAPA0CzGS6syMNk6KqElyWEaWKyyd2IhVYm6aW3zGAH6 | | 141 | root | | test | Query | 886 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('aYfvKeaQQ8gO4a5WN5qs9YWmz WU03X8Zauz4Lr22lO iiaiku8 | | 142 | root | | test | Query | 870 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('waCAUZoEHS644abikqfFL2OKzMcnHm2OSigeqCyemy22EKtIjKJ | | 143 | root | | test | Query | 878 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('qYpCq eXivV6AEqtSahFCuGesciK2lREje Gai9SoM2inSmM7K | | 144 | root | | test | Query | 859 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('qq2eEkqqusSvqL 3 FEClEy ',1,15), `col1` = SUBSTR('v | | 145 | root | | test | Query | 876 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('qeSvd6smSrOFQjEu6cGyM2wC aS Egqg0cqTF4w82OiaO4CSoGy8MO iu | | 146 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('8jIK26sx2',1,15), `col1` = SUBSTR('6sAGw yeqScKjwKG | | 147 | root | | test | Query | 876 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('aTyVe0MWYagHmyGuJCnbCy2nNuCsa8uO0tCiy6uyUXG4e6NHUaY | | 148 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('kEOydimCOva283R8UkKGDoZbbaamaPzkgDICKTIW7V3Kqe4G1w1 | | 149 | root | | test | Query | 886 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('uaaCbSCq1CJa OwGoSsCaiARdShiWcatOZAs6rAKcaSpY o0Wy | | 150 | root | | test | Query | 868 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('PNFaJ WlaaI6KmpqC',1,15), `col1` = SUBSTR('S0O6aBXj | | 151 | root | | test | Query | 886 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('6a8obZCKuKqelysaPiZWFo20oHKyK6OKuCRjTcayau8 IxAaDls | | 152 | root | | test | Query | 795 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('1cDuT628j0aiG74UC3QYTEkfCaAWmsaQZZNWfiwaOW60xqO6qI6 | | 153 | root | | test | Query | 889 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('uGCgKq esa5sKZ65pKwKceHun6Hq6qZSquMQTk gySoie0XGAM6 | | 154 | root | | test | Query | 876 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('Y8qDYFiHaB6FaawEqatuK qKq 2lYOACG96YKu26tNBGaJviaig | | 155 | root | | test | Query | 876 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('KfSCnqqyYaQ6TC6vGEKaA4yUUwwuyvyua',1,15), `col1` = | | 156 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('6v G6SjsE424C9iCXiS2iaKKeCyLJQ0YYagQK iKGi2va6louad | | 157 | root | | test | Query | 787 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('YnU 8',1,15), `col1` = SUBSTR('0aCqYcNSy0MqhKyWBWy | | 158 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('rSOQwEiOovKtqEuX00N1WMPc1QfmigzagmTGsqpsFrIMbW AQE' | | 159 | root | | test | Query | 878 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('R0y zDsycz bO60g uvbq8ehM0OW4',1,15), `col1` = SUBSTR('S0 | | 160 | root | | test | Query | 864 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('5WuVqS3iggDe5 wqHaNZaBIy Rc6 gGFlwihKAatiasdMqKaTK2wNx gq | | 161 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('sdkfT8lR4MhEEcqKKC0jOVbqx0UJm aKMGITx6 IIaKhY0HtOA6 | | 162 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('g6goyqC6G6omq1W0igqNi7EaS8lqo2HKGsjQgmQlyAzQFiNEqv6 | | 163 | root | | test | Query | 878 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR(' rlG2sKSRkyy4Ra66TaSatuCO6lSE9KMKCaRW6iMqRma86sz J0 | | 164 | root | | test | Query | 877 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('aqsO2D65fMHCkTQ4Itifo6CC0a6bA GYdSuy6Ciie8eaS6qaF6P | | 165 | root | | test | Query | 876 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('TCQaQk6wjCR3QWfAXhCPav6o68skQG6B02a4mm RlIP D6K6adLsDeEfO | | 166 | root | | test | Query | 816 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('kmOOoK6MYtzAcuHla3K06AuC4qeQDG71GOQKGGaZrSFiqkIqqNJ | | 167 | root | | test | Query | 877 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('kaoSwbot2fdy6yYmmMiCqgvqVQyaGq15i0JYBaU0aGKg1qUSCaF | | 168 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('bU2uwuIKW7ugzaK2y0C6rYgmyoay991jWUKW WCmuMSrIi84ECi | | 169 | root | | test | Query | 876 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('2WMae0S6YYOgLOfaCyjiaPSY1DGweCTa3te27',1,15), `col1 | | 170 | root | | test | Query | 866 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('yDiIUCG9CyiaaCeEmKox0aK8K2bSi6VKSi6viWSa6Yo8SkEu2q6mnX6oa | | 171 | root | | test | Query | 877 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('KLbKK0iUqS2eSAoYEoyGqWacCISAw8dkYyCGGhoaTYaes8x61yBPESi2q | | 172 | root | | test | Query | 864 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('4LKCNXMVOA3ze0B6wS6OwHidwnYSE8g6quWaaiKV40QkcG60yvs | | 173 | root | | test | Query | 865 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('wCiqhC3q00EOGywaSYobkPWyTicYBHDQkpauayNU AKILyw02tO | | 174 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('FqKzD1mma6yaqyqMSCk16',1,15), `col1` = SUBSTR('6q8I | | 175 | root | | test | Query | 797 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('G6q1NqaeEaKEiOqBMmQoj6 RVk GZeEguiWKq606SWii4qPCqa8 | | 176 | root | | test | Query | 876 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('bS6fveEECCkwX iaX WIoaYKvwA1pt qub4zkLPe0Ke6S ak6MeWir3aG | | 177 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('y2i6q11Sy1 YanaqIhGwOUKuuvq A Aytr0',1,15), `col1` | | 178 | root | | test | Query | 896 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('2icIobfWaefkecSx2vnaKQi90KCceWHenKQimKSs',1,15), `c | | 179 | root | | test | Query | 878 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('AkS0Mu9M9Msy4eZ oOs5CL6SDbj3WKCaqicWagusG6qOptNmZpYa0a2gq | | 180 | root | | test | Query | 858 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('',1,15), `col1` = SUBSTR('uiAFKRbWVT pqaCMWapaK6HqE | | 181 | root | | test | Query | 897 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('sY2emWacqnMhsIsdSah6X7COAXyX22aaOxia46WCySKayI 0QiCrL wGi | | 182 | root | | test | Query | 876 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('9qE5iAQMYfCCk0Iam8ubbEyGZSqq0Hca3O6mSKG2m',1,15), ` | | 183 | root | | test | Query | 864 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('arUGYvI8 y2iuAM06eiv6CsTCr8M2QmOS8weGTmVu6WcNK5xXi uChEFa | | 184 | root | | test | Query | 876 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('X OWCC6GdKaXJey DWqvgi6iZKW0ucqvAq9AvwdqeWa6wmuuIY7EVRXea | | 185 | root | | test | Query | 808 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('hua2IhoYmteKtxn3dpCxXCI3uwO02gcHscuIwAiKmquIL9wyMZu2tRwLa | | 186 | root | | test | Query | 877 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('6Eaaamr2jaIRgCyjMj0qay2ahU68N2iOMUiqliSe3a0IA508Ci6TKK2 d | | 187 | root | | test | Query | 896 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('C6wOq6qSO2Cyva2vAAUq52aMKil24LaaaK1KViCw96UlJHSbeJ6 | | 188 | root | | test | Query | 887 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('AEoqKW3KfSezgiUaOAa0iO i7GjKZuw82laC7bW6TxpCxmUUiMv | | 189 | root | | test | Query | 856 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('vy66MiF6rcYHbmWIJmC 2zau3E6 ysaamlCpLAQMHo4x wqa hie32aw | | 190 | root | | test | Query | 877 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('KcOycsy08Aq6aCugYJ oH ieKi8amGK8XGikeiqzyPmFO CgsU8 | | 191 | root | | test | Query | 820 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('uoJmOTqK0WmU6EKqIpmFKEYymeMiCqV1ROaSesMbaKcJ7aYKt8SPABzSy | | 192 | root | | test | Query | 888 | update | REPLACE INTO `table0` SET `col0` = SUBSTR('dLhgOYa 09Qni8SZaHG00 eC3dCuEsTsaq fie Ia8s4g0KaHE8a20KCa | | 193 | root | | test | Query | 877 | update | INSERT IGNORE INTO `table0` SET `col0` = SUBSTR('3biqqu4JHnOq2ErqFk1sWq4MRrGIaakqrC gV6rCDbKEcWNUM q | | 194 | root | | test | Query | 864 | update | REPLACE INTO `table0` SET `col0` = SUBSTR(' S6mdS7gIKOElI25KPf6mQA6W0Vgn6FGaKQns3QrNgizLOlpKKgqKKwfC | +-----+------+------+------+---------+------+--------+------------------------------------------------------------------------------------------------------+ 151 rows in set (0.02 sec) mysql> show create table table0\G *************************** 1. row *************************** Table: table0 Create Table: CREATE TABLE `table0` ( `col0` varchar(15) DEFAULT NULL, `col1` char(105) DEFAULT NULL, `col2` char(68) DEFAULT NULL, `col3` varchar(255) DEFAULT NULL, `col4` int(11) DEFAULT NULL, `col5` varchar(255) DEFAULT NULL, `col6` tinyint(4) DEFAULT NULL, `col7` date DEFAULT NULL, `col8` varchar(44) DEFAULT NULL, `col9` int(11) DEFAULT NULL, `col10` varchar(255) DEFAULT NULL, `col11` float DEFAULT NULL, `col12` tinyint(4) DEFAULT NULL, `col13` varchar(255) DEFAULT NULL, `col14` varchar(255) DEFAULT NULL, KEY `idx0` (`col6`,`col2`), KEY `idx1` (`col4`,`col14`(49),`col12`), KEY `idx2` (`col9`), KEY `idx3` (`col11`,`col5`(251),`col13`(207)), KEY `idx4` (`col8`,`col4`,`col1`,`col5`(124)), KEY `idx5` (`col12`,`col1`,`col3`(129),`col11`), KEY `idx6` (`col4`), KEY `idx7` (`col12`), KEY `idx8` (`col12`,`col14`(64),`col4`,`col11`), KEY `idx9` (`col3`(161),`col1`,`col9`), KEY `idx10` (`col6`,`col2`,`col12`), KEY `idx11` (`col6`,`col3`(227),`col11`,`col14`(188)), KEY `idx12` (`col9`,`col8`,`col6`), KEY `idx13` (`col0`), KEY `idx14` (`col10`(116),`col4`,`col5`(203),`col11`), KEY `idx15` (`col9`,`col3`(131),`col8`), KEY `idx16` (`col2`,`col13`(212),`col0`), KEY `idx17` (`col5`(114),`col0`,`col11`,`col13`(35)), KEY `idx18` (`col2`,`col9`), KEY `idx19` (`col14`(2),`col9`), KEY `idx20` (`col13`(88)), KEY `idx21` (`col8`,`col10`(47)), KEY `idx22` (`col5`(228)), KEY `idx23` (`col9`), KEY `idx24` (`col0`,`col12`), KEY `idx25` (`col10`(2)), KEY `idx26` (`col11`,`col10`(75),`col2`), KEY `idx27` (`col10`(107),`col3`(36)), KEY `idx28` (`col6`,`col5`,`col10`(123),`col14`(202)), KEY `idx29` (`col1`) ) ENGINE=Falcon DEFAULT CHARSET=latin1 COMMENT='generated' 1 row in set (0.00 sec) mysql> show global variables like '%fal%'; +--------------------------+----------+ | Variable_name | Value | +--------------------------+----------+ | falcon_log_dir | | | falcon_max_record_memory | 20971520 | | falcon_min_record_memory | 0 | | falcon_page_cache_size | 4194304 | | falcon_log_mask | 0 | | falcon_debug_server | OFF | | falcon_page_size | 4096 | | have_falcon | YES | +--------------------------+----------+ 8 rows in set (0.00 sec) mysql> notee; --host=192.168.250.2:3306 --queryfile=falcon.query --threads=150 --duration=600 --shuffle-queries=1 --user=root --database=test --generate-queryfile=0 [INFO] 00:19:20 [0227] 780 - using 1 hosts [INFO] 00:19:20 [0259] 780 - client library version: 5.0.34 [ALWAYS] 00:19:20 [0274] 780 - server 00: '5.2.3-falcon-alpha-debug', host: '192.168.250.2 via TCP/IP', protocol: 10, charset: latin1 [INFO] 00:19:20 [0320] 780 - read 8 valid queries from query file [INFO] 00:19:20 [0372] 780 - spawning data generation thread [INFO] 00:19:20 [0386] 780 - generate_char_data=1, generate_int_data=0, generate_float_data=0, generate_blob_data=0 [INFO] 00:19:20 [0375] 2040 - creating new char data for the first time [INFO] 00:19:20 [0389] 2040 - refreshing char data [INFO] 00:19:21 [0391] 780 - loop 1,charbucket=01F20040, char_increment=0, generate_char_data=1 [INFO] 00:19:21 [0391] 780 - loop 2,charbucket=01F20040, char_increment=0, generate_char_data=1 [INFO] 00:19:22 [0391] 780 - loop 3,charbucket=01F20040, char_increment=0, generate_char_data=1 [INFO] 00:19:22 [0396] 2040 - char data has been generated, char_increment=42 [INFO] 00:19:22 [0391] 780 - loop 4,charbucket=01F20040, char_increment=42, generate_char_data=1 [INFO] 00:19:22 [0410] 780 - spawning initialization thread [INFO] 00:19:23 [0440] 780 - spawning database stats thread [ALWAYS] 00:19:23 [0456] 780 - spawning 150 new thread(s) [INFO] 00:19:23 [0645] 3564 - show status will be in files like 'report__host_' [WARN] 00:20:10 [2615] 4236 - mysql_real_connect failed: Too many connections (1040) [WARN] 00:20:10 [1915] 4236 - thread number 149 failed to connect to host 0 [INFO] 00:20:10 [0473] 780 - completed spawning new database worker threads [INFO] 00:20:10 [0482] 780 - now running for 600 seconds. [INFO] 00:20:10 [0506] 780 - 149 threads running, 0010988 successful queries. 0000000 failed queries (10988.000000 QPS). [INFO] 00:20:40 [0506] 780 - 149 threads running, 0014038 successful queries. 0000000 failed queries (452.838710 QPS). [INFO] 00:21:10 [0506] 780 - 149 threads running, 0017058 successful queries. 0000000 failed queries (279.639344 QPS). [INFO] 00:21:40 [0506] 780 - 149 threads running, 0018975 successful queries. 0000000 failed queries (208.516484 QPS). [INFO] 00:22:10 [0506] 780 - 149 threads running, 0021146 successful queries. 0000000 failed queries (174.760331 QPS). [INFO] 00:22:40 [0506] 780 - 149 threads running, 0021146 successful queries. 0000000 failed queries (140.039735 QPS). [INFO] 00:23:10 [0506] 780 - 149 threads running, 0021146 successful queries. 0000000 failed queries (116.828729 QPS). [INFO] 00:23:40 [0506] 780 - 149 threads running, 0021146 successful queries. 0000000 failed queries (100.218009 QPS). [INFO] 00:24:10 [0506] 780 - 149 threads running, 0021146 successful queries. 0000000 failed queries (87.742739 QPS). [INFO] 00:24:40 [0506] 780 - 149 threads running, 0021146 successful queries. 0000000 failed queries (78.029520 QPS). [INFO] 00:25:10 [0506] 780 - 149 threads running, 0021146 successful queries. 0000000 failed queries (70.252492 QPS). [INFO] 00:25:40 [0506] 780 - 149 threads running, 0021146 successful queries. 0000000 failed queries (63.885196 QPS). [INFO] 00:26:10 [0506] 780 - 149 threads running, 0021146 successful queries. 0000000 failed queries (58.576177 QPS). [INFO] 00:26:40 [0506] 780 - 149 threads running, 0021146 successful queries. 0000000 failed queries (54.081841 QPS). [INFO] 00:27:40 [0506] 780 - 149 threads running, 0021146 successful queries. 0000000 failed queries (46.886918 QPS). [INFO] 00:28:10 [0506] 780 - 149 threads running, 0021146 successful queries. 0000000 failed queries (43.962578 QPS). [INFO] 00:28:40 [0506] 780 - 149 threads running, 0021146 successful queries. 0000000 failed queries (41.381605 QPS). [INFO] 00:29:10 [0506] 780 - 149 threads running, 0021146 successful queries. 0000000 failed queries (39.086876 QPS). [INFO] 00:29:40 [0506] 780 - 149 threads running, 0021146 successful queries. 0000000 failed queries (37.033275 QPS). [ALWAYS] 00:30:10 [0519] 780 - waiting for threads to finish Status information: Current dir: /home/sbester/server/5.2/mysql-5.2.3-falcon-alpha-linux-i686/data/ Running threads: 152 Stack size: 196608 Current locks: lock: 0x404cc150: write write : 0x924a360 (2451536816:5); 0x90ee140 (2120391600:5); 0x44c031e0 (1148996528:5); 0x9340890 (2460679088:5); 0x90f0d90 (1171811248:5); 0x4521a678 (2139503536:5); 0x939c650 (2387569584:5); 0x9488678 (1161108400:5); 0x452a38f0 (1148795824:5); 0x9340c78 (2077965232:5); 0x938c2b8 (1159687088:5); 0x8e518c0 (2404780976:5); 0x92de6a8 (1157184432:5); 0x94dad40 (2327129008:5); 0x452ab838 (1863596976:5); 0x45256df0 (1146293168:5); 0x8f77368 (1986673584:5); 0x45204168 (1146092464:5); 0x8e8d7b0 (2220153776:5); 0x92a1930 (2597022640:5); 0x933be48 (1150401456:5); 0x9751960 (2509114288:5); 0x4522ae28 (2007886768:5); 0x44c076d0 (1149197232:5); 0x91ca4e0 (2298702768:5); 0x9190708 (2320223152:5); 0x934fe88 (2299706288:5); 0x916da18 (2311216048:5); 0x91cf960 (2404580272:5); 0x4540bd38 (1150000048:5); 0x8e5c5d8 (2442378160:5); 0x96861a0 (1148595120:5); 0x954a2f0 (2581777328:5); 0x939c268 (1202166704:5); 0x8fb3000 (2581576624:5); 0x9329560 (2534611888:5); 0x44c07ab8 (1150602160:5); 0x93404a8 (2376862640:5); 0x8f36800 (2299304880:5); 0x942c5e0 (2441841584:5); 0x91a01e0 (1906023344:5); 0x953fa88 (2444430256:5); 0x9326930 (1285344176:5); 0x98df380 (2298301360:5); 0x9017068 (2485398448:5); 0x452a4c38 (1884810160:5); 0x98e7d50 (1161710512:5); 0x96c14d8 (2636524464:5); 0x93a4e10 (2458377136:5); 0x93da228 (2313518000:5); 0x9333790 (2437237680:5); 0x90ec6f8 (2340338608:5); 0x9350270 (1182653360:5); 0x452aaa88 (2444630960:5); 0x95221f8 (2299104176:5); 0x9612d60 (1254628272:5); 0x93ab298 (1251523504:5); 0x45290c98 (1920932784:5); 0x452b9110 (1935842224:5); 0x452bb968 (2444831664:5); 0x45248788 (2052549552:5); 0x92a1548 (1254026160:5); 0x45251fd0 (1254427568:5); 0x45282780 (1202367408:5); 0x96da420 (2304310192:5); 0x9740258 (2586315696:5); 0x935e690 (1202568112:5); 0x91592c0 (1151003568:5); 0x915dda0 (2498407344:5); 0x966a560 (2308914096:5); 0x9642590 (2558061488:5); 0x96be258 (2478693296:5); 0x8e3f520 (1308326832:5); 0x93db510 (1255029680:5); 0x957d080 (1254226864:5); 0x96f4498 (2442042288:5); 0x452480f0 (1391012784:5); 0x962e8a8 (2298903472:5); 0x95eb228 (2606570416:5); 0x9331c58 (2473888688:5); 0x9041fc0 (1201765296:5); 0x97da5f8 (2599324592:5); 0x91103d8 (1342081968:5); 0x951bd40 (2456075184:5); 0x91363f8 (2289695664:5); 0x93270d8 (2524224432:5); 0x4529c3c8 (1145891760:5); 0x944aae8 (1149397936:5); 0x935ea78 (1149598640:5); 0x964f158 (2324827056:5); 0x940e378 (1161309104:5); 0x4523cf48 (2029099952:5); 0x4523d388 (1165171632:5); 0x97c6b18 (2515618736:5); 0x452943b0 (1150200752:5); 0x9073120 (2439539632:5); 0x962c440 (1161509808:5); 0x9278f38 (2415823792:5); 0x91a4808 (1154681776:5); 0x95b2c78 (2478291888:5); Warning: last didn't point at last lock DB Table Version Thread L.thread Open Lock test table0 1 1771202166704 1 Concurrent insert lock test table0 1 155-1770742864 1 Concurrent insert lock test table0 1 77-2115138640 1 Concurrent insert lock test table0 1 611154681776 1 High priority write lock test table0 1 79-2074813520 1 Concurrent insert lock test table0 1 124-1851987024 1 Concurrent insert lock test table0 1 87-1996264528 1 Concurrent insert lock test table0 1 161-1713390672 1 Concurrent insert lock test table0 1 631884810160 1 Concurrent insert lock test table0 1 511146293168 1 High priority write lock test table0 1 581145891760 1 High priority write lock test table0 1 163-1708651600 1 Concurrent insert lock test table0 1 99-1979147344 1 Concurrent insert lock test table0 1 113-1890186320 1 Concurrent insert lock test table0 1 681986673584 1 Concurrent insert lock test table0 1 98-1981449296 1 Concurrent insert lock test table0 1 1581159687088 1 Concurrent insert lock test table0 1 692007886768 1 High priority write lock test table0 1 521150602160 1 Concurrent insert lock test table0 1 103-1967838288 1 Concurrent insert lock test table0 1 821161509808 1 Concurrent insert lock test table0 1 1921285344176 1 High priority write lock test table0 1 1471165171632 1 Concurrent insert lock test table0 1 141-1809568848 1 Concurrent insert lock test table0 1 1941397517232 1 High priority write lock test table0 1 120-1852925008 1 Concurrent insert lock test table0 1 1441151204272 1 Concurrent insert lock test table0 1 107-1941820496 1 High priority write lock test table0 1 133-1834288208 1 Concurrent insert lock test table0 1 139-1816274000 1 Concurrent insert lock test table0 1 601150200752 1 Concurrent insert lock test table0 1 102-1970140240 1 Concurrent insert lock test table0 1 83-2005271632 1 Concurrent insert lock test table0 1 1871254427568 1 Concurrent insert lock test table0 1 1451154882480 1 High priority write lock test table0 1 85-1996665936 1 Concurrent insert lock test table0 1 1841384307632 1 High priority write lock test table0 1 722077965232 1 High priority write lock test table0 1 168-1697944656 1 Concurrent insert lock test table0 1 1801202768816 1 Concurrent insert lock test table0 1 169-1695642704 1 Concurrent insert lock test table0 1 1501251322800 1 Concurrent insert lock test table0 1 117-1857729616 1 Concurrent insert lock test table0 1 111-1907397712 1 Concurrent insert lock test table0 1 811161309104 1 Concurrent insert lock test table0 1 160-1713591376 1 High priority write lock test table0 1 1881254628272 1 Concurrent insert lock test table0 1 1931391012784 1 Concurrent insert lock test table0 1 491149598640 1 High priority write lock test table0 1 1721201966000 1 Concurrent insert lock test table0 1 1901255029680 1 Concurrent insert lock test table0 1 118-1855427664 1 High priority write lock test table0 1 481148795824 1 Concurrent insert lock test table0 1 1791202568112 1 High priority write lock test table0 1 125-1851786320 1 Concurrent insert lock test table0 1 712052549552 1 Concurrent insert lock test table0 1 1781202367408 1 Concurrent insert lock test table0 1 551150000048 1 Concurrent insert lock test table0 1 154-1779348560 1 Concurrent insert lock test table0 1 752139503536 1 Concurrent insert lock test table0 1 129-1847833680 1 Concurrent insert lock test table0 1 96-1986053200 1 High priority write lock test table0 1 170-1689138256 1 High priority write lock test table0 1 801161108400 1 High priority write lock test table0 1 571148996528 1 Concurrent insert lock test table0 1 135-1829684304 1 High priority write lock test table0 1 561148595120 1 Concurrent insert lock test table0 1 1671308326832 1 Concurrent insert lock test table0 1 661935842224 1 High priority write lock test table0 1 159-1736905808 1 High priority write lock test table0 1 142-1800963152 1 Concurrent insert lock test table0 1 176-1645433936 1 High priority write lock test table0 1 173-1685959760 1 Concurrent insert lock test table0 1 1811254026160 1 High priority write lock test table0 1 162-1713189968 1 Concurrent insert lock test table0 1 1861254226864 1 High priority write lock test table0 1 501149197232 1 Concurrent insert lock test table0 1 742120391600 1 High priority write lock test table0 1 112-1890387024 1 Concurrent insert lock test table0 1 132-1836590160 1 High priority write lock test table0 1 128-1850135632 1 Concurrent insert lock test table0 1 471146092464 1 High priority write lock test table0 1 171-1688396880 1 High priority write lock test table0 1 131-1838892112 1 Concurrent insert lock test table0 1 88-1996063824 1 Concurrent insert lock test table0 1 641906023344 1 Concurrent insert lock test table0 1 89-1995863120 1 Concurrent insert lock test table0 1 841161710512 1 Concurrent insert lock test table0 1 127-1850336336 1 Concurrent insert lock test table0 1 94-1990657104 1 Concurrent insert lock test table0 1 174-1658442832 1 Concurrent insert lock test table0 1 130-1843430480 1 High priority write lock test table0 1 156-1760355408 1 Concurrent insert lock test table0 1 591151003568 1 Concurrent insert lock test table0 1 97-1983751248 1 High priority write lock test table0 1 136-1821078608 1 Concurrent insert lock test table0 1 90-1995662416 1 Concurrent insert lock test table0 1 100-1974744144 1 Concurrent insert lock test table0 1 121-1852589136 1 Concurrent insert lock test table0 1 1821342081968 1 Concurrent insert lock test table0 1 105-1965335632 1 High priority write lock test table0 1 1511251523504 1 Concurrent insert lock test table0 1 1461157184432 1 Concurrent insert lock test table0 1 1491182653360 1 Concurrent insert lock test table0 1 119-1853125712 1 Concurrent insert lock test table0 1 126-1850537040 1 Concurrent insert lock test table0 1 702029099952 1 Concurrent insert lock test table0 1 1481171811248 1 Concurrent insert lock test table0 1 106-1954628688 1 Concurrent insert lock test table0 1 651920932784 1 Concurrent insert lock test table0 1 110-1918104656 1 Concurrent insert lock test table0 1 143-1796559952 1 Concurrent insert lock test table0 1 1831373600688 1 High priority write lock test table0 1 76-2134250576 1 Concurrent insert lock test table0 1 531149397936 1 High priority write lock test table0 1 115-1879143504 1 Concurrent insert lock test table0 1 137-1816675408 1 Concurrent insert lock test table0 1 621863596976 1 Concurrent insert lock test table0 1 541150401456 1 High priority write lock test table0 1 153-1785853008 1 Concurrent insert lock test table0 1 92-1995261008 1 Concurrent insert lock test table0 1 1651284942768 1 High priority write lock test table0 1 1641201765296 1 Concurrent insert lock test table0 1 461150802864 1 High priority write lock test table0 1 1891254828976 1 High priority write lock test table0 1 95-1988355152 1 Concurrent insert lock test table0 1 134-1834087504 1 Concurrent insert lock test table0 1 1911285143472 1 High priority write lock test table0 1 91-1995461712 1 Concurrent insert lock test table0 1 93-1992959056 1 Concurrent insert lock test table0 1 104-1967637584 1 Concurrent insert lock test table0 1 1661297550256 1 Concurrent insert lock test table0 1 78-2096026704 1 Concurrent insert lock test table0 1 108-1937417296 1 Concurrent insert lock test table0 1 86-1996465232 1 Concurrent insert lock test table0 1 1851384508336 1 High priority write lock test table0 1 140-1813972048 1 Concurrent insert lock test table0 1 109-1924609104 1 Concurrent insert lock test table0 1 101-1972442192 1 Concurrent insert lock test table0 1 116-1862132816 1 Concurrent insert lock test table0 1 114-1883681872 1 Concurrent insert lock test table0 1 138-1816474704 1 High priority write lock test table0 1 123-1852187728 1 Concurrent insert lock test table0 1 175-1656140880 1 Concurrent insert lock test table0 1 732101279664 1 High priority write lock test table0 1 671963359152 1 High priority write lock test table0 1 1521253825456 1 Concurrent insert lock test table0 1 1571159486384 1 Concurrent insert lock test table0 1 122-1852388432 1 Concurrent insert lock Current refresh version: 1 Key caches: default Buffer_size: 8388572 Block_size: 1024 Division_limit: 100 Age_limit: 300 blocks used: 0 not flushed: 0 w_requests: 0 writes: 0 r_requests: 0 reads: 0 handler status: read_key: 0 read_next: 0 read_rnd 16 read_first: 1 write: 88731 delete 0 update: 0 Table status: Opened tables: 9036 Open tables: 149 Open files: 0 Open streams: 0 Alarm status: Active alarms: 2 Max used alarms: 30 Next alarm time: 28730 Thread database.table_name Locked/Waiting Lock_type 130 test.table0 Locked - write High priority write lock Warning: Not freed memory segments: 4082 Warning: Memory that was not free'ed (19944258 bytes): Maximum memory usage: 24355616 bytes (23785k)