mysql> show processlist; +-----+------+-----------------+-----------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+------+-----------------+-----------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ | 52 | root | localhost:48195 | mysqlslap | Sleep | 1996 | | NULL | | 53 | root | localhost:48197 | mysqlslap | Sleep | 1928 | | NULL | | 55 | root | localhost:48217 | mysqlslap | Sleep | 1555 | | NULL | | 56 | root | localhost:48218 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 116314197,intcol2 = 805287600,charcol1 = 'e8YWNpN1C9JgA6T6SHI3vdx1lw4tC2liAH | | 57 | root | localhost:48219 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 1839719074,intcol2 = 1147388315,charcol1 = 'jbPuYPJuWuAF3FKMtuKwCtCBdruTJKwu | | 58 | root | localhost:48220 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 1407841593,intcol2 = 32683953,charcol1 = 'YZeAmRm1NWuhtPpG3P5nRrBWOJXYy46WWk | | 59 | root | localhost:48221 | mysqlslap | Query | 28 | Updating | UPDATE t1 SET intcol1 = 614980131,intcol2 = 2027947119,charcol1 = '4xMpYR8w8o74pPs3Q0ZXgAAzy9rtNaOJO | | 60 | root | localhost:48222 | mysqlslap | Query | 52 | Updating | UPDATE t1 SET intcol1 = 1839719074,intcol2 = 1147388315,charcol1 = 'jbPuYPJuWuAF3FKMtuKwCtCBdruTJKwu | | 61 | root | localhost:48223 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 2126558185,intcol2 = 773273718,charcol1 = 'Y88N07to033m2XEIzHzMJsHuXTL2GeChe | | 62 | root | localhost:48224 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 1322166549,intcol2 = 823399162,charcol1 = '7ugNokudvtyn2CnJQmEMBO76N3yqZzCZt | | 63 | root | localhost:48225 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 1407841593,intcol2 = 32683953,charcol1 = 'YZeAmRm1NWuhtPpG3P5nRrBWOJXYy46WWk | | 64 | root | localhost:48226 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 1576223060,intcol2 = 942232734,charcol1 = 'nHujWOi8H3SwwB0cewKe8d5AyZL6EZ01q | | 65 | root | localhost:48227 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 1576223060,intcol2 = 942232734,charcol1 = 'nHujWOi8H3SwwB0cewKe8d5AyZL6EZ01q | | 66 | root | localhost:48228 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 1407841593,intcol2 = 32683953,charcol1 = 'YZeAmRm1NWuhtPpG3P5nRrBWOJXYy46WWk | | 67 | root | localhost:48229 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 614980131,intcol2 = 2027947119,charcol1 = '4xMpYR8w8o74pPs3Q0ZXgAAzy9rtNaOJO | | 68 | root | localhost:48230 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 614980131,intcol2 = 2027947119,charcol1 = '4xMpYR8w8o74pPs3Q0ZXgAAzy9rtNaOJO | | 69 | root | localhost:48231 | mysqlslap | Query | 29 | Updating | UPDATE t1 SET intcol1 = 1233983202,intcol2 = 789373855,charcol1 = 'jdtPbBILRQyiu7nZN3RdI96aQOP4Y0z7d | | 70 | root | localhost:48232 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 1322166549,intcol2 = 823399162,charcol1 = '7ugNokudvtyn2CnJQmEMBO76N3yqZzCZt | | 71 | root | localhost:48233 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 1322166549,intcol2 = 823399162,charcol1 = '7ugNokudvtyn2CnJQmEMBO76N3yqZzCZt | | 72 | root | localhost:48234 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 2101913295,intcol2 = 1100418235,charcol1 = 'XQ0K9x30cYaFq2RvMZzKHKgmxy4uKBpr | | 73 | root | localhost:48235 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 1471079933,intcol2 = 266531426,charcol1 = 'a1vMmjn2ZKuaFxe9yR02BJeO5IKMg5o67 | | 74 | root | localhost:48236 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 1407841593,intcol2 = 32683953,charcol1 = 'YZeAmRm1NWuhtPpG3P5nRrBWOJXYy46WWk | | 75 | root | localhost:48237 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 601509202,intcol2 = 1905068689,charcol1 = '5dfQWSPWlOQP0HHO5AMpvHa22L9mBXR80 | | 76 | root | localhost:48238 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 1322166549,intcol2 = 823399162,charcol1 = '7ugNokudvtyn2CnJQmEMBO76N3yqZzCZt | | 77 | root | localhost:48239 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 601509202,intcol2 = 1905068689,charcol1 = '5dfQWSPWlOQP0HHO5AMpvHa22L9mBXR80 | | 78 | root | localhost:48240 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 1233983202,intcol2 = 789373855,charcol1 = 'jdtPbBILRQyiu7nZN3RdI96aQOP4Y0z7d | | 79 | root | localhost:48241 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 1839719074,intcol2 = 1147388315,charcol1 = 'jbPuYPJuWuAF3FKMtuKwCtCBdruTJKwu | | 80 | root | localhost:48242 | mysqlslap | Query | 28 | Updating | UPDATE t1 SET intcol1 = 1576223060,intcol2 = 942232734,charcol1 = 'nHujWOi8H3SwwB0cewKe8d5AyZL6EZ01q | | 81 | root | localhost:48243 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 1322166549,intcol2 = 823399162,charcol1 = '7ugNokudvtyn2CnJQmEMBO76N3yqZzCZt | | 82 | root | localhost:48244 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 601509202,intcol2 = 1905068689,charcol1 = '5dfQWSPWlOQP0HHO5AMpvHa22L9mBXR80 | | 83 | root | localhost:48245 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 1471079933,intcol2 = 266531426,charcol1 = 'a1vMmjn2ZKuaFxe9yR02BJeO5IKMg5o67 | | 84 | root | localhost:48246 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 1407841593,intcol2 = 32683953,charcol1 = 'YZeAmRm1NWuhtPpG3P5nRrBWOJXYy46WWk | | 85 | root | localhost:48247 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 614980131,intcol2 = 2027947119,charcol1 = '4xMpYR8w8o74pPs3Q0ZXgAAzy9rtNaOJO | | 86 | root | localhost:48248 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 116314197,intcol2 = 805287600,charcol1 = 'e8YWNpN1C9JgA6T6SHI3vdx1lw4tC2liAH | | 87 | root | localhost:48249 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 1407841593,intcol2 = 32683953,charcol1 = 'YZeAmRm1NWuhtPpG3P5nRrBWOJXYy46WWk | | 88 | root | localhost:48250 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 614980131,intcol2 = 2027947119,charcol1 = '4xMpYR8w8o74pPs3Q0ZXgAAzy9rtNaOJO | | 89 | root | localhost:48251 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 2126558185,intcol2 = 773273718,charcol1 = 'Y88N07to033m2XEIzHzMJsHuXTL2GeChe | | 90 | root | localhost:48252 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 2126558185,intcol2 = 773273718,charcol1 = 'Y88N07to033m2XEIzHzMJsHuXTL2GeChe | | 91 | root | localhost:48253 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 116314197,intcol2 = 805287600,charcol1 = 'e8YWNpN1C9JgA6T6SHI3vdx1lw4tC2liAH | | 92 | root | localhost:48254 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 614980131,intcol2 = 2027947119,charcol1 = '4xMpYR8w8o74pPs3Q0ZXgAAzy9rtNaOJO | | 93 | root | localhost:48255 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 1839719074,intcol2 = 1147388315,charcol1 = 'jbPuYPJuWuAF3FKMtuKwCtCBdruTJKwu | | 94 | root | localhost:48256 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 2101913295,intcol2 = 1100418235,charcol1 = 'XQ0K9x30cYaFq2RvMZzKHKgmxy4uKBpr | | 95 | root | localhost:48257 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 614980131,intcol2 = 2027947119,charcol1 = '4xMpYR8w8o74pPs3Q0ZXgAAzy9rtNaOJO | | 96 | root | localhost:48258 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 1407841593,intcol2 = 32683953,charcol1 = 'YZeAmRm1NWuhtPpG3P5nRrBWOJXYy46WWk | | 97 | root | localhost:48259 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 116314197,intcol2 = 805287600,charcol1 = 'e8YWNpN1C9JgA6T6SHI3vdx1lw4tC2liAH | | 98 | root | localhost:48260 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 614980131,intcol2 = 2027947119,charcol1 = '4xMpYR8w8o74pPs3Q0ZXgAAzy9rtNaOJO | | 99 | root | localhost:48261 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 601509202,intcol2 = 1905068689,charcol1 = '5dfQWSPWlOQP0HHO5AMpvHa22L9mBXR80 | | 100 | root | localhost:48262 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 1576223060,intcol2 = 942232734,charcol1 = 'nHujWOi8H3SwwB0cewKe8d5AyZL6EZ01q | | 101 | root | localhost:48263 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 1839719074,intcol2 = 1147388315,charcol1 = 'jbPuYPJuWuAF3FKMtuKwCtCBdruTJKwu | | 102 | root | localhost:48264 | mysqlslap | Query | 28 | Updating | UPDATE t1 SET intcol1 = 1233983202,intcol2 = 789373855,charcol1 = 'jdtPbBILRQyiu7nZN3RdI96aQOP4Y0z7d | | 103 | root | localhost:48265 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 1576223060,intcol2 = 942232734,charcol1 = 'nHujWOi8H3SwwB0cewKe8d5AyZL6EZ01q | | 104 | root | localhost:48266 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 1576223060,intcol2 = 942232734,charcol1 = 'nHujWOi8H3SwwB0cewKe8d5AyZL6EZ01q | | 105 | root | localhost:48267 | mysqlslap | Query | 5 | Updating | UPDATE t1 SET intcol1 = 1322166549,intcol2 = 823399162,charcol1 = '7ugNokudvtyn2CnJQmEMBO76N3yqZzCZt | | 106 | root | localhost:48272 | mysqlslap | Query | 138 | Sending data | select avg(intcol1) from t1 | | 107 | root | localhost:48280 | mysqlslap | Query | 0 | NULL | show processlist | +-----+------+-----------------+-----------+---------+------+--------------+------------------------------------------------------------------------------------------------------+ 55 rows in set (0.01 sec)