Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 NULL NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4958353 AND 4958353+99 ORDER BY c 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 freeing items SELECT c FROM sbtest2 WHERE id=5047297 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 NULL NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013938 root localhost NULL Query 0 NULL show full processlist 1344567384 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 Opening tables INSERT INTO sbtest1 (id, k, c, pad) VALUES (4971409, 4997561, '62068279791-59097374362-85402722318-92261386064-55299346867-28464254555-90290753727-64575040458-73375870353-81051208269', '71056324067-53689796692-75869097151-18197744571-66620541637') 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 closing tables SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5605933 AND 5605933+99 ORDER BY c 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Opening tables SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5027164 AND 5027164+99 ORDER BY c 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 Opening tables SELECT SUM(K) FROM sbtest2 WHERE id BETWEEN 5013258 AND 5013258+99 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 closing tables SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4982220 AND 4982220+99 ORDER BY c 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 Opening tables SELECT c FROM sbtest2 WHERE id=3815402 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 Opening tables SELECT SUM(K) FROM sbtest2 WHERE id BETWEEN 4672161 AND 4672161+99 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 Opening tables SELECT c FROM sbtest2 WHERE id=4972822 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 Opening tables SELECT c FROM sbtest2 WHERE id=4998115 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Opening tables SELECT c FROM sbtest2 WHERE id BETWEEN 5776634 AND 5776634+99 ORDER BY c 1013895 sysbench 127.0.0.1:33189 sbtest Query 0 Opening tables SELECT c FROM sbtest1 WHERE id=4978181 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 closing tables SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5046507 AND 5046507+99 ORDER BY c 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 Opening tables SELECT c FROM sbtest1 WHERE id=5007814 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 Opening tables SELECT c FROM sbtest2 WHERE id=4967203 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Opening tables SELECT c FROM sbtest1 WHERE id=4962382 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 closing tables SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4958353 AND 4958353+99 ORDER BY c 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 Opening tables SELECT c FROM sbtest2 WHERE id=5024576 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 Opening tables SELECT c FROM sbtest2 WHERE id BETWEEN 5010204 AND 5010204+99 ORDER BY c 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 closing tables SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5001668 AND 5001668+99 ORDER BY c 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Opening tables SELECT SUM(K) FROM sbtest2 WHERE id BETWEEN 5037925 AND 5037925+99 1013939 root localhost test Query 0 NULL drop table innodb_monitor 1013941 root localhost NULL Query 0 NULL show full processlist 1344567384 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Sending data SELECT SUM(K) FROM sbtest2 WHERE id BETWEEN 3360092 AND 3360092+99 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 NULL NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4978195 AND 4978195+99 ORDER BY c 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 freeing items SELECT c FROM sbtest2 WHERE id=4978634 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5031607 AND 5031607+99 ORDER BY c 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4996557 AND 4996557+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 statistics SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 6172422 AND 6172422+99 ORDER BY c 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5014409 AND 5014409+99 ORDER BY c 1013943 root localhost NULL Query 0 NULL show full processlist 1344567385 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 NULL NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 cleaning up NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 NULL NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 NULL NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013945 root localhost NULL Query 0 NULL show full processlist 1344567385 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 Sending data SELECT c FROM sbtest2 WHERE id BETWEEN 4956476 AND 4956476+99 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4982241 AND 4982241+99 ORDER BY c 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 Sending data SELECT c FROM sbtest1 WHERE id BETWEEN 5678723 AND 5678723+99 ORDER BY c 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 NULL SELECT c FROM sbtest1 WHERE id=3405126 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4985092 AND 4985092+99 ORDER BY c 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5697281 AND 5697281+99 ORDER BY c 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013947 root localhost NULL Query 0 NULL show full processlist 1344567386 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Sorting result SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4968428 AND 4968428+99 ORDER BY c 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5046520 AND 5046520+99 ORDER BY c 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5064473 AND 5064473+99 ORDER BY c 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 Sending data SELECT c FROM sbtest2 WHERE id BETWEEN 4317051 AND 4317051+99 ORDER BY c 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Sorting result SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4955661 AND 4955661+99 ORDER BY c 1013949 root localhost NULL Query 0 NULL show full processlist 1344567386 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5346956 AND 5346956+99 ORDER BY c 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 NULL COMMIT 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Updating UPDATE sbtest1 SET k=k+1 WHERE id=5032008 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 Sending data SELECT SUM(K) FROM sbtest2 WHERE id BETWEEN 4994655 AND 4994655+99 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4987513 AND 4987513+99 ORDER BY c 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 Sorting result SELECT c FROM sbtest1 WHERE id BETWEEN 4977241 AND 4977241+99 ORDER BY c 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5036926 AND 5036926+99 ORDER BY c 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 NULL COMMIT 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 update INSERT INTO sbtest1 (id, k, c, pad) VALUES (5003010, 4986269, '18418556777-98570269992-73459815388-80571033515-62997939969-79702444228-89984462955-62996523177-97355809353-01019748003', '23659611241-78782119657-97396523984-09625302327-31181763699') 1013951 root localhost NULL Query 0 NULL show full processlist 1344567387 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 optimizing SELECT c FROM sbtest2 WHERE id=4998253 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 optimizing SELECT c FROM sbtest2 WHERE id=4953833 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 statistics SELECT c FROM sbtest1 WHERE id=5020181 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Query 0 statistics SELECT SUM(K) FROM sbtest2 WHERE id BETWEEN 5045229 AND 5045229+99 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 NULL SELECT c FROM sbtest1 WHERE id=4936758 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 Sorting result SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5357069 AND 5357069+99 ORDER BY c 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013953 root localhost NULL Query 0 NULL show full processlist 1344567387 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 3913384 AND 3913384+99 ORDER BY c 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4978502 AND 4978502+99 ORDER BY c 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 statistics SELECT c FROM sbtest1 WHERE id=5030677 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4995095 AND 4995095+99 ORDER BY c 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4724453 AND 4724453+99 ORDER BY c 1013955 root localhost NULL Query 0 NULL show full processlist 1344567388 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5196833 AND 5196833+99 ORDER BY c 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Query 0 Opening tables SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5014211 AND 5014211+99 ORDER BY c 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5022790 AND 5022790+99 ORDER BY c 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5038174 AND 5038174+99 ORDER BY c 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013957 root localhost NULL Query 0 NULL show full processlist 1344567388 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 NULL INSERT INTO sbtest1 (id, k, c, pad) VALUES (4970288, 5185851, '16435100470-37267243474-99867306265-48523422178-37062174055-78154354523-71532303969-15216108995-71725475491-66042995670', '99129437923-08387169738-07469424397-53965222974-11814882701') 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 cleaning up NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5815519 AND 5815519+99 ORDER BY c 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4965921 AND 4965921+99 ORDER BY c 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Sorting result SELECT c FROM sbtest1 WHERE id BETWEEN 4987731 AND 4987731+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Sending data SELECT c FROM sbtest2 WHERE id BETWEEN 5019819 AND 5019819+99 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 freeing items SELECT c FROM sbtest2 WHERE id=4622052 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 NULL COMMIT 1013959 root localhost NULL Query 0 NULL show full processlist 1344567389 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4483052 AND 4483052+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013961 root localhost NULL Query 0 NULL show full processlist 1344567390 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 NULL SELECT c FROM sbtest1 WHERE id BETWEEN 5698100 AND 5698100+99 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 updating DELETE FROM sbtest1 WHERE id=5019388 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013962 root localhost NULL Query 0 NULL show full processlist 1344567390 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 update INSERT INTO sbtest1 (id, k, c, pad) VALUES (5223027, 5040557, '48132080004-49231054594-74757331250-54436147838-52684581747-73304966292-17497966741-97481799472-41595870502-75402114868', '62311394843-27087715806-00506479783-70369879205-17337592948') 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4964861 AND 4964861+99 ORDER BY c 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 cleaning up NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 cleaning up NULL 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 statistics SELECT c FROM sbtest2 WHERE id=5040447 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 Updating UPDATE sbtest1 SET k=k+1 WHERE id=5042882 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 statistics SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 3141642 AND 3141642+99 ORDER BY c 1013895 sysbench 127.0.0.1:33189 sbtest Query 0 preparing SELECT c FROM sbtest1 WHERE id=4963153 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4977924 AND 4977924+99 ORDER BY c 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4323341 AND 4323341+99 ORDER BY c 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013963 root localhost NULL Query 0 NULL show full processlist 1344567391 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Updating UPDATE sbtest2 SET k=k+1 WHERE id=5819043 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4975032 AND 4975032+99 ORDER BY c 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5010889 AND 5010889+99 ORDER BY c 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4966728 AND 4966728+99 ORDER BY c 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5049039 AND 5049039+99 ORDER BY c 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 Sorting result SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5638568 AND 5638568+99 ORDER BY c 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4596311 AND 4596311+99 ORDER BY c 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5049273 AND 5049273+99 ORDER BY c 1013964 root localhost NULL Query 0 NULL show full processlist 1344567391 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4950996 AND 4950996+99 ORDER BY c 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5312637 AND 5312637+99 ORDER BY c 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 optimizing SELECT c FROM sbtest1 WHERE id BETWEEN 4980537 AND 4980537+99 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 Sorting result SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 3275516 AND 3275516+99 ORDER BY c 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013965 root localhost NULL Query 0 NULL show full processlist 1344567392 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 cleaning up NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 NULL NULL 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4283821 AND 4283821+99 ORDER BY c 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4962035 AND 4962035+99 ORDER BY c 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 cleaning up NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5049611 AND 5049611+99 ORDER BY c 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 end DELETE FROM sbtest1 WHERE id=5667269 1013895 sysbench 127.0.0.1:33189 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4952308 AND 4952308+99 ORDER BY c 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 6932163 AND 6932163+99 ORDER BY c 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 Sending data SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 6051886 AND 6051886+99 ORDER BY c 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013966 root localhost NULL Query 0 NULL show full processlist 1344567392 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 cleaning up NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5046018 AND 5046018+99 ORDER BY c 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 Creating tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5032563 AND 5032563+99 ORDER BY c 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5007314 AND 5007314+99 ORDER BY c 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4977241 AND 4977241+99 ORDER BY c 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4951361 AND 4951361+99 ORDER BY c 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4990200 AND 4990200+99 ORDER BY c 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Sending data SELECT SUM(K) FROM sbtest2 WHERE id BETWEEN 6036452 AND 6036452+99 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 Sorting result SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4127381 AND 4127381+99 ORDER BY c 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013967 root localhost NULL Query 0 NULL show full processlist 1344567393 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4978507 AND 4978507+99 ORDER BY c 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5010912 AND 5010912+99 ORDER BY c 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5404029 AND 5404029+99 ORDER BY c 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 Sorting result SELECT c FROM sbtest1 WHERE id BETWEEN 4959994 AND 4959994+99 ORDER BY c 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013968 root localhost NULL Query 0 NULL show full processlist 1344567393 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 NULL NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 cleaning up NULL 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5026364 AND 5026364+99 ORDER BY c 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5049671 AND 5049671+99 ORDER BY c 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Query 0 statistics SELECT c FROM sbtest1 WHERE id BETWEEN 5115424 AND 5115424+99 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 statistics SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4977811 AND 4977811+99 ORDER BY c 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 Sorting result SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 6339611 AND 6339611+99 ORDER BY c 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013969 root localhost NULL Query 0 NULL show full processlist 1344567394 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 NULL NULL 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 update INSERT INTO sbtest2 (id, k, c, pad) VALUES (5020964, 5007686, '78110435459-60474657423-68354916582-35121830777-94913005137-58996503735-20000421989-87087520138-40329729193-60836925288', '17723538198-28480414306-26938310873-53898884748-47443755808') 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 statistics SELECT c FROM sbtest2 WHERE id BETWEEN 4994388 AND 4994388+99 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 statistics SELECT c FROM sbtest1 WHERE id=5033321 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5758095 AND 5758095+99 ORDER BY c 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013970 root localhost NULL Query 0 NULL show full processlist 1344567394 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5005748 AND 5005748+99 ORDER BY c 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5045827 AND 5045827+99 ORDER BY c 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 preparing SELECT SUM(K) FROM sbtest2 WHERE id BETWEEN 4991333 AND 4991333+99 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4977691 AND 4977691+99 ORDER BY c 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5039582 AND 5039582+99 ORDER BY c 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4994656 AND 4994656+99 ORDER BY c 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 Sorting result SELECT c FROM sbtest1 WHERE id BETWEEN 5604152 AND 5604152+99 ORDER BY c 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013971 root localhost NULL Query 0 NULL show full processlist 1344567395 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4994925 AND 4994925+99 ORDER BY c 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5025908 AND 5025908+99 ORDER BY c 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 cleaning up NULL 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 System lock SELECT c FROM sbtest1 WHERE id=4997439 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013972 root localhost NULL Query 0 NULL show full processlist 1344567395 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5143103 AND 5143103+99 ORDER BY c 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4984074 AND 4984074+99 ORDER BY c 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4983391 AND 4983391+99 ORDER BY c 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 statistics SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5010860 AND 5010860+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 Updating UPDATE sbtest1 SET k=k+1 WHERE id=5007334 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013973 root localhost NULL Query 0 NULL show full processlist 1344567396 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 update INSERT INTO sbtest1 (id, k, c, pad) VALUES (4975773, 4992836, '73225934072-69350198129-29906923601-91925873961-53114637602-34223244445-32677305527-06026760920-93568072129-01118734225', '58990857291-09308621924-46237130867-34068958001-19420512562') 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 NULL COMMIT 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 NULL COMMIT 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 init SELECT c FROM sbtest2 WHERE id=5483932 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 Sorting result SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4988202 AND 4988202+99 ORDER BY c 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 update INSERT INTO sbtest2 (id, k, c, pad) VALUES (5033491, 5029608, '82851124891-37426839791-58041411751-98041415451-48430451747-17312395228-02537188633-01246880320-59735849936-20171421884', '74218683722-89992275534-56687857334-16138201340-31042286122') 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013974 root localhost NULL Query 0 NULL show full processlist 1344567396 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5095226 AND 5095226+99 ORDER BY c 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 Sending data SELECT c FROM sbtest2 WHERE id BETWEEN 5582461 AND 5582461+99 ORDER BY c 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 update INSERT INTO sbtest2 (id, k, c, pad) VALUES (5046727, 4977602, '42540138923-22967550421-55008594021-53168619286-59882087328-70572222072-57549418035-31890155781-96253975952-07256806331', '42193392881-64118216152-66291266916-07867024117-69759873781') 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4952956 AND 4952956+99 ORDER BY c 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5006822 AND 5006822+99 ORDER BY c 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 Updating UPDATE sbtest1 SET k=k+1 WHERE id=5020748 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013975 root localhost NULL Query 0 NULL show full processlist 1344567397 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 init SELECT c FROM sbtest1 WHERE id=4964250 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5902097 AND 5902097+99 ORDER BY c 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4950675 AND 4950675+99 ORDER BY c 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013976 root localhost NULL Query 0 NULL show full processlist 1344567397 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 cleaning up NULL 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 NULL COMMIT 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Writing to net UPDATE sbtest1 SET k=k+1 WHERE id=5586131 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 Sorting result SELECT c FROM sbtest1 WHERE id BETWEEN 4968986 AND 4968986+99 ORDER BY c 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 Sending data SELECT c FROM sbtest1 WHERE id BETWEEN 5024579 AND 5024579+99 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4992419 AND 4992419+99 ORDER BY c 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013977 root localhost NULL Query 0 NULL show full processlist 1344567398 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 cleaning up NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Updating UPDATE sbtest2 SET k=k+1 WHERE id=4952160 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 NULL COMMIT 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 Sending data SELECT c FROM sbtest2 WHERE id=4990233 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Sorting result SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4540949 AND 4540949+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4992791 AND 4992791+99 ORDER BY c 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 init SELECT c FROM sbtest2 WHERE id=4999000 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013978 root localhost NULL Query 0 NULL show full processlist 1344567398 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5020849 AND 5020849+99 ORDER BY c 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 Writing to net SELECT c FROM sbtest1 WHERE id=5023833 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 Sending data SELECT SUM(K) FROM sbtest1 WHERE id BETWEEN 5039367 AND 5039367+99 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 NULL COMMIT 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5214755 AND 5214755+99 ORDER BY c 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 statistics SELECT c FROM sbtest2 WHERE id BETWEEN 5030913 AND 5030913+99 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5609888 AND 5609888+99 ORDER BY c 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013979 root localhost NULL Query 0 NULL show full processlist 1344567399 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 cleaning up NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 Sorting result SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5015037 AND 5015037+99 ORDER BY c 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 cleaning up NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Sending data SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5034292 AND 5034292+99 ORDER BY c 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 Sorting result SELECT c FROM sbtest1 WHERE id BETWEEN 6599581 AND 6599581+99 ORDER BY c 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Sending data SELECT SUM(K) FROM sbtest2 WHERE id BETWEEN 4987187 AND 4987187+99 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 end SELECT c FROM sbtest2 WHERE id BETWEEN 6255725 AND 6255725+99 ORDER BY c 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 NULL NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013980 root localhost NULL Query 0 NULL show full processlist 1344567399 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Sending data SELECT c FROM sbtest2 WHERE id BETWEEN 4950466 AND 4950466+99 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 cleaning up NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 cleaning up NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5022346 AND 5022346+99 ORDER BY c 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4986976 AND 4986976+99 ORDER BY c 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 Sending data SELECT c FROM sbtest2 WHERE id BETWEEN 4988861 AND 4988861+99 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4974700 AND 4974700+99 ORDER BY c 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013981 root localhost NULL Query 0 NULL show full processlist 1344567400 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5025784 AND 5025784+99 ORDER BY c 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 NULL NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Sending data SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4992944 AND 4992944+99 ORDER BY c 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 Sorting result SELECT c FROM sbtest2 WHERE id BETWEEN 4996773 AND 4996773+99 ORDER BY c 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013982 root localhost NULL Query 0 NULL show full processlist 1344567400 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 Sorting result SELECT c FROM sbtest1 WHERE id BETWEEN 5445805 AND 5445805+99 ORDER BY c 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 7359643 AND 7359643+99 ORDER BY c 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5030283 AND 5030283+99 ORDER BY c 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5951341 AND 5951341+99 ORDER BY c 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013983 root localhost NULL Query 0 NULL show full processlist 1344567401 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4955535 AND 4955535+99 ORDER BY c 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5699407 AND 5699407+99 ORDER BY c 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 Sorting result SELECT c FROM sbtest2 WHERE id BETWEEN 5006611 AND 5006611+99 ORDER BY c 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5014034 AND 5014034+99 ORDER BY c 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 cleaning up NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5861742 AND 5861742+99 ORDER BY c 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4998355 AND 4998355+99 ORDER BY c 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 NULL COMMIT 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 statistics SELECT c FROM sbtest1 WHERE id=4955912 1013984 root localhost NULL Query 0 NULL show full processlist 1344567401 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 Sending data SELECT c FROM sbtest1 WHERE id BETWEEN 4950418 AND 4950418+99 ORDER BY c 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5035194 AND 5035194+99 ORDER BY c 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5010522 AND 5010522+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4992367 AND 4992367+99 ORDER BY c 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013985 root localhost NULL Query 0 NULL show full processlist 1344567402 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4411482 AND 4411482+99 ORDER BY c 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4966368 AND 4966368+99 ORDER BY c 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4985354 AND 4985354+99 ORDER BY c 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 Sorting result SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5003639 AND 5003639+99 ORDER BY c 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4960512 AND 4960512+99 ORDER BY c 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013986 root localhost NULL Query 0 NULL show full processlist 1344567402 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 cleaning up NULL 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5008803 AND 5008803+99 ORDER BY c 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4976355 AND 4976355+99 ORDER BY c 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4966719 AND 4966719+99 ORDER BY c 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013987 root localhost NULL Query 0 NULL show full processlist 1344567403 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5049363 AND 5049363+99 ORDER BY c 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5003183 AND 5003183+99 ORDER BY c 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 end UPDATE sbtest2 SET k=k+1 WHERE id=5025931 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4983520 AND 4983520+99 ORDER BY c 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013988 root localhost NULL Query 0 NULL show full processlist 1344567403 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 init SELECT c FROM sbtest2 WHERE id=4951634 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 NULL NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 statistics SELECT c FROM sbtest1 WHERE id BETWEEN 4990096 AND 4990096+99 ORDER BY c 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 Updating UPDATE sbtest2 SET k=k+1 WHERE id=4992445 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5032126 AND 5032126+99 ORDER BY c 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5935037 AND 5935037+99 ORDER BY c 1013989 root localhost NULL Query 0 NULL show full processlist 1344567404 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4964410 AND 4964410+99 ORDER BY c 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4378203 AND 4378203+99 ORDER BY c 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013990 root localhost NULL Query 0 NULL show full processlist 1344567404 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 cleaning up NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 cleaning up NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 NULL COMMIT 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 Updating UPDATE sbtest1 SET k=k+1 WHERE id=4953238 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 Updating UPDATE sbtest2 SET c='93179954812-02229462880-28441697444-10971853699-94656326395-72992706599-56209218268-55156350115-98525401249-55742980329' WHERE id=4979994 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 statistics SELECT c FROM sbtest1 WHERE id BETWEEN 5035739 AND 5035739+99 ORDER BY c 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013991 root localhost NULL Query 0 NULL show full processlist 1344567405 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 NULL COMMIT 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4960726 AND 4960726+99 ORDER BY c 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 Writing to net SELECT c FROM sbtest2 WHERE id=4675639 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 NULL SELECT c FROM sbtest2 WHERE id=5020476 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4489991 AND 4489991+99 ORDER BY c 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4558975 AND 4558975+99 ORDER BY c 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 3793754 AND 3793754+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 NULL NULL 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4960071 AND 4960071+99 ORDER BY c 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5010964 AND 5010964+99 ORDER BY c 1013992 root localhost NULL Query 0 NULL show full processlist 1344567405 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4970484 AND 4970484+99 ORDER BY c 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 Updating UPDATE sbtest1 SET c='56721414925-19183332496-32920080346-39607588591-61906250818-16723709337-10160834928-28286296538-83202853450-63977087358' WHERE id=5636536 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4990528 AND 4990528+99 ORDER BY c 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 update INSERT INTO sbtest2 (id, k, c, pad) VALUES (4985949, 5046528, '35372222480-37707337785-09985564110-33428916411-94156869408-42113243758-81585068899-29655184310-74835064898-24745759716', '00292923001-81557668919-82701306190-90222801672-78207895313') 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 NULL NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Sending data SELECT c FROM sbtest2 WHERE id BETWEEN 5018526 AND 5018526+99 ORDER BY c 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5003358 AND 5003358+99 ORDER BY c 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013993 root localhost NULL Query 0 NULL show full processlist 1344567406 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4952344 AND 4952344+99 ORDER BY c 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 Sorting result SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5011443 AND 5011443+99 ORDER BY c 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4995604 AND 4995604+99 ORDER BY c 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4996215 AND 4996215+99 ORDER BY c 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4977335 AND 4977335+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4969254 AND 4969254+99 ORDER BY c 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013994 root localhost NULL Query 0 NULL show full processlist 1344567406 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5015950 AND 5015950+99 ORDER BY c 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4984055 AND 4984055+99 ORDER BY c 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 6550792 AND 6550792+99 ORDER BY c 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Sending data SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4960765 AND 4960765+99 ORDER BY c 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5038340 AND 5038340+99 ORDER BY c 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 NULL SELECT c FROM sbtest1 WHERE id=5002882 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 NULL SELECT c FROM sbtest1 WHERE id=4965986 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 NULL SELECT c FROM sbtest1 WHERE id=5031844 1013995 root localhost NULL Query 0 NULL show full processlist 1344567407 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 Sending data SELECT c FROM sbtest2 WHERE id BETWEEN 5021468 AND 5021468+99 ORDER BY c 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5019418 AND 5019418+99 ORDER BY c 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4958140 AND 4958140+99 ORDER BY c 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 NULL COMMIT 1013895 sysbench 127.0.0.1:33189 sbtest Query 0 Sending data SELECT c FROM sbtest2 WHERE id BETWEEN 4989184 AND 4989184+99 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 Sending data SELECT c FROM sbtest2 WHERE id=4970092 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 2305402 AND 2305402+99 ORDER BY c 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013996 root localhost NULL Query 0 NULL show full processlist 1344567407 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5047337 AND 5047337+99 ORDER BY c 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4168222 AND 4168222+99 ORDER BY c 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Query 0 Opening tables SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5020847 AND 5020847+99 ORDER BY c 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 init SELECT c FROM sbtest2 WHERE id=4952128 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 statistics SELECT SUM(K) FROM sbtest2 WHERE id BETWEEN 5021673 AND 5021673+99 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013997 root localhost NULL Query 0 NULL show full processlist 1344567408 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5038719 AND 5038719+99 ORDER BY c 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 statistics SELECT c FROM sbtest2 WHERE id BETWEEN 5034008 AND 5034008+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5318512 AND 5318512+99 ORDER BY c 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5035946 AND 5035946+99 ORDER BY c 1013998 root localhost NULL Query 0 NULL show full processlist 1344567408 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 System lock SELECT c FROM sbtest2 WHERE id=6155129 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 Opening tables SELECT c FROM sbtest2 WHERE id BETWEEN 5047968 AND 5047968+99 ORDER BY c 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5002287 AND 5002287+99 ORDER BY c 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Updating UPDATE sbtest2 SET k=k+1 WHERE id=5005451 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5049490 AND 5049490+99 ORDER BY c 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 Sorting result SELECT c FROM sbtest1 WHERE id BETWEEN 4955114 AND 4955114+99 ORDER BY c 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1013999 root localhost NULL Query 0 NULL show full processlist 1344567409 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5038504 AND 5038504+99 ORDER BY c 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5030176 AND 5030176+99 ORDER BY c 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 Sorting result SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5112034 AND 5112034+99 ORDER BY c 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Query 0 updating DELETE FROM sbtest2 WHERE id=5026109 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 NULL NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 freeing items SELECT c FROM sbtest2 WHERE id=4980733 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014000 root localhost NULL Query 0 NULL show full processlist 1344567409 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 Updating UPDATE sbtest1 SET k=k+1 WHERE id=5031815 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 Updating UPDATE sbtest2 SET k=k+1 WHERE id=4970820 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Updating UPDATE sbtest2 SET k=k+1 WHERE id=6129761 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 Updating UPDATE sbtest2 SET k=k+1 WHERE id=4986131 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 Updating UPDATE sbtest1 SET k=k+1 WHERE id=5538761 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 Updating UPDATE sbtest1 SET k=k+1 WHERE id=4960458 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 Updating UPDATE sbtest1 SET k=k+1 WHERE id=4996419 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 NULL COMMIT 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 Updating UPDATE sbtest2 SET k=k+1 WHERE id=4951866 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Updating UPDATE sbtest2 SET k=k+1 WHERE id=4982858 1013895 sysbench 127.0.0.1:33189 sbtest Query 0 Updating UPDATE sbtest1 SET k=k+1 WHERE id=4985774 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 Updating UPDATE sbtest2 SET k=k+1 WHERE id=5961411 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 Updating UPDATE sbtest1 SET c='94988341541-43977363302-84830887323-37064998153-14021807547-41490962942-14683098480-10785919241-25043497264-89810656786' WHERE id=4950366 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 Updating UPDATE sbtest1 SET k=k+1 WHERE id=4953643 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Updating UPDATE sbtest1 SET k=k+1 WHERE id=5004986 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 updating DELETE FROM sbtest1 WHERE id=5561526 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 Updating UPDATE sbtest2 SET k=k+1 WHERE id=5004236 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 NULL COMMIT 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 Updating UPDATE sbtest2 SET k=k+1 WHERE id=5040790 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Updating UPDATE sbtest1 SET k=k+1 WHERE id=4967027 1014001 root localhost NULL Query 0 NULL show full processlist 1344567410 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4985403 AND 4985403+99 ORDER BY c 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 Updating UPDATE sbtest2 SET k=k+1 WHERE id=5016487 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Query 0 Updating UPDATE sbtest1 SET k=k+1 WHERE id=5003103 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 NULL COMMIT 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 NULL SELECT c FROM sbtest2 WHERE id=4971573 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Sending data SELECT c FROM sbtest1 WHERE id=5043207 1014002 root localhost NULL Query 0 NULL show full processlist 1344567410 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4999546 AND 4999546+99 ORDER BY c 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5017078 AND 5017078+99 ORDER BY c 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5116923 AND 5116923+99 ORDER BY c 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Writing to net INSERT INTO sbtest2 (id, k, c, pad) VALUES (4618998, 5028788, '29043382200-25718732156-00726987712-27903507256-42957912043-23331297209-08166758665-85674181724-55513745868-59703538774', '43748844607-94512442052-70857348607-95318172607-21961631011') 1013895 sysbench 127.0.0.1:33189 sbtest Query 0 init SELECT c FROM sbtest1 WHERE id=5021469 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 Sending data SELECT SUM(K) FROM sbtest1 WHERE id BETWEEN 5041365 AND 5041365+99 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 Sorting result SELECT c FROM sbtest1 WHERE id BETWEEN 4716741 AND 4716741+99 ORDER BY c 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 statistics SELECT c FROM sbtest2 WHERE id=5027008 1014003 root localhost NULL Query 0 NULL show full processlist 1344567411 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Sorting result SELECT c FROM sbtest2 WHERE id BETWEEN 6681700 AND 6681700+99 ORDER BY c 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 update INSERT INTO sbtest1 (id, k, c, pad) VALUES (4975339, 5022956, '45744343272-50080817829-89929597190-50527313592-32124956644-97629886183-17096249090-23833811415-20305413658-16910571636', '77154061228-51313987856-28685818166-78178379829-91903901684') 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 cleaning up NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4975389 AND 4975389+99 ORDER BY c 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 NULL COMMIT 1013895 sysbench 127.0.0.1:33189 sbtest Query 0 Writing to net SELECT c FROM sbtest1 WHERE id BETWEEN 5000631 AND 5000631+99 ORDER BY c 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4978123 AND 4978123+99 ORDER BY c 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4981742 AND 4981742+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 update INSERT INTO sbtest2 (id, k, c, pad) VALUES (5021175, 5046564, '58105688213-86460021948-40203345843-11450738330-71182455460-54022600903-73103843572-77630090429-74032529213-64629825423', '35228259393-74996543892-52120693623-85247172979-23435913329') 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5029464 AND 5029464+99 ORDER BY c 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Sending data SELECT c FROM sbtest2 WHERE id BETWEEN 6602587 AND 6602587+99 1014004 root localhost NULL Query 0 NULL show full processlist 1344567411 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4971227 AND 4971227+99 ORDER BY c 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 freeing items SELECT c FROM sbtest1 WHERE id=4962179 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 preparing SELECT c FROM sbtest1 WHERE id=3845910 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 Sending data SELECT c FROM sbtest2 WHERE id BETWEEN 4911580 AND 4911580+99 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 freeing items SELECT c FROM sbtest2 WHERE id=4989649 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5048508 AND 5048508+99 ORDER BY c 1013895 sysbench 127.0.0.1:33189 sbtest Query 0 freeing items SELECT c FROM sbtest1 WHERE id=5042492 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5117315 AND 5117315+99 ORDER BY c 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5003531 AND 5003531+99 ORDER BY c 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014005 root localhost NULL Query 0 NULL show full processlist 1344567412 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014006 root localhost NULL Query 0 NULL show full processlist 1344567412 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5013943 AND 5013943+99 ORDER BY c 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 preparing SELECT c FROM sbtest1 WHERE id=5002728 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 statistics SELECT SUM(K) FROM sbtest1 WHERE id BETWEEN 5037774 AND 5037774+99 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4821368 AND 4821368+99 ORDER BY c 1014007 root localhost NULL Query 0 NULL show full processlist 1344567413 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4989693 AND 4989693+99 ORDER BY c 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 Sorting result SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5988998 AND 5988998+99 ORDER BY c 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 Sorting result SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4979478 AND 4979478+99 ORDER BY c 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5008592 AND 5008592+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Writing to net SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5032987 AND 5032987+99 ORDER BY c 1014008 root localhost NULL Query 0 NULL show full processlist 1344567413 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 NULL NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 NULL NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 NULL NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 cleaning up NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4969409 AND 4969409+99 ORDER BY c 1014009 root localhost NULL Query 0 NULL show full processlist 1344567414 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5042550 AND 5042550+99 ORDER BY c 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 NULL SELECT SUM(K) FROM sbtest1 WHERE id BETWEEN 4983343 AND 4983343+99 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4958741 AND 4958741+99 ORDER BY c 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014010 root localhost NULL Query 0 NULL show full processlist 1344567414 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5017742 AND 5017742+99 ORDER BY c 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 cleaning up NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 Sorting result SELECT c FROM sbtest2 WHERE id BETWEEN 5027627 AND 5027627+99 ORDER BY c 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4094318 AND 4094318+99 ORDER BY c 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Sorting result SELECT c FROM sbtest1 WHERE id BETWEEN 6950804 AND 6950804+99 ORDER BY c 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 Updating UPDATE sbtest1 SET c='25800607842-72324046773-47683548651-66591181309-15780383117-16753719164-91217186652-39934446901-68580031725-19173331330' WHERE id=4979677 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 NULL COMMIT 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4983957 AND 4983957+99 ORDER BY c 1014011 root localhost NULL Query 0 NULL show full processlist 1344567415 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5037932 AND 5037932+99 ORDER BY c 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4957538 AND 4957538+99 ORDER BY c 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5007263 AND 5007263+99 ORDER BY c 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4993732 AND 4993732+99 ORDER BY c 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5025461 AND 5025461+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 cleaning up NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Sorting result SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4988078 AND 4988078+99 ORDER BY c 1014012 root localhost NULL Query 0 NULL show full processlist 1344567415 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5281203 AND 5281203+99 ORDER BY c 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5067615 AND 5067615+99 ORDER BY c 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 NULL NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 3637280 AND 3637280+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5017032 AND 5017032+99 ORDER BY c 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014013 root localhost NULL Query 0 NULL show full processlist 1344567416 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014014 root localhost NULL Query 0 NULL show full processlist 1344567416 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 updating DELETE FROM sbtest1 WHERE id=4655588 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 Sending data SELECT SUM(K) FROM sbtest2 WHERE id BETWEEN 5023308 AND 5023308+99 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5035513 AND 5035513+99 ORDER BY c 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 Updating UPDATE sbtest1 SET c='01051455219-11115136802-07653625767-35625944412-65859140756-47485808449-66646032911-84366572790-62633722103-33852824197' WHERE id=4989578 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 NULL COMMIT 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Query 0 NULL NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 NULL SELECT c FROM sbtest1 WHERE id=4978520 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 Updating UPDATE sbtest2 SET k=k+1 WHERE id=4708454 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 NULL COMMIT 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5018439 AND 5018439+99 ORDER BY c 1014015 root localhost NULL Query 0 NULL show full processlist 1344567417 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4955147 AND 4955147+99 ORDER BY c 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4986709 AND 4986709+99 ORDER BY c 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 updating DELETE FROM sbtest2 WHERE id=4852060 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 cleaning up NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4988402 AND 4988402+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 NULL NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014016 root localhost NULL Query 0 NULL show full processlist 1344567417 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 Sorting result SELECT c FROM sbtest1 WHERE id BETWEEN 4086334 AND 4086334+99 ORDER BY c 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 end DELETE FROM sbtest2 WHERE id=5447083 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 NULL COMMIT 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 NULL COMMIT 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014017 root localhost NULL Query 0 NULL show full processlist 1344567418 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 NULL NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4953937 AND 4953937+99 ORDER BY c 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5035303 AND 5035303+99 ORDER BY c 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4994938 AND 4994938+99 ORDER BY c 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5010342 AND 5010342+99 ORDER BY c 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5487275 AND 5487275+99 ORDER BY c 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 NULL NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5017338 AND 5017338+99 ORDER BY c 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014018 root localhost NULL Query 0 NULL show full processlist 1344567418 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 cleaning up NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4988919 AND 4988919+99 ORDER BY c 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 init SELECT c FROM sbtest2 WHERE id BETWEEN 5034666 AND 5034666+99 ORDER BY c 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 NULL NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 cleaning up NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Sending data SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4094300 AND 4094300+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 NULL COMMIT 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014019 root localhost NULL Query 0 NULL show full processlist 1344567419 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 3533189 AND 3533189+99 ORDER BY c 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5028046 AND 5028046+99 ORDER BY c 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 Sending data SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4960446 AND 4960446+99 ORDER BY c 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5034416 AND 5034416+99 ORDER BY c 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 Sorting result SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5011797 AND 5011797+99 ORDER BY c 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4997041 AND 4997041+99 ORDER BY c 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4994692 AND 4994692+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 closing tables SELECT c FROM sbtest1 WHERE id=4388875 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5009689 AND 5009689+99 ORDER BY c 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Sorting result SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5047893 AND 5047893+99 ORDER BY c 1014020 root localhost NULL Query 0 NULL show full processlist 1344567419 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 statistics SELECT c FROM sbtest1 WHERE id=5017661 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 cleaning up NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 statistics SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5047956 AND 5047956+99 ORDER BY c 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 Sorting result SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4998695 AND 4998695+99 ORDER BY c 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5036451 AND 5036451+99 ORDER BY c 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 init SELECT c FROM sbtest1 WHERE id=4999048 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 6087801 AND 6087801+99 ORDER BY c 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 NULL NULL 1014021 root localhost NULL Query 0 NULL show full processlist 1344567420 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5012009 AND 5012009+99 ORDER BY c 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4995444 AND 4995444+99 ORDER BY c 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4996339 AND 4996339+99 ORDER BY c 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 closing tables SELECT c FROM sbtest1 WHERE id=5017250 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 Sorting result SELECT c FROM sbtest2 WHERE id BETWEEN 4962770 AND 4962770+99 ORDER BY c 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5025802 AND 5025802+99 ORDER BY c 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014022 root localhost NULL Query 0 NULL show full processlist 1344567420 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 NULL NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5012363 AND 5012363+99 ORDER BY c 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 init SELECT c FROM sbtest1 WHERE id=4145351 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Query 0 Opening tables DELETE FROM sbtest1 WHERE id=4964398 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 NULL NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 NULL NULL 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5040344 AND 5040344+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014023 root localhost NULL Query 0 NULL show full processlist 1344567421 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 NULL COMMIT 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4977948 AND 4977948+99 ORDER BY c 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5045204 AND 5045204+99 ORDER BY c 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4958395 AND 4958395+99 ORDER BY c 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 Sending data SELECT c FROM sbtest1 WHERE id BETWEEN 4977063 AND 4977063+99 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Sending data SELECT c FROM sbtest2 WHERE id BETWEEN 5016830 AND 5016830+99 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Updating UPDATE sbtest2 SET c='82818649172-62557310619-87429126092-39417631636-97682887502-08931949904-66053084862-80550025111-66424706024-29765206340' WHERE id=4331052 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 statistics SELECT c FROM sbtest2 WHERE id=4960699 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5004484 AND 5004484+99 ORDER BY c 1014024 root localhost NULL Query 0 NULL show full processlist 1344567421 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014025 root localhost NULL Query 0 NULL show full processlist 1344567422 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 update INSERT INTO sbtest1 (id, k, c, pad) VALUES (5009003, 4707232, '06397026697-46809099977-33104869140-53124093837-78068911567-06005387898-94783187038-50370293254-95676660966-91469329520', '68385533082-05930431866-99099672466-79602554932-58064672603') 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 statistics SELECT SUM(K) FROM sbtest2 WHERE id BETWEEN 5017652 AND 5017652+99 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 NULL COMMIT 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4999690 AND 4999690+99 ORDER BY c 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 init SELECT c FROM sbtest2 WHERE id=5035042 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5010486 AND 5010486+99 ORDER BY c 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Sorting result SELECT c FROM sbtest2 WHERE id BETWEEN 5002966 AND 5002966+99 ORDER BY c 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4730131 AND 4730131+99 ORDER BY c 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014026 root localhost NULL Query 0 NULL show full processlist 1344567423 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4959338 AND 4959338+99 ORDER BY c 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 NULL COMMIT 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 Sorting result SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4961987 AND 4961987+99 ORDER BY c 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 updating DELETE FROM sbtest2 WHERE id=4973230 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4987461 AND 4987461+99 ORDER BY c 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4995285 AND 4995285+99 ORDER BY c 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5047734 AND 5047734+99 ORDER BY c 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5023268 AND 5023268+99 ORDER BY c 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 preparing SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5031130 AND 5031130+99 ORDER BY c 1014027 root localhost NULL Query 0 NULL show full processlist 1344567423 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5048692 AND 5048692+99 ORDER BY c 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5291762 AND 5291762+99 ORDER BY c 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 NULL NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 cleaning up NULL 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 NULL COMMIT 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 query end SELECT c FROM sbtest2 WHERE id=5026351 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Sorting result SELECT c FROM sbtest2 WHERE id BETWEEN 5972483 AND 5972483+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 closing tables SELECT c FROM sbtest2 WHERE id=5020259 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4973222 AND 4973222+99 ORDER BY c 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014028 root localhost NULL Query 0 NULL show full processlist 1344567424 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 NULL COMMIT 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4989316 AND 4989316+99 ORDER BY c 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4972275 AND 4972275+99 ORDER BY c 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5004192 AND 5004192+99 ORDER BY c 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 Sorting result SELECT c FROM sbtest2 WHERE id BETWEEN 6005964 AND 6005964+99 ORDER BY c 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 cleaning up NULL 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 NULL COMMIT 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4968282 AND 4968282+99 ORDER BY c 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Sorting result SELECT c FROM sbtest2 WHERE id BETWEEN 5020217 AND 5020217+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5047823 AND 5047823+99 ORDER BY c 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 Sorting result SELECT c FROM sbtest1 WHERE id BETWEEN 5022416 AND 5022416+99 ORDER BY c 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5603176 AND 5603176+99 ORDER BY c 1014029 root localhost NULL Query 0 NULL show full processlist 1344567424 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4517738 AND 4517738+99 ORDER BY c 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 statistics SELECT c FROM sbtest1 WHERE id=4995221 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 Sending data SELECT SUM(K) FROM sbtest1 WHERE id BETWEEN 4966581 AND 4966581+99 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 Sending data SELECT SUM(K) FROM sbtest2 WHERE id BETWEEN 4961516 AND 4961516+99 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014030 root localhost NULL Query 0 NULL show full processlist 1344567425 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 Writing to net DELETE FROM sbtest1 WHERE id=5002279 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 NULL COMMIT 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 end UPDATE sbtest1 SET c='90850607707-40722602965-73387244412-22704104447-99607015068-13496029650-09804233813-79024746780-87346857867-72732228308' WHERE id=5013183 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Updating UPDATE sbtest2 SET k=k+1 WHERE id=5013564 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 NULL NULL 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 update INSERT INTO sbtest1 (id, k, c, pad) VALUES (4986427, 6154913, '04497212550-27340450984-68193217208-14036585938-46825870136-76154391696-68892489376-07865647340-52910306982-30290159461', '33103640459-60384424373-84016964341-10288143681-26425975411') 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5024902 AND 5024902+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 updating DELETE FROM sbtest2 WHERE id=5499974 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 NULL COMMIT 1014031 root localhost NULL Query 0 NULL show full processlist 1344567425 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 Creating tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5034694 AND 5034694+99 ORDER BY c 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 init SELECT c FROM sbtest2 WHERE id=4957267 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5183562 AND 5183562+99 ORDER BY c 1013895 sysbench 127.0.0.1:33189 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 3597988 AND 3597988+99 ORDER BY c 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5024107 AND 5024107+99 ORDER BY c 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Sending data SELECT SUM(K) FROM sbtest2 WHERE id BETWEEN 5033222 AND 5033222+99 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014032 root localhost NULL Query 0 NULL show full processlist 1344567426 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5022851 AND 5022851+99 ORDER BY c 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5030824 AND 5030824+99 ORDER BY c 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Query 0 Sorting result SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5020699 AND 5020699+99 ORDER BY c 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 Sending data SELECT c FROM sbtest2 WHERE id BETWEEN 3604152 AND 3604152+99 ORDER BY c 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5346319 AND 5346319+99 ORDER BY c 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 updating DELETE FROM sbtest1 WHERE id=5004979 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014033 root localhost NULL Query 0 NULL show full processlist 1344567426 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 NULL NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 NULL NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 cleaning up NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 NULL COMMIT 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 preparing SELECT c FROM sbtest1 WHERE id=5012293 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Updating UPDATE sbtest1 SET k=k+1 WHERE id=5006063 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Writing to net SELECT c FROM sbtest1 WHERE id=5025833 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 cleaning up NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5038912 AND 5038912+99 ORDER BY c 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Updating UPDATE sbtest2 SET k=k+1 WHERE id=5021323 1014034 root localhost NULL Query 0 NULL show full processlist 1344567427 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5015118 AND 5015118+99 ORDER BY c 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4980830 AND 4980830+99 ORDER BY c 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 6109085 AND 6109085+99 ORDER BY c 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4381166 AND 4381166+99 ORDER BY c 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 Sending data SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4999391 AND 4999391+99 ORDER BY c 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014035 root localhost NULL Query 0 NULL show full processlist 1344567427 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5048817 AND 5048817+99 ORDER BY c 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4956649 AND 4956649+99 ORDER BY c 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5032016 AND 5032016+99 ORDER BY c 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5029553 AND 5029553+99 ORDER BY c 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 NULL COMMIT 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 Updating UPDATE sbtest1 SET c='47751447913-42855184572-51729473489-30015245191-34327727215-83885144212-08126543331-06490280344-63464476675-65190434959' WHERE id=5023480 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Writing to net SELECT c FROM sbtest2 WHERE id=5014940 1014036 root localhost NULL Query 0 NULL show full processlist 1344567428 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4979481 AND 4979481+99 ORDER BY c 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4993207 AND 4993207+99 ORDER BY c 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4978348 AND 4978348+99 ORDER BY c 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4984449 AND 4984449+99 ORDER BY c 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5031829 AND 5031829+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5033228 AND 5033228+99 ORDER BY c 1014037 root localhost NULL Query 0 NULL show full processlist 1344567428 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Sorting result SELECT c FROM sbtest2 WHERE id BETWEEN 4996628 AND 4996628+99 ORDER BY c 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5014772 AND 5014772+99 ORDER BY c 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 closing tables SELECT c FROM sbtest2 WHERE id=5037315 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 NULL NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4997267 AND 4997267+99 ORDER BY c 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5013536 AND 5013536+99 ORDER BY c 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 NULL SELECT SUM(K) FROM sbtest1 WHERE id BETWEEN 5001485 AND 5001485+99 1014038 root localhost NULL Query 0 NULL show full processlist 1344567429 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 Updating UPDATE sbtest2 SET k=k+1 WHERE id=5014055 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 optimizing SELECT c FROM sbtest1 WHERE id=4965695 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 NULL NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4829045 AND 4829045+99 ORDER BY c 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5036801 AND 5036801+99 ORDER BY c 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5037910 AND 5037910+99 ORDER BY c 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014039 root localhost NULL Query 0 NULL show full processlist 1344567429 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 Writing to net DELETE FROM sbtest2 WHERE id=4955779 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Sending data SELECT c FROM sbtest2 WHERE id BETWEEN 5047902 AND 5047902+99 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 Updating UPDATE sbtest1 SET k=k+1 WHERE id=5238733 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014040 root localhost NULL Query 0 NULL show full processlist 1344567430 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4974300 AND 4974300+99 ORDER BY c 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Opening tables SELECT c FROM sbtest1 WHERE id=5864224 1013895 sysbench 127.0.0.1:33189 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5030491 AND 5030491+99 ORDER BY c 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 NULL SELECT c FROM sbtest1 WHERE id=4974110 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4983469 AND 4983469+99 ORDER BY c 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014041 root localhost NULL Query 0 NULL show full processlist 1344567430 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4965309 AND 4965309+99 ORDER BY c 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 Sending data SELECT c FROM sbtest2 WHERE id BETWEEN 5414724 AND 5414724+99 ORDER BY c 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5043972 AND 5043972+99 ORDER BY c 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4986558 AND 4986558+99 ORDER BY c 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 Sending data SELECT c FROM sbtest1 WHERE id BETWEEN 4992007 AND 4992007+99 ORDER BY c 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4965202 AND 4965202+99 ORDER BY c 1014042 root localhost NULL Query 0 NULL show full processlist 1344567431 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 Sorting result SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4229928 AND 4229928+99 ORDER BY c 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4987248 AND 4987248+99 ORDER BY c 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 NULL SELECT c FROM sbtest1 WHERE id=4963116 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Query 0 Sorting result SELECT c FROM sbtest2 WHERE id BETWEEN 4973738 AND 4973738+99 ORDER BY c 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 Sorting result SELECT c FROM sbtest1 WHERE id BETWEEN 5516232 AND 5516232+99 ORDER BY c 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014043 root localhost NULL Query 0 NULL show full processlist 1344567431 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4995894 AND 4995894+99 ORDER BY c 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4965701 AND 4965701+99 ORDER BY c 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Sending data SELECT c FROM sbtest2 WHERE id BETWEEN 5033500 AND 5033500+99 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 statistics SELECT c FROM sbtest2 WHERE id=5381598 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4378093 AND 4378093+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 freeing items UPDATE sbtest1 SET k=k+1 WHERE id=5004854 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5022270 AND 5022270+99 ORDER BY c 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014044 root localhost NULL Query 0 NULL show full processlist 1344567432 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4908024 AND 4908024+99 ORDER BY c 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5030400 AND 5030400+99 ORDER BY c 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4999171 AND 4999171+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5026964 AND 5026964+99 ORDER BY c 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 statistics SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4738269 AND 4738269+99 ORDER BY c 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 Writing to net BEGIN 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014045 root localhost NULL Query 0 NULL show full processlist 1344567432 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 Sending data SELECT c FROM sbtest2 WHERE id BETWEEN 5041321 AND 5041321+99 ORDER BY c 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 NULL COMMIT 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 System lock SELECT c FROM sbtest2 WHERE id=5008173 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 statistics SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4969501 AND 4969501+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 updating DELETE FROM sbtest2 WHERE id=4988140 1014046 root localhost NULL Query 0 NULL show full processlist 1344567433 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 NULL SELECT c FROM sbtest1 WHERE id=5045355 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 Sending data SELECT c FROM sbtest2 WHERE id BETWEEN 4964344 AND 4964344+99 ORDER BY c 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 NULL SELECT c FROM sbtest2 WHERE id BETWEEN 4962943 AND 4962943+99 ORDER BY c 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014047 root localhost NULL Query 0 NULL show full processlist 1344567433 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5030539 AND 5030539+99 ORDER BY c 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4978342 AND 4978342+99 ORDER BY c 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4026594 AND 4026594+99 ORDER BY c 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014048 root localhost NULL Query 0 NULL show full processlist 1344567434 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4653832 AND 4653832+99 ORDER BY c 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4993808 AND 4993808+99 ORDER BY c 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4977751 AND 4977751+99 ORDER BY c 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4968555 AND 4968555+99 ORDER BY c 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 NULL COMMIT 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 6287543 AND 6287543+99 ORDER BY c 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014049 root localhost NULL Query 0 NULL show full processlist 1344567434 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5005392 AND 5005392+99 ORDER BY c 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 end UPDATE sbtest2 SET k=k+1 WHERE id=4993972 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Sorting result SELECT c FROM sbtest1 WHERE id BETWEEN 5624705 AND 5624705+99 ORDER BY c 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Sending data SELECT c FROM sbtest2 WHERE id BETWEEN 4958654 AND 4958654+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 Sorting result SELECT c FROM sbtest1 WHERE id BETWEEN 4994202 AND 4994202+99 ORDER BY c 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014050 root localhost NULL Query 0 NULL show full processlist 1344567435 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4669117 AND 4669117+99 ORDER BY c 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014051 root localhost NULL Query 0 NULL show full processlist 1344567435 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5021716 AND 5021716+99 ORDER BY c 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4954999 AND 4954999+99 ORDER BY c 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 update INSERT INTO sbtest1 (id, k, c, pad) VALUES (5022416, 5427871, '38877314645-56630219891-92311022547-20022977769-69418820501-34197641755-61581046186-65060670072-83690851845-87807785741', '29308085017-78327070202-08604471545-14633140330-73365811482') 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014052 root localhost NULL Query 0 NULL show full processlist 1344567436 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 6736059 AND 6736059+99 ORDER BY c 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5030786 AND 5030786+99 ORDER BY c 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5035580 AND 5035580+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014053 root localhost NULL Query 0 NULL show full processlist 1344567436 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 end SELECT c FROM sbtest2 WHERE id=4975856 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 Sorting result SELECT c FROM sbtest1 WHERE id BETWEEN 5044690 AND 5044690+99 ORDER BY c 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 updating DELETE FROM sbtest2 WHERE id=5034713 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 NULL COMMIT 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 Sorting result SELECT c FROM sbtest1 WHERE id BETWEEN 5017315 AND 5017315+99 ORDER BY c 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 init SELECT c FROM sbtest2 WHERE id=5013567 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 init SELECT c FROM sbtest1 WHERE id=4984640 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 NULL SELECT c FROM sbtest2 WHERE id BETWEEN 6466622 AND 6466622+99 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014054 root localhost NULL Query 0 NULL show full processlist 1344567437 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4993632 AND 4993632+99 ORDER BY c 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5017688 AND 5017688+99 ORDER BY c 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4966611 AND 4966611+99 ORDER BY c 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 closing tables INSERT INTO sbtest1 (id, k, c, pad) VALUES (5001744, 4960521, '31896736646-19105480337-25454019005-70827623730-73176333141-59826588458-36799982597-64539337358-92150929345-38868548807', '56602228405-83838999808-80401661206-15612991466-45161485718') 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5013844 AND 5013844+99 ORDER BY c 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 optimizing SELECT c FROM sbtest2 WHERE id=4981120 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 init UPDATE sbtest2 SET k=k+1 WHERE id=6100266 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Sending data SELECT SUM(K) FROM sbtest1 WHERE id BETWEEN 5002667 AND 5002667+99 1014055 root localhost NULL Query 0 NULL show full processlist 1344567437 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 statistics SELECT c FROM sbtest2 WHERE id BETWEEN 5366233 AND 5366233+99 ORDER BY c 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 init SELECT c FROM sbtest1 WHERE id=5045972 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 NULL COMMIT 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5595558 AND 5595558+99 ORDER BY c 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 update INSERT INTO sbtest1 (id, k, c, pad) VALUES (4986549, 5047504, '48011990695-51458631144-35753076348-92027915048-31893208538-00233770825-60632747509-13565509769-41685899055-05229790077', '33692367471-28529348983-29842247275-80548221930-86670407605') 1013895 sysbench 127.0.0.1:33189 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5013221 AND 5013221+99 ORDER BY c 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 Opening tables SELECT c FROM sbtest2 WHERE id=5425727 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 Updating UPDATE sbtest2 SET k=k+1 WHERE id=5005224 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 NULL COMMIT 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 updating DELETE FROM sbtest1 WHERE id=5026163 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Updating UPDATE sbtest1 SET k=k+1 WHERE id=4997097 1014056 root localhost NULL Query 0 NULL show full processlist 1344567438 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4999011 AND 4999011+99 ORDER BY c 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 Creating tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5037348 AND 5037348+99 ORDER BY c 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4997120 AND 4997120+99 ORDER BY c 1013900 sysbench 127.0.0.1:33193 sbtest Query 0 Sorting result SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4445580 AND 4445580+99 ORDER BY c 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 statistics SELECT c FROM sbtest1 WHERE id BETWEEN 5013828 AND 5013828+99 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 cleaning up NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014057 root localhost NULL Query 0 NULL show full processlist 1344567438 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4842357 AND 4842357+99 ORDER BY c 1013890 sysbench 127.0.0.1:33185 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4962004 AND 4962004+99 ORDER BY c 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5004564 AND 5004564+99 ORDER BY c 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4962995 AND 4962995+99 ORDER BY c 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4971881 AND 4971881+99 ORDER BY c 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014058 root localhost NULL Query 0 NULL show full processlist 1344567439 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4914602 AND 4914602+99 ORDER BY c 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Query 0 Sorting result SELECT c FROM sbtest2 WHERE id BETWEEN 5029280 AND 5029280+99 ORDER BY c 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 init SELECT c FROM sbtest2 WHERE id BETWEEN 4987125 AND 4987125+99 ORDER BY c 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4955766 AND 4955766+99 ORDER BY c 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5012509 AND 5012509+99 ORDER BY c 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 4988540 AND 4988540+99 ORDER BY c 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5042545 AND 5042545+99 ORDER BY c 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5031130 AND 5031130+99 ORDER BY c 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014059 root localhost NULL Query 0 NULL show full processlist 1344567439 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Query 0 statistics SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5044452 AND 5044452+99 ORDER BY c 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 Sorting result SELECT c FROM sbtest1 WHERE id BETWEEN 5017140 AND 5017140+99 ORDER BY c 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 Sending data SELECT c FROM sbtest1 WHERE id=5017140 1013893 sysbench 127.0.0.1:33186 sbtest Query 0 Sending data SELECT c FROM sbtest1 WHERE id BETWEEN 4999952 AND 4999952+99 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5012470 AND 5012470+99 ORDER BY c 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014060 root localhost NULL Query 0 NULL show full processlist 1344567440 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Query 0 NULL COMMIT 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5026583 AND 5026583+99 ORDER BY c 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014061 root localhost NULL Query 0 NULL show full processlist 1344567440 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Sleep 0 NULL 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4961593 AND 4961593+99 ORDER BY c 1013886 sysbench 127.0.0.1:33182 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5002624 AND 5002624+99 ORDER BY c 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4974496 AND 4974496+99 ORDER BY c 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 5040760 AND 5040760+99 ORDER BY c 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5027311 AND 5027311+99 ORDER BY c 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Query 0 Copying to tmp table SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN 4988608 AND 4988608+99 ORDER BY c 1014062 root localhost NULL Query 0 NULL show full processlist 1344567441 Id User Host db Command Time State Info 1013885 sysbench 127.0.0.1:33178 sbtest Query 0 Writing to net SELECT DISTINCT c FROM sbtest2 WHERE id BETWEEN 5026886 AND 5026886+99 ORDER BY c 1013891 sysbench 127.0.0.1:33184 sbtest Sleep 0 NULL 1013890 sysbench 127.0.0.1:33185 sbtest Sleep 0 NULL 1013889 sysbench 127.0.0.1:33183 sbtest Sleep 0 NULL 1013888 sysbench 127.0.0.1:33181 sbtest Sleep 0 NULL 1013887 sysbench 127.0.0.1:33179 sbtest Sleep 0 NULL 1013886 sysbench 127.0.0.1:33182 sbtest Sleep 0 NULL 1013892 sysbench 127.0.0.1:33187 sbtest Sleep 0 NULL 1013893 sysbench 127.0.0.1:33186 sbtest Sleep 0 NULL 1013894 sysbench 127.0.0.1:33188 sbtest Sleep 0 NULL 1013895 sysbench 127.0.0.1:33189 sbtest Sleep 0 NULL 1013897 sysbench 127.0.0.1:33191 sbtest Sleep 0 NULL 1013896 sysbench 127.0.0.1:33192 sbtest Sleep 0 NULL 1013898 sysbench 127.0.0.1:33190 sbtest Sleep 0 NULL 1013900 sysbench 127.0.0.1:33193 sbtest Sleep 0 NULL 1013901 sysbench 127.0.0.1:33195 sbtest Sleep 0 NULL 1013904 sysbench 127.0.0.1:33199 sbtest Sleep 0 NULL 1013903 sysbench 127.0.0.1:33197 sbtest Sleep 0 NULL 1013902 sysbench 127.0.0.1:33196 sbtest Sleep 0 NULL 1013899 sysbench 127.0.0.1:33194 sbtest Sleep 0 NULL 1014063 root localhost NULL Query 0 NULL show full processlist 1344567441 Id User Host db Command Time State Info 1014064 root localhost NULL Query 0 NULL show full processlist 1344567442 Id User Host db Command Time State Info 1014065 root localhost NULL Query 0 NULL show full processlist 1344567442 Id User Host db Command Time State Info 1014066 root localhost NULL Query 0 NULL show full processlist 1344567443 Id User Host db Command Time State Info 1014067 root localhost NULL Query 0 NULL show full processlist 1344567443 Id User Host db Command Time State Info 1014068 root localhost NULL Query 0 NULL show full processlist 1344567444 Id User Host db Command Time State Info 1014069 root localhost NULL Query 0 NULL show full processlist 1344567444 Id User Host db Command Time State Info 1014070 root localhost NULL Query 0 NULL show full processlist 1344567445 Id User Host db Command Time State Info 1014071 root localhost NULL Query 0 NULL show full processlist 1344567445 Id User Host db Command Time State Info 1014072 root localhost NULL Query 0 NULL show full processlist 1344567446 Id User Host db Command Time State Info 1014073 root localhost NULL Query 0 NULL show full processlist 1344567446 Id User Host db Command Time State Info 1014074 root localhost NULL Query 0 NULL show full processlist 1344567447 Id User Host db Command Time State Info 1014075 root localhost NULL Query 0 NULL show full processlist 1344567447 Id User Host db Command Time State Info 1014076 root localhost NULL Query 0 NULL show full processlist 1344567448 Id User Host db Command Time State Info 1014077 root localhost NULL Query 0 NULL show full processlist 1344567448 Id User Host db Command Time State Info 1014078 root localhost NULL Query 0 NULL show full processlist 1344567449 Id User Host db Command Time State Info 1014079 root localhost NULL Query 0 NULL show full processlist 1344567449 Id User Host db Command Time State Info 1014080 root localhost NULL Query 0 NULL show full processlist 1344567450 Id User Host db Command Time State Info 1014081 root localhost NULL Query 0 NULL show full processlist 1344567450 Id User Host db Command Time State Info 1014082 root localhost NULL Query 0 NULL show full processlist 1344567451 Id User Host db Command Time State Info 1014083 root localhost NULL Query 0 NULL show full processlist 1344567451 Id User Host db Command Time State Info 1014084 root localhost NULL Query 0 NULL show full processlist 1344567452 Id User Host db Command Time State Info 1014085 root localhost NULL Query 0 NULL show full processlist 1344567452 Id User Host db Command Time State Info 1014086 root localhost NULL Query 0 NULL show full processlist 1344567453 Id User Host db Command Time State Info 1014087 root localhost NULL Query 0 NULL show full processlist 1344567453 Id User Host db Command Time State Info 1014088 root localhost NULL Query 0 NULL show full processlist 1344567454 Id User Host db Command Time State Info 1014089 root localhost NULL Query 0 NULL show full processlist 1344567454 Id User Host db Command Time State Info 1014090 root localhost NULL Query 0 NULL show full processlist 1344567455 Id User Host db Command Time State Info 1014091 root localhost NULL Query 0 NULL show full processlist 1344567455 Id User Host db Command Time State Info 1014092 root localhost NULL Query 0 NULL show full processlist 1344567456 Id User Host db Command Time State Info 1014093 root localhost NULL Query 0 NULL show full processlist 1344567457 Id User Host db Command Time State Info 1014094 root localhost NULL Query 0 NULL show full processlist 1344567457 Id User Host db Command Time State Info 1014095 root localhost NULL Query 0 NULL show full processlist 1344567458 Id User Host db Command Time State Info 1014096 root localhost NULL Query 0 NULL show full processlist 1344567458 Id User Host db Command Time State Info 1014097 root localhost NULL Query 0 NULL show full processlist 1344567459 Id User Host db Command Time State Info 1014098 root localhost NULL Query 0 NULL show full processlist 1344567459 Id User Host db Command Time State Info 1014099 root localhost NULL Query 0 NULL show full processlist 1344567460 Id User Host db Command Time State Info 1014100 root localhost NULL Query 0 NULL show full processlist 1344567460 Id User Host db Command Time State Info 1014101 root localhost NULL Query 0 NULL show full processlist 1344567461 Id User Host db Command Time State Info 1014102 root localhost NULL Query 0 NULL show full processlist 1344567461 Id User Host db Command Time State Info 1014103 root localhost NULL Query 0 NULL show full processlist 1344567462 Id User Host db Command Time State Info 1014104 root localhost NULL Query 0 NULL show full processlist 1344567462 Id User Host db Command Time State Info 1014105 root localhost NULL Query 0 NULL show full processlist 1344567463