mysql> show innodb status\G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 080208 11:20:31 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 22 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 9643548, signal count 5667670 --Thread 1165379936 has waited at btr/btr0cur.c line 442 for 13.00 seconds the semaphore: Wait array cell state 1 S-lock on RW-latch at 0x2adcc4e4a8 created in file buf/buf0buf.c line 547 a writer (thread id 1160055136) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file btr/btr0cur.c line 442 Last time write locked in file btr/btr0cur.c line 442 --Thread 1160055136 has waited at btr/btr0cur.c line 442 for 13.00 seconds the semaphore: Wait array cell state 1 X-lock on RW-latch at 0x2adcc4e4a8 created in file buf/buf0buf.c line 547 a writer (thread id 1160055136) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file btr/btr0cur.c line 442 Last time write locked in file btr/btr0cur.c line 442 --Thread 1162451296 has waited at btr/btr0cur.c line 442 for 13.00 seconds the semaphore: Wait array cell state 1 S-lock on RW-latch at 0x2adcc4e4a8 created in file buf/buf0buf.c line 547 a writer (thread id 1160055136) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file btr/btr0cur.c line 442 Last time write locked in file btr/btr0cur.c line 442 --Thread 1168042336 has waited at btr/btr0cur.c line 442 for 13.00 seconds the semaphore: Wait array cell state 1 S-lock on RW-latch at 0x2adcc4e4a8 created in file buf/buf0buf.c line 547 a writer (thread id 1160055136) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file btr/btr0cur.c line 442 Last time write locked in file btr/btr0cur.c line 442 --Thread 1166444896 has waited at btr/btr0cur.c line 442 for 13.00 seconds the semaphore: Wait array cell state 1 S-lock on RW-latch at 0x2adcc4e4a8 created in file buf/buf0buf.c line 547 a writer (thread id 1160055136) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file btr/btr0cur.c line 442 Last time write locked in file btr/btr0cur.c line 442 --Thread 1160587616 has waited at ../../storage/innobase/include/btr0btr.ic line 28 for 13.00 seconds the semaphore: Wait array cell state 1 S-lock on RW-latch at 0x2adcc4e4a8 created in file buf/buf0buf.c line 547 a writer (thread id 1160055136) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file btr/btr0cur.c line 442 Last time write locked in file btr/btr0cur.c line 442 --Thread 1166711136 has waited at btr/btr0cur.c line 442 for 13.00 seconds the semaphore: Wait array cell state 1 X-lock on RW-latch at 0x2adcc4e210 created in file buf/buf0buf.c line 547 a writer (thread id 1166711136) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file btr/btr0sea.c line 768 Last time write locked in file btr/btr0pcur.c line 249 --Thread 1157658976 has waited at trx/trx0purge.c line 1043 for 0.00 seconds the semaphore: Wait array cell state 1 X-lock on RW-latch at 0x2a97bedcd8 created in file trx/trx0purge.c line 212 a writer (thread id 1157658976) has reserved it in mode wait exclusive number of readers 1, waiters flag 1 Last time read locked in file row/row0vers.c line 443 Last time write locked in file trx/trx0purge.c line 1043 Mutex spin waits 0, rounds 352708867, OS waits 7675402 RW-shared spins 168347, OS waits 41118; RW-excl spins 3730903, OS waits 974735 ------------ TRANSACTIONS ------------ Trx id counter 0 56754139 Purge done for trx's n:o < 0 22505492 undo n:o < 0 0 History list length 17119319 Total number of lock structs in row lock hash table 3 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, process no 13237, OS thread id 1172568416 MySQL thread id 107, query id 17373044 localhost 127.0.0.1 root show innodb status ---TRANSACTION 0 56754096, not started, process no 13237, OS thread id 1165646176 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 98, query id 17373022 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 614980131,intcol2 = 2027947119,charcol1 = '4xMpYR8w8o74pPs3Q0ZXgAAzy9rtNaOJOe0wx8k5pj9e01ZJu7iQ9kPzu8k9i0K6fLvcTXiA7jg7dEIXD0xMlMDXMygwy03dLq6jDglKNQK0YeNlfKzGaCnwARl1Jg',charcol2 = 'WZWc8bGtwYB8OjeoS98JPbOCNaX8RjoyGAaGmj1aFDifwKRHMScn300IRXRuEFkMIJW4uYe9dCgZO0imKBaF3QZMx0H481IQCpM6Ds7q4gFSgq701Z74zgRoZckZT3',charcol3 = 'rakDYp5gX1KeLsSSkT1rQsNlhwDPTaKC84PhtMDGNPvdHN51lzk3r7oOwtqHRAWc7n9s2E9Hf4uoRshCrPFaOvzKope8r0kynlrpzs7Ww1INlzScOb3gN213jfBQfn' WHERE id = '6168' ---TRANSACTION 0 56754082, not started, process no 13237, OS thread id 1163782496 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 104, query id 17373015 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1576223060,intcol2 = 942232734,charcol1 = 'nHujWOi8H3SwwB0cewKe8d5AyZL6EZ01qmkDAILKLh89t8lXwx9xQ67OXKWltWek9EpBYAXljfvcfY0cM1Zo8YDXsbHlynL7uAIQCi4wDrOtFOTdQuQQQXpI6y3wmH',charcol2 = '3gREyYw2S9ls219NeRHwlbRatQZpMJ6IrPYppKkHTT2OWBf1WpxFOHpAbMzpZx7OEX64rqDDBFdaIGbo5O3MhlYG7XyZK5xQTvWKlcZxj2X2JyiGMee4NACMZ2vl8l',charcol3 = '4dgQpQ2FFmHegccMlq0FmNIrmjthL1IPWzrCHuRYgk2KDWaqKb57qNyczrAKlSl7JcJcMe8uN26SYhItGF0yXybWhdqQxRQHvltIGuCfwJzTs9M0OEyv4PHl274sQW' WHERE id = '5353' ---TRANSACTION 0 56754068, not started, process no 13237, OS thread id 1167509856 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 103, query id 17373008 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1576223060,intcol2 = 942232734,charcol1 = 'nHujWOi8H3SwwB0cewKe8d5AyZL6EZ01qmkDAILKLh89t8lXwx9xQ67OXKWltWek9EpBYAXljfvcfY0cM1Zo8YDXsbHlynL7uAIQCi4wDrOtFOTdQuQQQXpI6y3wmH',charcol2 = '3gREyYw2S9ls219NeRHwlbRatQZpMJ6IrPYppKkHTT2OWBf1WpxFOHpAbMzpZx7OEX64rqDDBFdaIGbo5O3MhlYG7XyZK5xQTvWKlcZxj2X2JyiGMee4NACMZ2vl8l',charcol3 = '4dgQpQ2FFmHegccMlq0FmNIrmjthL1IPWzrCHuRYgk2KDWaqKb57qNyczrAKlSl7JcJcMe8uN26SYhItGF0yXybWhdqQxRQHvltIGuCfwJzTs9M0OEyv4PHl274sQW' WHERE id = '1879' ---TRANSACTION 0 56754136, not started, process no 13237, OS thread id 1158191456 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 105, query id 17373042 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1322166549,intcol2 = 823399162,charcol1 = '7ugNokudvtyn2CnJQmEMBO76N3yqZzCZtkwaSrBGc93XDjqfLwtOK0WkwKaLJeu5MrfiaiyAjuZwdNRyKKMYClG85iMHKGMaztHPR7SA11yWPPKddj9pKQqH8CQLKg',charcol2 = 'vKZ4d0C52570cOHw1uXAkjSQ1TeJqy0lAPqoQ2lKzsLR8WG9PnC1NYRG1xbrvbdy1ReJLNfC8sgGFwIgbMhyu0EwxinsHGiAbKLoct1klhs0d2Y4O53J5972run13L',charcol3 = '3eiPRAISuv1eoWhKaxQTGNfFIMA5F5QJj0k2A2WwxNRlt8yS5GpEfSTxjXuycD9CDtEGnd4d0XEufCEdS3j0O4p7ckx4x7G2sNAg0FH0mXmIc0nwwWoKaeJ2E873FF' WHERE id = '6094' ---TRANSACTION 0 56754062, not started, process no 13237, OS thread id 1161120096 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 99, query id 17373005 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 601509202,intcol2 = 1905068689,charcol1 = '5dfQWSPWlOQP0HHO5AMpvHa22L9mBXR806QNRrtC7BT7KmYQxm7k3hmxvojyBB649YRcFChFOAMkxu2mZ9Wcj9Qex9c8KaCWyXy5kfK0ijcfTXH2gfXFoxtlyLmBvq',charcol2 = 'ZtMXzy3Jql2QGOxZQW4plteXWds8oozLZDkOBfktOeJY29xLf22GvhnHAYQyCPBlWnAhRmQjGlGJm5YH7aQu7DCHdW7pvARPyTyHFOsX10ig66x5hF0oT4yya5oLG7',charcol3 = 'e6cSFjk76d8pHEn7BSMB9j77iZ4MuKLOIxsZYcheEhJXn7WyRt2SS9bAbYOTklm3aeS6F1dLiokLvFKF0MjSNBXyjnKJZ6M7kr6rkj4RNpoBw0QwM1Ge4fcfRwzsuL' WHERE id = '4683' ---TRANSACTION 0 56754074, not started, process no 13237, OS thread id 1164048736 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 100, query id 17373011 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1576223060,intcol2 = 942232734,charcol1 = 'nHujWOi8H3SwwB0cewKe8d5AyZL6EZ01qmkDAILKLh89t8lXwx9xQ67OXKWltWek9EpBYAXljfvcfY0cM1Zo8YDXsbHlynL7uAIQCi4wDrOtFOTdQuQQQXpI6y3wmH',charcol2 = '3gREyYw2S9ls219NeRHwlbRatQZpMJ6IrPYppKkHTT2OWBf1WpxFOHpAbMzpZx7OEX64rqDDBFdaIGbo5O3MhlYG7XyZK5xQTvWKlcZxj2X2JyiGMee4NACMZ2vl8l',charcol3 = '4dgQpQ2FFmHegccMlq0FmNIrmjthL1IPWzrCHuRYgk2KDWaqKb57qNyczrAKlSl7JcJcMe8uN26SYhItGF0yXybWhdqQxRQHvltIGuCfwJzTs9M0OEyv4PHl274sQW' WHERE id = '3953' ---TRANSACTION 0 56754116, not started, process no 13237, OS thread id 1167243616 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 94, query id 17373032 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 2101913295,intcol2 = 1100418235,charcol1 = 'XQ0K9x30cYaFq2RvMZzKHKgmxy4uKBpreh4fX7f7XEEM8a9Nz8jGKFuAEy4aAtIgREJyDyxl44zDe8Sd9BmTIgfYfjzpTHTwNgmcejDbnCgHD8nMBZjT5N2kytPJ2m',charcol2 = '7PQt1xTFY8JCIYK5uXWWsbtmCjfdvhO2yiosf9zB9IFRjbOTyuzjMkTaS93NiJHZ25PZ6OdGasjHK0nAmmt8XNarOe6yxFXzDoZJ42bfuBoEBRHpEAydPOKp2Ig0ZB',charcol3 = 'rmsG6wIZR5kGBnjSTpfJIwjeemwIeMLL8De6AogdtGl5wTZPA4kTtR7X5wpjIAxIGbPIN5n9LZEHufa4cIPTePsjLhJXjGprjE9yBxzZWDiGl9CDReax3QZGzsni0S' WHERE id = '3372' ---TRANSACTION 0 56754086, not started, process no 13237, OS thread id 1171237216 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 93, query id 17373017 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1839719074,intcol2 = 1147388315,charcol1 = 'jbPuYPJuWuAF3FKMtuKwCtCBdruTJKwuvLhKms6Hm9OhOlwHXG5k19nW0hrBtn6h8ntnXz4A8KrOxnZTve5onsIfQ9rBopkxSdkzTg9T0tuyYRJK6G8l0JHQK8W9pE',charcol2 = 'yHsa8LEIq63cwb47n2FwfG7waR44ctJQ230BG6Ly5Ob1rX1fZGRCOa1z15vWr6wl9xwH39G8Pj2H6voX3FjSpcJiiECPL92M6rg10o2QNwbTjN0meb6JCP1mgE31F5',charcol3 = 'NDwvEpj8FywqRf5RQj3Yu7yvtW9wNO1eTqakf9ku8hcbKhveGqBAx1xqNzemFXOlLqT005m0mEb7nMd3Co59h3r42Tq917uMxFFxLtx78P6vnkrsOw1yrl2lElv7sp' WHERE id = '121' ---TRANSACTION 0 56754112, not started, process no 13237, OS thread id 1161918816 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 101, query id 17373030 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1839719074,intcol2 = 1147388315,charcol1 = 'jbPuYPJuWuAF3FKMtuKwCtCBdruTJKwuvLhKms6Hm9OhOlwHXG5k19nW0hrBtn6h8ntnXz4A8KrOxnZTve5onsIfQ9rBopkxSdkzTg9T0tuyYRJK6G8l0JHQK8W9pE',charcol2 = 'yHsa8LEIq63cwb47n2FwfG7waR44ctJQ230BG6Ly5Ob1rX1fZGRCOa1z15vWr6wl9xwH39G8Pj2H6voX3FjSpcJiiECPL92M6rg10o2QNwbTjN0meb6JCP1mgE31F5',charcol3 = 'NDwvEpj8FywqRf5RQj3Yu7yvtW9wNO1eTqakf9ku8hcbKhveGqBAx1xqNzemFXOlLqT005m0mEb7nMd3Co59h3r42Tq917uMxFFxLtx78P6vnkrsOw1yrl2lElv7sp' WHERE id = '7638' ---TRANSACTION 0 56754114, not started, process no 13237, OS thread id 1171503456 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 92, query id 17373031 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 614980131,intcol2 = 2027947119,charcol1 = '4xMpYR8w8o74pPs3Q0ZXgAAzy9rtNaOJOe0wx8k5pj9e01ZJu7iQ9kPzu8k9i0K6fLvcTXiA7jg7dEIXD0xMlMDXMygwy03dLq6jDglKNQK0YeNlfKzGaCnwARl1Jg',charcol2 = 'WZWc8bGtwYB8OjeoS98JPbOCNaX8RjoyGAaGmj1aFDifwKRHMScn300IRXRuEFkMIJW4uYe9dCgZO0imKBaF3QZMx0H481IQCpM6Ds7q4gFSgq701Z74zgRoZckZT3',charcol3 = 'rakDYp5gX1KeLsSSkT1rQsNlhwDPTaKC84PhtMDGNPvdHN51lzk3r7oOwtqHRAWc7n9s2E9Hf4uoRshCrPFaOvzKope8r0kynlrpzs7Ww1INlzScOb3gN213jfBQfn' WHERE id = '8291' ---TRANSACTION 0 56754106, not started, process no 13237, OS thread id 1158457696 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 91, query id 17373027 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 116314197,intcol2 = 805287600,charcol1 = 'e8YWNpN1C9JgA6T6SHI3vdx1lw4tC2liAH5PySQ2dejfcCd5Lv0HOxA2uFnyHYYJhdcf52ZbYGE9KkEifErw31qx8dnH1KSax4DvzmWXvcY7KmhssOowIWlQzZc0l4',charcol2 = 'Qi9fT8HrX4S4CoilYbACNSi0mhPMZARzlcWEcg6zkQ3o6eafDcrS4QSq7u5Z4YYh0vwSbuRBKN0QtQ562pQyFmgEYlnT9CA176Ta0plC4dfxvkvpZDngzKvY5it7m3',charcol3 = '8t2WJuJx7FamCMMzBoCrSBBFb8ySFkYGWQmhKxeRC55ORSNWGbLceYsEhiaoIy4gOiMlfs4rxA7GeMnmp0ESZ6a6g8mz7jXNPt85mDwbN4ktIXf8XlcwkAuOAZF9Gn' WHERE id = '5259' ---TRANSACTION 0 56754130, not started, process no 13237, OS thread id 1163250016 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 86, query id 17373039 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 116314197,intcol2 = 805287600,charcol1 = 'e8YWNpN1C9JgA6T6SHI3vdx1lw4tC2liAH5PySQ2dejfcCd5Lv0HOxA2uFnyHYYJhdcf52ZbYGE9KkEifErw31qx8dnH1KSax4DvzmWXvcY7KmhssOowIWlQzZc0l4',charcol2 = 'Qi9fT8HrX4S4CoilYbACNSi0mhPMZARzlcWEcg6zkQ3o6eafDcrS4QSq7u5Z4YYh0vwSbuRBKN0QtQ562pQyFmgEYlnT9CA176Ta0plC4dfxvkvpZDngzKvY5it7m3',charcol3 = '8t2WJuJx7FamCMMzBoCrSBBFb8ySFkYGWQmhKxeRC55ORSNWGbLceYsEhiaoIy4gOiMlfs4rxA7GeMnmp0ESZ6a6g8mz7jXNPt85mDwbN4ktIXf8XlcwkAuOAZF9Gn' WHERE id = '2141' ---TRANSACTION 0 56754056, not started, process no 13237, OS thread id 1162717536 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 89, query id 17373002 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 2126558185,intcol2 = 773273718,charcol1 = 'Y88N07to033m2XEIzHzMJsHuXTL2GeCheC4WJqIClDqol4ycMpqZh7K4cZytBBQhNMBb4LnqadWBZSfvITLzdZw56uqH5GqTftwj6jZYC3klONZalmPEJLJPGAaLIO',charcol2 = 'ip9eZFDynPuN3AnSkOE9ePXxinzG0IYjzhLYobNbs9znJeFv2L4YmRTS6Lc7X0qWZ3vLWApFJo2WIAPKXLsIhDenQ7ux7cKhYFu2Pj9cNCyhMFtlSd39raxHhj7gKR',charcol3 = 'Dsa0mrjwR70PgEYaz0BvAuLz4uiBa2Wgm4gPvFDEMDXvR3TI3gD5RQ4XKnivhCRK87l3My9d3gYMbtgePmcsCgNZRxK11nL9m640wDTzltLKm1r4fRws7CHR9TSBGp' WHERE id = '4778' ---TRANSACTION 0 56754054, not started, process no 13237, OS thread id 1159522656 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 87, query id 17373001 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1407841593,intcol2 = 32683953,charcol1 = 'YZeAmRm1NWuhtPpG3P5nRrBWOJXYy46WWkhG3JAQhw8QEpaH7f4QN7wfISCGOInuuK3qX5G41GM76wG5SCXrKKMWgan4kQrXmmL9rTDkmbskN8prLCaZYx3CNiH880',charcol2 = 'XumsvTL8Dzbxbz6GiJTHk16n6TMFdWF8HtsCM6DRxoPZfNhEiAXQ4T5AyRPSyYS7PLJfJO6G5XpkuXycZLuTqsfhBw91Sd8lqSO9sXQx27apWOHweCPKw517t29EgH',charcol3 = 'zMdGYMnyJhxlWS2gOgsp0gmunYwwmSEdrrtFDg5PE22cM4Gek0Kdg6XSWJGGoWuXEneJKjcQlf20jBeKBypkxK4RXKkBrWax9CGTvlvZOqZz13BC20orCsIcDunwGM' WHERE id = '1714' ---TRANSACTION 0 56754128, not started, process no 13237, OS thread id 1164847456 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 88, query id 17373038 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 614980131,intcol2 = 2027947119,charcol1 = '4xMpYR8w8o74pPs3Q0ZXgAAzy9rtNaOJOe0wx8k5pj9e01ZJu7iQ9kPzu8k9i0K6fLvcTXiA7jg7dEIXD0xMlMDXMygwy03dLq6jDglKNQK0YeNlfKzGaCnwARl1Jg',charcol2 = 'WZWc8bGtwYB8OjeoS98JPbOCNaX8RjoyGAaGmj1aFDifwKRHMScn300IRXRuEFkMIJW4uYe9dCgZO0imKBaF3QZMx0H481IQCpM6Ds7q4gFSgq701Z74zgRoZckZT3',charcol3 = 'rakDYp5gX1KeLsSSkT1rQsNlhwDPTaKC84PhtMDGNPvdHN51lzk3r7oOwtqHRAWc7n9s2E9Hf4uoRshCrPFaOvzKope8r0kynlrpzs7Ww1INlzScOb3gN213jfBQfn' WHERE id = '383' ---TRANSACTION 0 56754120, not started, process no 13237, OS thread id 1163516256 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 96, query id 17373034 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1407841593,intcol2 = 32683953,charcol1 = 'YZeAmRm1NWuhtPpG3P5nRrBWOJXYy46WWkhG3JAQhw8QEpaH7f4QN7wfISCGOInuuK3qX5G41GM76wG5SCXrKKMWgan4kQrXmmL9rTDkmbskN8prLCaZYx3CNiH880',charcol2 = 'XumsvTL8Dzbxbz6GiJTHk16n6TMFdWF8HtsCM6DRxoPZfNhEiAXQ4T5AyRPSyYS7PLJfJO6G5XpkuXycZLuTqsfhBw91Sd8lqSO9sXQx27apWOHweCPKw517t29EgH',charcol3 = 'zMdGYMnyJhxlWS2gOgsp0gmunYwwmSEdrrtFDg5PE22cM4Gek0Kdg6XSWJGGoWuXEneJKjcQlf20jBeKBypkxK4RXKkBrWax9CGTvlvZOqZz13BC20orCsIcDunwGM' WHERE id = '7654' ---TRANSACTION 0 56754092, not started, process no 13237, OS thread id 1170438496 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 90, query id 17373020 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 2126558185,intcol2 = 773273718,charcol1 = 'Y88N07to033m2XEIzHzMJsHuXTL2GeCheC4WJqIClDqol4ycMpqZh7K4cZytBBQhNMBb4LnqadWBZSfvITLzdZw56uqH5GqTftwj6jZYC3klONZalmPEJLJPGAaLIO',charcol2 = 'ip9eZFDynPuN3AnSkOE9ePXxinzG0IYjzhLYobNbs9znJeFv2L4YmRTS6Lc7X0qWZ3vLWApFJo2WIAPKXLsIhDenQ7ux7cKhYFu2Pj9cNCyhMFtlSd39raxHhj7gKR',charcol3 = 'Dsa0mrjwR70PgEYaz0BvAuLz4uiBa2Wgm4gPvFDEMDXvR3TI3gD5RQ4XKnivhCRK87l3My9d3gYMbtgePmcsCgNZRxK11nL9m640wDTzltLKm1r4fRws7CHR9TSBGp' WHERE id = '8664' ---TRANSACTION 0 56754098, not started, process no 13237, OS thread id 1166977376 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 85, query id 17373023 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 614980131,intcol2 = 2027947119,charcol1 = '4xMpYR8w8o74pPs3Q0ZXgAAzy9rtNaOJOe0wx8k5pj9e01ZJu7iQ9kPzu8k9i0K6fLvcTXiA7jg7dEIXD0xMlMDXMygwy03dLq6jDglKNQK0YeNlfKzGaCnwARl1Jg',charcol2 = 'WZWc8bGtwYB8OjeoS98JPbOCNaX8RjoyGAaGmj1aFDifwKRHMScn300IRXRuEFkMIJW4uYe9dCgZO0imKBaF3QZMx0H481IQCpM6Ds7q4gFSgq701Z74zgRoZckZT3',charcol3 = 'rakDYp5gX1KeLsSSkT1rQsNlhwDPTaKC84PhtMDGNPvdHN51lzk3r7oOwtqHRAWc7n9s2E9Hf4uoRshCrPFaOvzKope8r0kynlrpzs7Ww1INlzScOb3gN213jfBQfn' WHERE id = '6006' ---TRANSACTION 0 56754072, not started, process no 13237, OS thread id 1170704736 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 95, query id 17373010 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 614980131,intcol2 = 2027947119,charcol1 = '4xMpYR8w8o74pPs3Q0ZXgAAzy9rtNaOJOe0wx8k5pj9e01ZJu7iQ9kPzu8k9i0K6fLvcTXiA7jg7dEIXD0xMlMDXMygwy03dLq6jDglKNQK0YeNlfKzGaCnwARl1Jg',charcol2 = 'WZWc8bGtwYB8OjeoS98JPbOCNaX8RjoyGAaGmj1aFDifwKRHMScn300IRXRuEFkMIJW4uYe9dCgZO0imKBaF3QZMx0H481IQCpM6Ds7q4gFSgq701Z74zgRoZckZT3',charcol3 = 'rakDYp5gX1KeLsSSkT1rQsNlhwDPTaKC84PhtMDGNPvdHN51lzk3r7oOwtqHRAWc7n9s2E9Hf4uoRshCrPFaOvzKope8r0kynlrpzs7Ww1INlzScOb3gN213jfBQfn' WHERE id = '1191' ---TRANSACTION 0 56754108, not started, process no 13237, OS thread id 1170172256 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 84, query id 17373028 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1407841593,intcol2 = 32683953,charcol1 = 'YZeAmRm1NWuhtPpG3P5nRrBWOJXYy46WWkhG3JAQhw8QEpaH7f4QN7wfISCGOInuuK3qX5G41GM76wG5SCXrKKMWgan4kQrXmmL9rTDkmbskN8prLCaZYx3CNiH880',charcol2 = 'XumsvTL8Dzbxbz6GiJTHk16n6TMFdWF8HtsCM6DRxoPZfNhEiAXQ4T5AyRPSyYS7PLJfJO6G5XpkuXycZLuTqsfhBw91Sd8lqSO9sXQx27apWOHweCPKw517t29EgH',charcol3 = 'zMdGYMnyJhxlWS2gOgsp0gmunYwwmSEdrrtFDg5PE22cM4Gek0Kdg6XSWJGGoWuXEneJKjcQlf20jBeKBypkxK4RXKkBrWax9CGTvlvZOqZz13BC20orCsIcDunwGM' WHERE id = '5039' ---TRANSACTION 0 56754126, not started, process no 13237, OS thread id 1158990176 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 83, query id 17373037 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1471079933,intcol2 = 266531426,charcol1 = 'a1vMmjn2ZKuaFxe9yR02BJeO5IKMg5o67bKlI7gjJQHbNokD7lGIwmjt4vFc1vb0Xvdh3HPEbipzMQCT3Koz7Ns3I0gJv7JQ2x8x6P4i7tZMBlrEyXDxuysDqOOlXc',charcol2 = '4QZ4NXTJ5SDeqOGaXE5k30av5OKT2r56HW2ZuXszrxeiEm8lsDLv5oiA42g6md4v86K2T5tLuNv893l18zoEfNOjPwq3amratBSE8Db3dM3eHhYQgKgJjwu1lkwJXn',charcol3 = 'lGr5WzIy2vC6aWn6oJIKWuGOnt1jCOXpYMu2LDsG85EaRtYFCrbadjyOdr7hFWXfkHiyWQEXNKxqDW5HDYrq8h6dP5AYcZCKrmADCGkccaQp4O69opzoN5PoASCe1O' WHERE id = '3443' ---TRANSACTION 0 56754064, not started, process no 13237, OS thread id 1158723936 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 82, query id 17373006 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 601509202,intcol2 = 1905068689,charcol1 = '5dfQWSPWlOQP0HHO5AMpvHa22L9mBXR806QNRrtC7BT7KmYQxm7k3hmxvojyBB649YRcFChFOAMkxu2mZ9Wcj9Qex9c8KaCWyXy5kfK0ijcfTXH2gfXFoxtlyLmBvq',charcol2 = 'ZtMXzy3Jql2QGOxZQW4plteXWds8oozLZDkOBfktOeJY29xLf22GvhnHAYQyCPBlWnAhRmQjGlGJm5YH7aQu7DCHdW7pvARPyTyHFOsX10ig66x5hF0oT4yya5oLG7',charcol3 = 'e6cSFjk76d8pHEn7BSMB9j77iZ4MuKLOIxsZYcheEhJXn7WyRt2SS9bAbYOTklm3aeS6F1dLiokLvFKF0MjSNBXyjnKJZ6M7kr6rkj4RNpoBw0QwM1Ge4fcfRwzsuL' WHERE id = '4207' ---TRANSACTION 0 56754132, not started, process no 13237, OS thread id 1169373536 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 81, query id 17373040 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1322166549,intcol2 = 823399162,charcol1 = '7ugNokudvtyn2CnJQmEMBO76N3yqZzCZtkwaSrBGc93XDjqfLwtOK0WkwKaLJeu5MrfiaiyAjuZwdNRyKKMYClG85iMHKGMaztHPR7SA11yWPPKddj9pKQqH8CQLKg',charcol2 = 'vKZ4d0C52570cOHw1uXAkjSQ1TeJqy0lAPqoQ2lKzsLR8WG9PnC1NYRG1xbrvbdy1ReJLNfC8sgGFwIgbMhyu0EwxinsHGiAbKLoct1klhs0d2Y4O53J5972run13L',charcol3 = '3eiPRAISuv1eoWhKaxQTGNfFIMA5F5QJj0k2A2WwxNRlt8yS5GpEfSTxjXuycD9CDtEGnd4d0XEufCEdS3j0O4p7ckx4x7G2sNAg0FH0mXmIc0nwwWoKaeJ2E873FF' WHERE id = '4227' ---TRANSACTION 0 56754080, not started, process no 13237, OS thread id 1162983776 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 79, query id 17373014 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1839719074,intcol2 = 1147388315,charcol1 = 'jbPuYPJuWuAF3FKMtuKwCtCBdruTJKwuvLhKms6Hm9OhOlwHXG5k19nW0hrBtn6h8ntnXz4A8KrOxnZTve5onsIfQ9rBopkxSdkzTg9T0tuyYRJK6G8l0JHQK8W9pE',charcol2 = 'yHsa8LEIq63cwb47n2FwfG7waR44ctJQ230BG6Ly5Ob1rX1fZGRCOa1z15vWr6wl9xwH39G8Pj2H6voX3FjSpcJiiECPL92M6rg10o2QNwbTjN0meb6JCP1mgE31F5',charcol3 = 'NDwvEpj8FywqRf5RQj3Yu7yvtW9wNO1eTqakf9ku8hcbKhveGqBAx1xqNzemFXOlLqT005m0mEb7nMd3Co59h3r42Tq917uMxFFxLtx78P6vnkrsOw1yrl2lElv7sp' WHERE id = '1897' ---TRANSACTION 0 56754118, not started, process no 13237, OS thread id 1170970976 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 78, query id 17373033 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1233983202,intcol2 = 789373855,charcol1 = 'jdtPbBILRQyiu7nZN3RdI96aQOP4Y0z7dlO4wbQF1OpvYdLnggGrqMP8mjCAjB9CwQHk1jruzhhXA2BibRZPqrPSQdX9gYDTyWDr5xdxWJSgDXEozg5hNW1pzYqgx3',charcol2 = '9nQEfN38KZRh5hCCL3sRkFpm4pAuL7pWvFcQXgar52O3bdFwY7FHE53ImD47LtT81xaYT8Fb2YWd1lQZshqyelGOzCNCxsCyimMBmWep28IvlkSTIJRw4bDvnczlLB',charcol3 = 'bvpq6cCdH6db1NCTsWgKIdvXOb0OKDRn8HdEthjAnLdochAS3qgMJclk3d0FqR2ykY5dDof119pdqz6mie816ld9NdO55R4pr9J4pq5rrnSieQSK5SEB5rLKTlQQ4M' WHERE id = '3998' ---TRANSACTION 0 56754094, not started, process no 13237, OS thread id 1160321376 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 70, query id 17373021 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1322166549,intcol2 = 823399162,charcol1 = '7ugNokudvtyn2CnJQmEMBO76N3yqZzCZtkwaSrBGc93XDjqfLwtOK0WkwKaLJeu5MrfiaiyAjuZwdNRyKKMYClG85iMHKGMaztHPR7SA11yWPPKddj9pKQqH8CQLKg',charcol2 = 'vKZ4d0C52570cOHw1uXAkjSQ1TeJqy0lAPqoQ2lKzsLR8WG9PnC1NYRG1xbrvbdy1ReJLNfC8sgGFwIgbMhyu0EwxinsHGiAbKLoct1klhs0d2Y4O53J5972run13L',charcol3 = '3eiPRAISuv1eoWhKaxQTGNfFIMA5F5QJj0k2A2WwxNRlt8yS5GpEfSTxjXuycD9CDtEGnd4d0XEufCEdS3j0O4p7ckx4x7G2sNAg0FH0mXmIc0nwwWoKaeJ2E873FF' WHERE id = '3705' ---TRANSACTION 0 56754110, not started, process no 13237, OS thread id 1159256416 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 71, query id 17373029 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1322166549,intcol2 = 823399162,charcol1 = '7ugNokudvtyn2CnJQmEMBO76N3yqZzCZtkwaSrBGc93XDjqfLwtOK0WkwKaLJeu5MrfiaiyAjuZwdNRyKKMYClG85iMHKGMaztHPR7SA11yWPPKddj9pKQqH8CQLKg',charcol2 = 'vKZ4d0C52570cOHw1uXAkjSQ1TeJqy0lAPqoQ2lKzsLR8WG9PnC1NYRG1xbrvbdy1ReJLNfC8sgGFwIgbMhyu0EwxinsHGiAbKLoct1klhs0d2Y4O53J5972run13L',charcol3 = '3eiPRAISuv1eoWhKaxQTGNfFIMA5F5QJj0k2A2WwxNRlt8yS5GpEfSTxjXuycD9CDtEGnd4d0XEufCEdS3j0O4p7ckx4x7G2sNAg0FH0mXmIc0nwwWoKaeJ2E873FF' WHERE id = '77' ---TRANSACTION 0 56754058, not started, process no 13237, OS thread id 1168308576 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 77, query id 17373003 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 601509202,intcol2 = 1905068689,charcol1 = '5dfQWSPWlOQP0HHO5AMpvHa22L9mBXR806QNRrtC7BT7KmYQxm7k3hmxvojyBB649YRcFChFOAMkxu2mZ9Wcj9Qex9c8KaCWyXy5kfK0ijcfTXH2gfXFoxtlyLmBvq',charcol2 = 'ZtMXzy3Jql2QGOxZQW4plteXWds8oozLZDkOBfktOeJY29xLf22GvhnHAYQyCPBlWnAhRmQjGlGJm5YH7aQu7DCHdW7pvARPyTyHFOsX10ig66x5hF0oT4yya5oLG7',charcol3 = 'e6cSFjk76d8pHEn7BSMB9j77iZ4MuKLOIxsZYcheEhJXn7WyRt2SS9bAbYOTklm3aeS6F1dLiokLvFKF0MjSNBXyjnKJZ6M7kr6rkj4RNpoBw0QwM1Ge4fcfRwzsuL' WHERE id = '9363' ---TRANSACTION 0 56754124, not started, process no 13237, OS thread id 1161652576 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 76, query id 17373036 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1322166549,intcol2 = 823399162,charcol1 = '7ugNokudvtyn2CnJQmEMBO76N3yqZzCZtkwaSrBGc93XDjqfLwtOK0WkwKaLJeu5MrfiaiyAjuZwdNRyKKMYClG85iMHKGMaztHPR7SA11yWPPKddj9pKQqH8CQLKg',charcol2 = 'vKZ4d0C52570cOHw1uXAkjSQ1TeJqy0lAPqoQ2lKzsLR8WG9PnC1NYRG1xbrvbdy1ReJLNfC8sgGFwIgbMhyu0EwxinsHGiAbKLoct1klhs0d2Y4O53J5972run13L',charcol3 = '3eiPRAISuv1eoWhKaxQTGNfFIMA5F5QJj0k2A2WwxNRlt8yS5GpEfSTxjXuycD9CDtEGnd4d0XEufCEdS3j0O4p7ckx4x7G2sNAg0FH0mXmIc0nwwWoKaeJ2E873FF' WHERE id = '263' ---TRANSACTION 0 56754066, not started, process no 13237, OS thread id 1169906016 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 67, query id 17373007 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 614980131,intcol2 = 2027947119,charcol1 = '4xMpYR8w8o74pPs3Q0ZXgAAzy9rtNaOJOe0wx8k5pj9e01ZJu7iQ9kPzu8k9i0K6fLvcTXiA7jg7dEIXD0xMlMDXMygwy03dLq6jDglKNQK0YeNlfKzGaCnwARl1Jg',charcol2 = 'WZWc8bGtwYB8OjeoS98JPbOCNaX8RjoyGAaGmj1aFDifwKRHMScn300IRXRuEFkMIJW4uYe9dCgZO0imKBaF3QZMx0H481IQCpM6Ds7q4gFSgq701Z74zgRoZckZT3',charcol3 = 'rakDYp5gX1KeLsSSkT1rQsNlhwDPTaKC84PhtMDGNPvdHN51lzk3r7oOwtqHRAWc7n9s2E9Hf4uoRshCrPFaOvzKope8r0kynlrpzs7Ww1INlzScOb3gN213jfBQfn' WHERE id = '9822' ---TRANSACTION 0 56754100, not started, process no 13237, OS thread id 1165113696 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 68, query id 17373024 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 614980131,intcol2 = 2027947119,charcol1 = '4xMpYR8w8o74pPs3Q0ZXgAAzy9rtNaOJOe0wx8k5pj9e01ZJu7iQ9kPzu8k9i0K6fLvcTXiA7jg7dEIXD0xMlMDXMygwy03dLq6jDglKNQK0YeNlfKzGaCnwARl1Jg',charcol2 = 'WZWc8bGtwYB8OjeoS98JPbOCNaX8RjoyGAaGmj1aFDifwKRHMScn300IRXRuEFkMIJW4uYe9dCgZO0imKBaF3QZMx0H481IQCpM6Ds7q4gFSgq701Z74zgRoZckZT3',charcol3 = 'rakDYp5gX1KeLsSSkT1rQsNlhwDPTaKC84PhtMDGNPvdHN51lzk3r7oOwtqHRAWc7n9s2E9Hf4uoRshCrPFaOvzKope8r0kynlrpzs7Ww1INlzScOb3gN213jfBQfn' WHERE id = '5369' ---TRANSACTION 0 56754076, not started, process no 13237, OS thread id 1167776096 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 62, query id 17373012 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1322166549,intcol2 = 823399162,charcol1 = '7ugNokudvtyn2CnJQmEMBO76N3yqZzCZtkwaSrBGc93XDjqfLwtOK0WkwKaLJeu5MrfiaiyAjuZwdNRyKKMYClG85iMHKGMaztHPR7SA11yWPPKddj9pKQqH8CQLKg',charcol2 = 'vKZ4d0C52570cOHw1uXAkjSQ1TeJqy0lAPqoQ2lKzsLR8WG9PnC1NYRG1xbrvbdy1ReJLNfC8sgGFwIgbMhyu0EwxinsHGiAbKLoct1klhs0d2Y4O53J5972run13L',charcol3 = '3eiPRAISuv1eoWhKaxQTGNfFIMA5F5QJj0k2A2WwxNRlt8yS5GpEfSTxjXuycD9CDtEGnd4d0XEufCEdS3j0O4p7ckx4x7G2sNAg0FH0mXmIc0nwwWoKaeJ2E873FF' WHERE id = '8592' ---TRANSACTION 0 56754122, not started, process no 13237, OS thread id 1168841056 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 75, query id 17373035 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 601509202,intcol2 = 1905068689,charcol1 = '5dfQWSPWlOQP0HHO5AMpvHa22L9mBXR806QNRrtC7BT7KmYQxm7k3hmxvojyBB649YRcFChFOAMkxu2mZ9Wcj9Qex9c8KaCWyXy5kfK0ijcfTXH2gfXFoxtlyLmBvq',charcol2 = 'ZtMXzy3Jql2QGOxZQW4plteXWds8oozLZDkOBfktOeJY29xLf22GvhnHAYQyCPBlWnAhRmQjGlGJm5YH7aQu7DCHdW7pvARPyTyHFOsX10ig66x5hF0oT4yya5oLG7',charcol3 = 'e6cSFjk76d8pHEn7BSMB9j77iZ4MuKLOIxsZYcheEhJXn7WyRt2SS9bAbYOTklm3aeS6F1dLiokLvFKF0MjSNBXyjnKJZ6M7kr6rkj4RNpoBw0QwM1Ge4fcfRwzsuL' WHERE id = '8978' ---TRANSACTION 0 56754134, not started, process no 13237, OS thread id 1161386336 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 64, query id 17373041 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1576223060,intcol2 = 942232734,charcol1 = 'nHujWOi8H3SwwB0cewKe8d5AyZL6EZ01qmkDAILKLh89t8lXwx9xQ67OXKWltWek9EpBYAXljfvcfY0cM1Zo8YDXsbHlynL7uAIQCi4wDrOtFOTdQuQQQXpI6y3wmH',charcol2 = '3gREyYw2S9ls219NeRHwlbRatQZpMJ6IrPYppKkHTT2OWBf1WpxFOHpAbMzpZx7OEX64rqDDBFdaIGbo5O3MhlYG7XyZK5xQTvWKlcZxj2X2JyiGMee4NACMZ2vl8l',charcol3 = '4dgQpQ2FFmHegccMlq0FmNIrmjthL1IPWzrCHuRYgk2KDWaqKb57qNyczrAKlSl7JcJcMe8uN26SYhItGF0yXybWhdqQxRQHvltIGuCfwJzTs9M0OEyv4PHl274sQW' WHERE id = '1574' ---TRANSACTION 0 56754090, not started, process no 13237, OS thread id 1159788896 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 61, query id 17373019 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 2126558185,intcol2 = 773273718,charcol1 = 'Y88N07to033m2XEIzHzMJsHuXTL2GeCheC4WJqIClDqol4ycMpqZh7K4cZytBBQhNMBb4LnqadWBZSfvITLzdZw56uqH5GqTftwj6jZYC3klONZalmPEJLJPGAaLIO',charcol2 = 'ip9eZFDynPuN3AnSkOE9ePXxinzG0IYjzhLYobNbs9znJeFv2L4YmRTS6Lc7X0qWZ3vLWApFJo2WIAPKXLsIhDenQ7ux7cKhYFu2Pj9cNCyhMFtlSd39raxHhj7gKR',charcol3 = 'Dsa0mrjwR70PgEYaz0BvAuLz4uiBa2Wgm4gPvFDEMDXvR3TI3gD5RQ4XKnivhCRK87l3My9d3gYMbtgePmcsCgNZRxK11nL9m640wDTzltLKm1r4fRws7CHR9TSBGp' WHERE id = '9267' ---TRANSACTION 0 56754070, not started, process no 13237, OS thread id 1160853856 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 65, query id 17373009 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1576223060,intcol2 = 942232734,charcol1 = 'nHujWOi8H3SwwB0cewKe8d5AyZL6EZ01qmkDAILKLh89t8lXwx9xQ67OXKWltWek9EpBYAXljfvcfY0cM1Zo8YDXsbHlynL7uAIQCi4wDrOtFOTdQuQQQXpI6y3wmH',charcol2 = '3gREyYw2S9ls219NeRHwlbRatQZpMJ6IrPYppKkHTT2OWBf1WpxFOHpAbMzpZx7OEX64rqDDBFdaIGbo5O3MhlYG7XyZK5xQTvWKlcZxj2X2JyiGMee4NACMZ2vl8l',charcol3 = '4dgQpQ2FFmHegccMlq0FmNIrmjthL1IPWzrCHuRYgk2KDWaqKb57qNyczrAKlSl7JcJcMe8uN26SYhItGF0yXybWhdqQxRQHvltIGuCfwJzTs9M0OEyv4PHl274sQW' WHERE id = '9202' ---TRANSACTION 0 56754104, not started, process no 13237, OS thread id 1165912416 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 63, query id 17373026 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1407841593,intcol2 = 32683953,charcol1 = 'YZeAmRm1NWuhtPpG3P5nRrBWOJXYy46WWkhG3JAQhw8QEpaH7f4QN7wfISCGOInuuK3qX5G41GM76wG5SCXrKKMWgan4kQrXmmL9rTDkmbskN8prLCaZYx3CNiH880',charcol2 = 'XumsvTL8Dzbxbz6GiJTHk16n6TMFdWF8HtsCM6DRxoPZfNhEiAXQ4T5AyRPSyYS7PLJfJO6G5XpkuXycZLuTqsfhBw91Sd8lqSO9sXQx27apWOHweCPKw517t29EgH',charcol3 = 'zMdGYMnyJhxlWS2gOgsp0gmunYwwmSEdrrtFDg5PE22cM4Gek0Kdg6XSWJGGoWuXEneJKjcQlf20jBeKBypkxK4RXKkBrWax9CGTvlvZOqZz13BC20orCsIcDunwGM' WHERE id = '4474' ---TRANSACTION 0 56754060, not started, process no 13237, OS thread id 1164581216 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 72, query id 17373004 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 2101913295,intcol2 = 1100418235,charcol1 = 'XQ0K9x30cYaFq2RvMZzKHKgmxy4uKBpreh4fX7f7XEEM8a9Nz8jGKFuAEy4aAtIgREJyDyxl44zDe8Sd9BmTIgfYfjzpTHTwNgmcejDbnCgHD8nMBZjT5N2kytPJ2m',charcol2 = '7PQt1xTFY8JCIYK5uXWWsbtmCjfdvhO2yiosf9zB9IFRjbOTyuzjMkTaS93NiJHZ25PZ6OdGasjHK0nAmmt8XNarOe6yxFXzDoZJ42bfuBoEBRHpEAydPOKp2Ig0ZB',charcol3 = 'rmsG6wIZR5kGBnjSTpfJIwjeemwIeMLL8De6AogdtGl5wTZPA4kTtR7X5wpjIAxIGbPIN5n9LZEHufa4cIPTePsjLhJXjGprjE9yBxzZWDiGl9CDReax3QZGzsni0S' WHERE id = '5607' ---TRANSACTION 0 56754052, not started, process no 13237, OS thread id 1162185056 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 74, query id 17373000 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1407841593,intcol2 = 32683953,charcol1 = 'YZeAmRm1NWuhtPpG3P5nRrBWOJXYy46WWkhG3JAQhw8QEpaH7f4QN7wfISCGOInuuK3qX5G41GM76wG5SCXrKKMWgan4kQrXmmL9rTDkmbskN8prLCaZYx3CNiH880',charcol2 = 'XumsvTL8Dzbxbz6GiJTHk16n6TMFdWF8HtsCM6DRxoPZfNhEiAXQ4T5AyRPSyYS7PLJfJO6G5XpkuXycZLuTqsfhBw91Sd8lqSO9sXQx27apWOHweCPKw517t29EgH',charcol3 = 'zMdGYMnyJhxlWS2gOgsp0gmunYwwmSEdrrtFDg5PE22cM4Gek0Kdg6XSWJGGoWuXEneJKjcQlf20jBeKBypkxK4RXKkBrWax9CGTvlvZOqZz13BC20orCsIcDunwGM' WHERE id = '1671' ---TRANSACTION 0 56754078, not started, process no 13237, OS thread id 1164314976 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 58, query id 17373013 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1407841593,intcol2 = 32683953,charcol1 = 'YZeAmRm1NWuhtPpG3P5nRrBWOJXYy46WWkhG3JAQhw8QEpaH7f4QN7wfISCGOInuuK3qX5G41GM76wG5SCXrKKMWgan4kQrXmmL9rTDkmbskN8prLCaZYx3CNiH880',charcol2 = 'XumsvTL8Dzbxbz6GiJTHk16n6TMFdWF8HtsCM6DRxoPZfNhEiAXQ4T5AyRPSyYS7PLJfJO6G5XpkuXycZLuTqsfhBw91Sd8lqSO9sXQx27apWOHweCPKw517t29EgH',charcol3 = 'zMdGYMnyJhxlWS2gOgsp0gmunYwwmSEdrrtFDg5PE22cM4Gek0Kdg6XSWJGGoWuXEneJKjcQlf20jBeKBypkxK4RXKkBrWax9CGTvlvZOqZz13BC20orCsIcDunwGM' WHERE id = '5406' ---TRANSACTION 0 56754102, not started, process no 13237, OS thread id 1168574816 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 73, query id 17373025 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1471079933,intcol2 = 266531426,charcol1 = 'a1vMmjn2ZKuaFxe9yR02BJeO5IKMg5o67bKlI7gjJQHbNokD7lGIwmjt4vFc1vb0Xvdh3HPEbipzMQCT3Koz7Ns3I0gJv7JQ2x8x6P4i7tZMBlrEyXDxuysDqOOlXc',charcol2 = '4QZ4NXTJ5SDeqOGaXE5k30av5OKT2r56HW2ZuXszrxeiEm8lsDLv5oiA42g6md4v86K2T5tLuNv893l18zoEfNOjPwq3amratBSE8Db3dM3eHhYQgKgJjwu1lkwJXn',charcol3 = 'lGr5WzIy2vC6aWn6oJIKWuGOnt1jCOXpYMu2LDsG85EaRtYFCrbadjyOdr7hFWXfkHiyWQEXNKxqDW5HDYrq8h6dP5AYcZCKrmADCGkccaQp4O69opzoN5PoASCe1O' WHERE id = '3439' ---TRANSACTION 0 56754088, not started, process no 13237, OS thread id 1169107296 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 57, query id 17373018 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1839719074,intcol2 = 1147388315,charcol1 = 'jbPuYPJuWuAF3FKMtuKwCtCBdruTJKwuvLhKms6Hm9OhOlwHXG5k19nW0hrBtn6h8ntnXz4A8KrOxnZTve5onsIfQ9rBopkxSdkzTg9T0tuyYRJK6G8l0JHQK8W9pE',charcol2 = 'yHsa8LEIq63cwb47n2FwfG7waR44ctJQ230BG6Ly5Ob1rX1fZGRCOa1z15vWr6wl9xwH39G8Pj2H6voX3FjSpcJiiECPL92M6rg10o2QNwbTjN0meb6JCP1mgE31F5',charcol3 = 'NDwvEpj8FywqRf5RQj3Yu7yvtW9wNO1eTqakf9ku8hcbKhveGqBAx1xqNzemFXOlLqT005m0mEb7nMd3Co59h3r42Tq917uMxFFxLtx78P6vnkrsOw1yrl2lElv7sp' WHERE id = '9780' ---TRANSACTION 0 56754084, not started, process no 13237, OS thread id 1169639776 waiting in InnoDB queue mysql tables in use 1, locked 1 MySQL thread id 56, query id 17373016 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 116314197,intcol2 = 805287600,charcol1 = 'e8YWNpN1C9JgA6T6SHI3vdx1lw4tC2liAH5PySQ2dejfcCd5Lv0HOxA2uFnyHYYJhdcf52ZbYGE9KkEifErw31qx8dnH1KSax4DvzmWXvcY7KmhssOowIWlQzZc0l4',charcol2 = 'Qi9fT8HrX4S4CoilYbACNSi0mhPMZARzlcWEcg6zkQ3o6eafDcrS4QSq7u5Z4YYh0vwSbuRBKN0QtQ562pQyFmgEYlnT9CA176Ta0plC4dfxvkvpZDngzKvY5it7m3',charcol3 = '8t2WJuJx7FamCMMzBoCrSBBFb8ySFkYGWQmhKxeRC55ORSNWGbLceYsEhiaoIy4gOiMlfs4rxA7GeMnmp0ESZ6a6g8mz7jXNPt85mDwbN4ktIXf8XlcwkAuOAZF9Gn' WHERE id = '7601' ---TRANSACTION 0 35684202, not started, process no 13237, OS thread id 1166178656 MySQL thread id 55, query id 6837993 localhost 127.0.0.1 root ---TRANSACTION 0 56754138, ACTIVE 13 sec, process no 13237, OS thread id 1166711136 updating or deleting, thread declared inside InnoDB 499 mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 1 row lock(s) MySQL thread id 97, query id 17372997 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 116314197,intcol2 = 805287600,charcol1 = 'e8YWNpN1C9JgA6T6SHI3vdx1lw4tC2liAH5PySQ2dejfcCd5Lv0HOxA2uFnyHYYJhdcf52ZbYGE9KkEifErw31qx8dnH1KSax4DvzmWXvcY7KmhssOowIWlQzZc0l4',charcol2 = 'Qi9fT8HrX4S4CoilYbACNSi0mhPMZARzlcWEcg6zkQ3o6eafDcrS4QSq7u5Z4YYh0vwSbuRBKN0QtQ562pQyFmgEYlnT9CA176Ta0plC4dfxvkvpZDngzKvY5it7m3',charcol3 = '8t2WJuJx7FamCMMzBoCrSBBFb8ySFkYGWQmhKxeRC55ORSNWGbLceYsEhiaoIy4gOiMlfs4rxA7GeMnmp0ESZ6a6g8mz7jXNPt85mDwbN4ktIXf8XlcwkAuOAZF9Gn' WHERE id = '18' ---TRANSACTION 0 56753853, ACTIVE 13 sec, process no 13237, OS thread id 1160587616 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 1 row lock(s) MySQL thread id 66, query id 17372899 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1407841593,intcol2 = 32683953,charcol1 = 'YZeAmRm1NWuhtPpG3P5nRrBWOJXYy46WWkhG3JAQhw8QEpaH7f4QN7wfISCGOInuuK3qX5G41GM76wG5SCXrKKMWgan4kQrXmmL9rTDkmbskN8prLCaZYx3CNiH880',charcol2 = 'XumsvTL8Dzbxbz6GiJTHk16n6TMFdWF8HtsCM6DRxoPZfNhEiAXQ4T5AyRPSyYS7PLJfJO6G5XpkuXycZLuTqsfhBw91Sd8lqSO9sXQx27apWOHweCPKw517t29EgH',charcol3 = 'zMdGYMnyJhxlWS2gOgsp0gmunYwwmSEdrrtFDg5PE22cM4Gek0Kdg6XSWJGGoWuXEneJKjcQlf20jBeKBypkxK4RXKkBrWax9CGTvlvZOqZz13BC20orCsIcDunwGM' WHERE id = '19' ---TRANSACTION 0 56752952, ACTIVE 36 sec, process no 13237, OS thread id 1165379936 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 MySQL thread id 80, query id 17372406 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1576223060,intcol2 = 942232734,charcol1 = 'nHujWOi8H3SwwB0cewKe8d5AyZL6EZ01qmkDAILKLh89t8lXwx9xQ67OXKWltWek9EpBYAXljfvcfY0cM1Zo8YDXsbHlynL7uAIQCi4wDrOtFOTdQuQQQXpI6y3wmH',charcol2 = '3gREyYw2S9ls219NeRHwlbRatQZpMJ6IrPYppKkHTT2OWBf1WpxFOHpAbMzpZx7OEX64rqDDBFdaIGbo5O3MhlYG7XyZK5xQTvWKlcZxj2X2JyiGMee4NACMZ2vl8l',charcol3 = '4dgQpQ2FFmHegccMlq0FmNIrmjthL1IPWzrCHuRYgk2KDWaqKb57qNyczrAKlSl7JcJcMe8uN26SYhItGF0yXybWhdqQxRQHvltIGuCfwJzTs9M0OEyv4PHl274sQW' WHERE id = '24' ---TRANSACTION 0 56752119, ACTIVE 36 sec, process no 13237, OS thread id 1162451296 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 MySQL thread id 59, query id 17371974 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 614980131,intcol2 = 2027947119,charcol1 = '4xMpYR8w8o74pPs3Q0ZXgAAzy9rtNaOJOe0wx8k5pj9e01ZJu7iQ9kPzu8k9i0K6fLvcTXiA7jg7dEIXD0xMlMDXMygwy03dLq6jDglKNQK0YeNlfKzGaCnwARl1Jg',charcol2 = 'WZWc8bGtwYB8OjeoS98JPbOCNaX8RjoyGAaGmj1aFDifwKRHMScn300IRXRuEFkMIJW4uYe9dCgZO0imKBaF3QZMx0H481IQCpM6Ds7q4gFSgq701Z74zgRoZckZT3',charcol3 = 'rakDYp5gX1KeLsSSkT1rQsNlhwDPTaKC84PhtMDGNPvdHN51lzk3r7oOwtqHRAWc7n9s2E9Hf4uoRshCrPFaOvzKope8r0kynlrpzs7Ww1INlzScOb3gN213jfBQfn' WHERE id = '53' ---TRANSACTION 0 56752034, ACTIVE 36 sec, process no 13237, OS thread id 1160055136 updating or deleting, thread declared inside InnoDB 499 mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 1 row lock(s) MySQL thread id 102, query id 17371920 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1233983202,intcol2 = 789373855,charcol1 = 'jdtPbBILRQyiu7nZN3RdI96aQOP4Y0z7dlO4wbQF1OpvYdLnggGrqMP8mjCAjB9CwQHk1jruzhhXA2BibRZPqrPSQdX9gYDTyWDr5xdxWJSgDXEozg5hNW1pzYqgx3',charcol2 = '9nQEfN38KZRh5hCCL3sRkFpm4pAuL7pWvFcQXgar52O3bdFwY7FHE53ImD47LtT81xaYT8Fb2YWd1lQZshqyelGOzCNCxsCyimMBmWep28IvlkSTIJRw4bDvnczlLB',charcol3 = 'bvpq6cCdH6db1NCTsWgKIdvXOb0OKDRn8HdEthjAnLdochAS3qgMJclk3d0FqR2ykY5dDof119pdqz6mie816ld9NdO55R4pr9J4pq5rrnSieQSK5SEB5rLKTlQQ4M' WHERE id = '53' ---TRANSACTION 0 56751666, ACTIVE 37 sec, process no 13237, OS thread id 1168042336 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 MySQL thread id 69, query id 17371722 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1233983202,intcol2 = 789373855,charcol1 = 'jdtPbBILRQyiu7nZN3RdI96aQOP4Y0z7dlO4wbQF1OpvYdLnggGrqMP8mjCAjB9CwQHk1jruzhhXA2BibRZPqrPSQdX9gYDTyWDr5xdxWJSgDXEozg5hNW1pzYqgx3',charcol2 = '9nQEfN38KZRh5hCCL3sRkFpm4pAuL7pWvFcQXgar52O3bdFwY7FHE53ImD47LtT81xaYT8Fb2YWd1lQZshqyelGOzCNCxsCyimMBmWep28IvlkSTIJRw4bDvnczlLB',charcol3 = 'bvpq6cCdH6db1NCTsWgKIdvXOb0OKDRn8HdEthjAnLdochAS3qgMJclk3d0FqR2ykY5dDof119pdqz6mie816ld9NdO55R4pr9J4pq5rrnSieQSK5SEB5rLKTlQQ4M' WHERE id = '43' ---TRANSACTION 0 56751372, ACTIVE 60 sec, process no 13237, OS thread id 1166444896 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 MySQL thread id 60, query id 17371609 localhost 127.0.0.1 root Updating UPDATE t1 SET intcol1 = 1839719074,intcol2 = 1147388315,charcol1 = 'jbPuYPJuWuAF3FKMtuKwCtCBdruTJKwuvLhKms6Hm9OhOlwHXG5k19nW0hrBtn6h8ntnXz4A8KrOxnZTve5onsIfQ9rBopkxSdkzTg9T0tuyYRJK6G8l0JHQK8W9pE',charcol2 = 'yHsa8LEIq63cwb47n2FwfG7waR44ctJQ230BG6Ly5Ob1rX1fZGRCOa1z15vWr6wl9xwH39G8Pj2H6voX3FjSpcJiiECPL92M6rg10o2QNwbTjN0meb6JCP1mgE31F5',charcol3 = 'NDwvEpj8FywqRf5RQj3Yu7yvtW9wNO1eTqakf9ku8hcbKhveGqBAx1xqNzemFXOlLqT005m0mEb7nMd3Co59h3r42Tq917uMxFFxLtx78P6vnkrsOw1yrl2lElv7sp' WHERE id = '44' ---TRANSACTION 0 36239217, ACTIVE 1539 sec, process no 13237, OS thread id 1172302176 fetching rows, thread declared inside InnoDB 456 mysql tables in use 1, locked 0 MySQL thread id 106, query id 17357367 localhost 127.0.0.1 root Sending data select avg(intcol1) from t1 Trx read view will not see trx with id >= 0 36239218, sees < 0 22505490 ---TRANSACTION 0 22505490, ACTIVE 2820 sec, process no 13237, OS thread id 1171769696 MySQL thread id 52, query id 4501676 localhost 127.0.0.1 root Trx read view will not see trx with id >= 0 22505491, sees < 0 22505491 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 194863 OS file reads, 5527811 OS file writes, 5487850 OS fsyncs 1 pending preads, 0 pending pwrites 293.58 reads/s, 16384 avg bytes/read, 27.18 writes/s, 26.95 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 2282801, used cells 9976, node heap has 16 buffer(s) 26.86 hash searches/s, 0.23 non-hash searches/s --- LOG --- Log sequence number 6 1936338042 Log flushed up to 6 1936338042 Last checkpoint at 6 1324092658 0 pending log writes, 0 pending chkp writes 5486752 log i/o's done, 26.77 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 1304889730; in additional pool allocated 11399168 Dictionary memory allocated 37240 Buffer pool size 70400 Free buffers 0 Database pages 70384 Modified db pages 22469 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages read 421147, created 497196, written 861125 293.71 reads/s, 0.95 creates/s, 26.18 writes/s Buffer pool hit rate 657 / 1000 -------------- ROW OPERATIONS -------------- 8 queries inside InnoDB, 43 queries in queue 3 read views open inside InnoDB Main thread process no. 13237, id 1157658976, state: purging Number of rows inserted 19998, updated 17352850, deleted 0, read 17482912 0.00 inserts/s, 26.95 updates/s, 0.00 deletes/s, 27.32 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set, 1 warning (0.02 sec)