mysql> show processlist; +-----+------+-----------------+--------+---------+------+---------------------------------+-------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+------+-----------------+--------+---------+------+---------------------------------+-------------------------------------------+ | 2 | root | localhost | NULL | Query | 0 | starting | show processlist | | 3 | root | localhost:54874 | sbtest | Query | 208 | updating | UPDATE sbtest8 SET k=k+1 WHERE id=467 | | 4 | root | localhost:54876 | sbtest | Query | 208 | updating | UPDATE sbtest8 SET k=k+1 WHERE id=356 | | 5 | root | localhost:54875 | sbtest | Query | 208 | updating | UPDATE sbtest3 SET k=k+1 WHERE id=296 | | 6 | root | localhost:54877 | sbtest | Query | 208 | query end | UPDATE sbtest5tmp SET k=k+1 WHERE id=431 | | 7 | root | localhost:54878 | sbtest | Query | 208 | Waiting for table metadata lock | UPDATE sbtest6 SET k=k+1 WHERE id=1 | | 8 | root | localhost:54879 | sbtest | Query | 208 | Waiting for table metadata lock | UPDATE sbtest6 SET k=k+1 WHERE id=107 | | 9 | root | localhost:54880 | sbtest | Query | 209 | Waiting for table metadata lock | UPDATE sbtest6 SET k=k+1 WHERE id=235 | | 10 | root | localhost:54881 | sbtest | Query | 208 | updating | UPDATE sbtest4tmp SET k=k+1 WHERE id=278 | | 11 | root | localhost:54882 | sbtest | Query | 208 | updating | UPDATE sbtest3 SET k=k+1 WHERE id=68 | | 12 | root | localhost:54883 | sbtest | Query | 208 | updating | UPDATE sbtest2tmp SET k=k+1 WHERE id=172 | | 13 | root | localhost:54884 | sbtest | Query | 209 | Waiting for table metadata lock | UPDATE sbtest6 SET k=k+1 WHERE id=440 | | 14 | root | localhost:54885 | sbtest | Query | 208 | updating | UPDATE sbtest3 SET k=k+1 WHERE id=282 | | 15 | root | localhost:54887 | sbtest | Query | 208 | updating | UPDATE sbtest4tmp SET k=k+1 WHERE id=319 | | 16 | root | localhost:54886 | sbtest | Query | 208 | updating | UPDATE sbtest2tmp SET k=k+1 WHERE id=261 | | 17 | root | localhost:54888 | sbtest | Query | 208 | updating | UPDATE sbtest1tmp SET k=k+1 WHERE id=495 | | 18 | root | localhost:54889 | sbtest | Query | 208 | updating | UPDATE sbtest5tmp SET k=k+1 WHERE id=434 | | 19 | root | localhost:54890 | sbtest | Query | 209 | Waiting for table metadata lock | UPDATE sbtest6 SET k=k+1 WHERE id=79 | | 20 | root | localhost:54891 | sbtest | Query | 208 | updating | UPDATE sbtest1tmp SET k=k+1 WHERE id=387 | | 21 | root | localhost:54892 | sbtest | Query | 208 | updating | UPDATE sbtest4tmp SET k=k+1 WHERE id=366 | | 22 | root | localhost:54893 | sbtest | Query | 209 | rename | ALTER TABLE sbtest6tmp RENAME sbtest6 | | 23 | root | localhost:54894 | sbtest | Query | 208 | updating | UPDATE sbtest8 SET k=k+1 WHERE id=152 | | 24 | root | localhost:54896 | sbtest | Query | 208 | Waiting for table metadata lock | UPDATE sbtest6 SET k=k+1 WHERE id=375 | | 25 | root | localhost:54897 | sbtest | Query | 208 | updating | UPDATE sbtest8 SET k=k+1 WHERE id=323 | | 26 | root | localhost:54895 | sbtest | Query | 208 | updating | UPDATE sbtest10tmp SET k=k+1 WHERE id=83 | | 27 | root | localhost:54898 | sbtest | Query | 208 | Waiting for table metadata lock | UPDATE sbtest6 SET k=k+1 WHERE id=348 | | 28 | root | localhost:54899 | sbtest | Query | 208 | updating | UPDATE sbtest5tmp SET k=k+1 WHERE id=7 | | 29 | root | localhost:54901 | sbtest | Query | 208 | updating | UPDATE sbtest3 SET k=k+1 WHERE id=343 | | 30 | root | localhost:54900 | sbtest | Query | 208 | Waiting for table metadata lock | UPDATE sbtest6 SET k=k+1 WHERE id=123 | | 31 | root | localhost:54902 | sbtest | Query | 208 | updating | UPDATE sbtest1tmp SET k=k+1 WHERE id=436 | | 32 | root | localhost:54903 | sbtest | Query | 209 | Waiting for table metadata lock | UPDATE sbtest6 SET k=k+1 WHERE id=119 | | 33 | root | localhost:54904 | sbtest | Query | 208 | updating | UPDATE sbtest10tmp SET k=k+1 WHERE id=281 | | 34 | root | localhost:54905 | sbtest | Query | 208 | Waiting for table metadata lock | UPDATE sbtest6 SET k=k+1 WHERE id=200 | | 35 | root | localhost:54906 | sbtest | Query | 208 | updating | UPDATE sbtest2tmp SET k=k+1 WHERE id=92 | | 36 | root | localhost:54907 | sbtest | Query | 208 | updating | UPDATE sbtest8 SET k=k+1 WHERE id=394 | | 37 | root | localhost:54908 | sbtest | Query | 208 | updating | UPDATE sbtest5tmp SET k=k+1 WHERE id=395 | | 38 | root | localhost:54909 | sbtest | Query | 208 | updating | UPDATE sbtest5tmp SET k=k+1 WHERE id=249 | | 39 | root | localhost:54910 | sbtest | Query | 208 | Waiting for table metadata lock | UPDATE sbtest6 SET k=k+1 WHERE id=425 | | 40 | root | localhost:54912 | sbtest | Query | 208 | updating | UPDATE sbtest4tmp SET k=k+1 WHERE id=133 | | 41 | root | localhost:54911 | sbtest | Query | 209 | Waiting for table metadata lock | UPDATE sbtest6 SET k=k+1 WHERE id=434 | | 42 | root | localhost:54913 | sbtest | Query | 208 | Waiting for table metadata lock | UPDATE sbtest6 SET k=k+1 WHERE id=347 | | 43 | root | localhost:54914 | sbtest | Query | 209 | Waiting for table metadata lock | UPDATE sbtest6 SET k=k+1 WHERE id=159 | | 44 | root | localhost:54915 | sbtest | Query | 208 | updating | UPDATE sbtest8 SET k=k+1 WHERE id=59 | | 45 | root | localhost:54916 | sbtest | Query | 208 | updating | UPDATE sbtest5tmp SET k=k+1 WHERE id=53 | | 46 | root | localhost:54917 | sbtest | Query | 209 | Waiting for table metadata lock | UPDATE sbtest6 SET k=k+1 WHERE id=492 | | 47 | root | localhost:54918 | sbtest | Query | 208 | Waiting for table metadata lock | UPDATE sbtest6 SET k=k+1 WHERE id=332 | | 48 | root | localhost:54920 | sbtest | Query | 208 | updating | UPDATE sbtest2tmp SET k=k+1 WHERE id=6 | | 49 | root | localhost:54919 | sbtest | Query | 208 | updating | UPDATE sbtest5tmp SET k=k+1 WHERE id=347 | | 50 | root | localhost:54922 | sbtest | Query | 208 | updating | UPDATE sbtest9 SET k=k+1 WHERE id=276 | | 51 | root | localhost:54921 | sbtest | Query | 208 | updating | UPDATE sbtest3 SET k=k+1 WHERE id=175 | | 52 | root | localhost:54923 | sbtest | Query | 209 | Waiting for table metadata lock | UPDATE sbtest6 SET k=k+1 WHERE id=477 | | 53 | root | localhost:54924 | sbtest | Query | 208 | Waiting for table metadata lock | UPDATE sbtest6 SET k=k+1 WHERE id=14 | | 54 | root | localhost:54925 | sbtest | Query | 208 | updating | UPDATE sbtest5tmp SET k=k+1 WHERE id=152 | | 55 | root | localhost:54926 | sbtest | Query | 208 | updating | UPDATE sbtest10tmp SET k=k+1 WHERE id=192 | | 56 | root | localhost:54927 | sbtest | Query | 208 | Waiting for table metadata lock | UPDATE sbtest6 SET k=k+1 WHERE id=412 | | 57 | root | localhost:54928 | sbtest | Query | 208 | updating | UPDATE sbtest8 SET k=k+1 WHERE id=117 | | 58 | root | localhost:54929 | sbtest | Query | 208 | updating | UPDATE sbtest3 SET k=k+1 WHERE id=386 | | 59 | root | localhost:54930 | sbtest | Query | 208 | Waiting for table metadata lock | UPDATE sbtest6 SET k=k+1 WHERE id=409 | | 60 | root | localhost:54931 | sbtest | Query | 208 | updating | UPDATE sbtest2tmp SET k=k+1 WHERE id=442 | | 61 | root | localhost:54933 | sbtest | Query | 208 | Waiting for table metadata lock | UPDATE sbtest6 SET k=k+1 WHERE id=287 | | 62 | root | localhost:54932 | sbtest | Query | 208 | updating | UPDATE sbtest10tmp SET k=k+1 WHERE id=346 | | 63 | root | localhost:54934 | sbtest | Query | 208 | updating | UPDATE sbtest9 SET k=k+1 WHERE id=136 | | 64 | root | localhost:54935 | sbtest | Query | 209 | Waiting for table metadata lock | UPDATE sbtest6 SET k=k+1 WHERE id=81 | | 65 | root | localhost:54936 | sbtest | Query | 208 | updating | UPDATE sbtest5tmp SET k=k+1 WHERE id=191 | | 66 | root | localhost:54937 | sbtest | Query | 208 | query end | UPDATE sbtest1tmp SET k=k+1 WHERE id=280 |