mysql> SHOW FULL PROCESSLIST; +-----+--------+-----------+--------+---------+-------+----------+----------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+--------+-----------+--------+---------+-------+----------+----------------------------------------------------------------------+ | 32 | mikiya | localhost | NULL | Sleep | 15379 | | NULL | | 66 | mikiya | localhost | mytest | Query | 0 | NULL | SHOW FULL PROCESSLIST | | 655 | mikiya | localhost | mytest | Query | 3 | Locked | SELECT * FROM t2 WHERE a=11992244 | | 657 | mikiya | localhost | mytest | Query | 3 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000000 | | 658 | mikiya | localhost | mytest | Query | 3 | Updating | UPDATE LOW_PRIORITY t2 SET b=1 WHERE a BETWEEN 12000001 and 12100001 | | 660 | mikiya | localhost | mytest | Query | 3 | Locked | SELECT * FROM t2 WHERE a=11992245 | | 661 | mikiya | localhost | mytest | Query | 3 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000001 | | 662 | mikiya | localhost | mytest | Query | 3 | Locked | UPDATE LOW_PRIORITY t2 SET b=2 WHERE a BETWEEN 12000002 and 12100002 | | 663 | mikiya | localhost | mytest | Query | 3 | Locked | UPDATE LOW_PRIORITY t2 SET b=12000002 WHERE a=11992246 | | 664 | mikiya | localhost | mytest | Query | 3 | Locked | SELECT * FROM t2 WHERE a=11992246 | | 665 | mikiya | localhost | mytest | Query | 3 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000002 | | 666 | mikiya | localhost | mytest | Query | 3 | Locked | UPDATE LOW_PRIORITY t2 SET b=3 WHERE a BETWEEN 12000003 and 12100003 | | 667 | mikiya | localhost | mytest | Query | 3 | Locked | SELECT * FROM t2 WHERE a=11992247 | | 668 | mikiya | localhost | mytest | Query | 3 | Locked | UPDATE LOW_PRIORITY t2 SET b=12000003 WHERE a=11992247 | | 669 | mikiya | localhost | mytest | Query | 3 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000003 | | 670 | mikiya | localhost | mytest | Query | 3 | Locked | UPDATE LOW_PRIORITY t2 SET b=4 WHERE a BETWEEN 12000004 and 12100004 | | 671 | mikiya | localhost | mytest | Query | 3 | Locked | UPDATE LOW_PRIORITY t2 SET b=12000004 WHERE a=11992248 | | 672 | mikiya | localhost | mytest | Query | 3 | Locked | SELECT * FROM t2 WHERE a=11992248 | | 673 | mikiya | localhost | mytest | Query | 3 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000004 | | 674 | mikiya | localhost | mytest | Query | 3 | Locked | UPDATE LOW_PRIORITY t2 SET b=5 WHERE a BETWEEN 12000005 and 12100005 | | 675 | mikiya | localhost | mytest | Query | 3 | Locked | UPDATE LOW_PRIORITY t2 SET b=12000005 WHERE a=11992249 | | 676 | mikiya | localhost | mytest | Query | 3 | Locked | SELECT * FROM t2 WHERE a=11992249 | | 677 | mikiya | localhost | mytest | Query | 3 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000005 | | 678 | mikiya | localhost | mytest | Query | 3 | Locked | UPDATE LOW_PRIORITY t2 SET b=6 WHERE a BETWEEN 12000006 and 12100006 | | 679 | mikiya | localhost | mytest | Query | 3 | Locked | UPDATE LOW_PRIORITY t2 SET b=12000006 WHERE a=11992250 | | 680 | mikiya | localhost | mytest | Query | 3 | Locked | SELECT * FROM t2 WHERE a=11992250 | | 681 | mikiya | localhost | mytest | Query | 3 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000006 | | 682 | mikiya | localhost | mytest | Query | 3 | Locked | UPDATE LOW_PRIORITY t2 SET b=7 WHERE a BETWEEN 12000007 and 12100007 | | 683 | mikiya | localhost | mytest | Query | 3 | Locked | UPDATE LOW_PRIORITY t2 SET b=12000007 WHERE a=11992251 | | 684 | mikiya | localhost | mytest | Query | 3 | Locked | SELECT * FROM t2 WHERE a=11992251 | | 685 | mikiya | localhost | mytest | Query | 3 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000007 | | 686 | mikiya | localhost | mytest | Query | 3 | Locked | UPDATE LOW_PRIORITY t2 SET b=8 WHERE a BETWEEN 12000008 and 12100008 | | 687 | mikiya | localhost | mytest | Query | 3 | Locked | UPDATE LOW_PRIORITY t2 SET b=12000008 WHERE a=11992252 | | 688 | mikiya | localhost | mytest | Query | 3 | Locked | SELECT * FROM t2 WHERE a=11992252 | | 689 | mikiya | localhost | mytest | Query | 2 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000008 | | 690 | mikiya | localhost | mytest | Query | 2 | Locked | UPDATE LOW_PRIORITY t2 SET b=9 WHERE a BETWEEN 12000009 and 12100009 | | 691 | mikiya | localhost | mytest | Query | 2 | Locked | UPDATE LOW_PRIORITY t2 SET b=12000009 WHERE a=11992253 | | 692 | mikiya | localhost | mytest | Query | 2 | Locked | SELECT * FROM t2 WHERE a=11992253 | | 693 | mikiya | localhost | mytest | Query | 2 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000009 | +-----+--------+-----------+--------+---------+-------+----------+----------------------------------------------------------------------+ 39 rows in set (0.01 sec) mysql> SHOW FULL PROCESSLIST; +-----+--------+-----------+--------+---------+-------+----------+----------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+--------+-----------+--------+---------+-------+----------+----------------------------------------------------------------------+ | 32 | mikiya | localhost | NULL | Sleep | 15381 | | NULL | | 66 | mikiya | localhost | mytest | Query | 0 | NULL | SHOW FULL PROCESSLIST | | 655 | mikiya | localhost | mytest | Query | 5 | Locked | SELECT * FROM t2 WHERE a=11992244 | | 657 | mikiya | localhost | mytest | Query | 5 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000000 | | 660 | mikiya | localhost | mytest | Query | 5 | Locked | SELECT * FROM t2 WHERE a=11992245 | | 661 | mikiya | localhost | mytest | Query | 5 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000001 | | 664 | mikiya | localhost | mytest | Query | 5 | Locked | SELECT * FROM t2 WHERE a=11992246 | | 665 | mikiya | localhost | mytest | Query | 5 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000002 | | 666 | mikiya | localhost | mytest | Query | 5 | Updating | UPDATE LOW_PRIORITY t2 SET b=3 WHERE a BETWEEN 12000003 and 12100003 | | 667 | mikiya | localhost | mytest | Query | 5 | Locked | SELECT * FROM t2 WHERE a=11992247 | | 668 | mikiya | localhost | mytest | Query | 5 | Locked | UPDATE LOW_PRIORITY t2 SET b=12000003 WHERE a=11992247 | | 669 | mikiya | localhost | mytest | Query | 5 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000003 | | 670 | mikiya | localhost | mytest | Query | 5 | Locked | UPDATE LOW_PRIORITY t2 SET b=4 WHERE a BETWEEN 12000004 and 12100004 | | 671 | mikiya | localhost | mytest | Query | 5 | Locked | UPDATE LOW_PRIORITY t2 SET b=12000004 WHERE a=11992248 | | 672 | mikiya | localhost | mytest | Query | 5 | Locked | SELECT * FROM t2 WHERE a=11992248 | | 673 | mikiya | localhost | mytest | Query | 5 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000004 | | 674 | mikiya | localhost | mytest | Query | 5 | Locked | UPDATE LOW_PRIORITY t2 SET b=5 WHERE a BETWEEN 12000005 and 12100005 | | 675 | mikiya | localhost | mytest | Query | 5 | Locked | UPDATE LOW_PRIORITY t2 SET b=12000005 WHERE a=11992249 | | 676 | mikiya | localhost | mytest | Query | 5 | Locked | SELECT * FROM t2 WHERE a=11992249 | | 677 | mikiya | localhost | mytest | Query | 5 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000005 | | 678 | mikiya | localhost | mytest | Query | 5 | Locked | UPDATE LOW_PRIORITY t2 SET b=6 WHERE a BETWEEN 12000006 and 12100006 | | 679 | mikiya | localhost | mytest | Query | 5 | Locked | UPDATE LOW_PRIORITY t2 SET b=12000006 WHERE a=11992250 | | 680 | mikiya | localhost | mytest | Query | 5 | Locked | SELECT * FROM t2 WHERE a=11992250 | | 681 | mikiya | localhost | mytest | Query | 5 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000006 | | 682 | mikiya | localhost | mytest | Query | 5 | Locked | UPDATE LOW_PRIORITY t2 SET b=7 WHERE a BETWEEN 12000007 and 12100007 | | 683 | mikiya | localhost | mytest | Query | 5 | Locked | UPDATE LOW_PRIORITY t2 SET b=12000007 WHERE a=11992251 | | 684 | mikiya | localhost | mytest | Query | 5 | Locked | SELECT * FROM t2 WHERE a=11992251 | | 685 | mikiya | localhost | mytest | Query | 5 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000007 | | 686 | mikiya | localhost | mytest | Query | 5 | Locked | UPDATE LOW_PRIORITY t2 SET b=8 WHERE a BETWEEN 12000008 and 12100008 | | 687 | mikiya | localhost | mytest | Query | 5 | Locked | UPDATE LOW_PRIORITY t2 SET b=12000008 WHERE a=11992252 | | 688 | mikiya | localhost | mytest | Query | 5 | Locked | SELECT * FROM t2 WHERE a=11992252 | | 689 | mikiya | localhost | mytest | Query | 4 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000008 | | 690 | mikiya | localhost | mytest | Query | 4 | Locked | UPDATE LOW_PRIORITY t2 SET b=9 WHERE a BETWEEN 12000009 and 12100009 | | 691 | mikiya | localhost | mytest | Query | 4 | Locked | UPDATE LOW_PRIORITY t2 SET b=12000009 WHERE a=11992253 | | 692 | mikiya | localhost | mytest | Query | 4 | Locked | SELECT * FROM t2 WHERE a=11992253 | | 693 | mikiya | localhost | mytest | Query | 4 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000009 | +-----+--------+-----------+--------+---------+-------+----------+----------------------------------------------------------------------+ 36 rows in set (0.00 sec) mysql> SHOW FULL PROCESSLIST; +-----+--------+-----------+--------+---------+-------+----------+----------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-----+--------+-----------+--------+---------+-------+----------+----------------------------------------------------------------------+ | 32 | mikiya | localhost | NULL | Sleep | 15386 | | NULL | | 66 | mikiya | localhost | mytest | Query | 0 | NULL | SHOW FULL PROCESSLIST | | 655 | mikiya | localhost | mytest | Query | 10 | Locked | SELECT * FROM t2 WHERE a=11992244 | | 657 | mikiya | localhost | mytest | Query | 10 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000000 | | 660 | mikiya | localhost | mytest | Query | 10 | Locked | SELECT * FROM t2 WHERE a=11992245 | | 661 | mikiya | localhost | mytest | Query | 10 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000001 | | 664 | mikiya | localhost | mytest | Query | 10 | Locked | SELECT * FROM t2 WHERE a=11992246 | | 665 | mikiya | localhost | mytest | Query | 10 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000002 | | 667 | mikiya | localhost | mytest | Query | 10 | Locked | SELECT * FROM t2 WHERE a=11992247 | | 669 | mikiya | localhost | mytest | Query | 10 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000003 | | 672 | mikiya | localhost | mytest | Query | 10 | Locked | SELECT * FROM t2 WHERE a=11992248 | | 673 | mikiya | localhost | mytest | Query | 10 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000004 | | 676 | mikiya | localhost | mytest | Query | 10 | Locked | SELECT * FROM t2 WHERE a=11992249 | | 677 | mikiya | localhost | mytest | Query | 10 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000005 | | 680 | mikiya | localhost | mytest | Query | 10 | Locked | SELECT * FROM t2 WHERE a=11992250 | | 681 | mikiya | localhost | mytest | Query | 10 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000006 | | 682 | mikiya | localhost | mytest | Query | 10 | Updating | UPDATE LOW_PRIORITY t2 SET b=7 WHERE a BETWEEN 12000007 and 12100007 | | 683 | mikiya | localhost | mytest | Query | 10 | Locked | UPDATE LOW_PRIORITY t2 SET b=12000007 WHERE a=11992251 | | 684 | mikiya | localhost | mytest | Query | 10 | Locked | SELECT * FROM t2 WHERE a=11992251 | | 685 | mikiya | localhost | mytest | Query | 10 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000007 | | 686 | mikiya | localhost | mytest | Query | 10 | Locked | UPDATE LOW_PRIORITY t2 SET b=8 WHERE a BETWEEN 12000008 and 12100008 | | 687 | mikiya | localhost | mytest | Query | 10 | Locked | UPDATE LOW_PRIORITY t2 SET b=12000008 WHERE a=11992252 | | 688 | mikiya | localhost | mytest | Query | 10 | Locked | SELECT * FROM t2 WHERE a=11992252 | | 689 | mikiya | localhost | mytest | Query | 9 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000008 | | 690 | mikiya | localhost | mytest | Query | 9 | Locked | UPDATE LOW_PRIORITY t2 SET b=9 WHERE a BETWEEN 12000009 and 12100009 | | 691 | mikiya | localhost | mytest | Query | 9 | Locked | UPDATE LOW_PRIORITY t2 SET b=12000009 WHERE a=11992253 | | 692 | mikiya | localhost | mytest | Query | 9 | Locked | SELECT * FROM t2 WHERE a=11992253 | | 693 | mikiya | localhost | mytest | Query | 9 | Locked | SELECT HIGH_PRIORITY * FROM t2 WHERE a=12000009 | +-----+--------+-----------+--------+---------+-------+----------+----------------------------------------------------------------------+ 28 rows in set (0.00 sec)