mysql> show full processlist; +-------+-----------------+-------------------+--------------------+---------+-------+------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+-----------------+-------------------+--------------------+---------+-------+------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 2 | event_scheduler | localhost | NULL | Daemon | 24332 | Waiting on empty queue | NULL | | 37705 | windin | 127.0.0.1:55436 | livenewsselectness | Query | 1136 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('H0005') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 70,35 | | 40153 | windin | 127.0.0.1:33279 | livenewsselectness | Query | 1136 | update | insert into tb_livenews_section_disk (section,newsid,sourceid,channel,publishdate,lan) values(new.section,new.newsid,new.sourceid,new.channel,new.publishdate,new.lan) | | 40795 | windin | 127.0.0.1:59701 | livenewsselectness | Query | 1133 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0057') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 140,35 | | 40796 | windin | 127.0.0.1:59717 | livenewsselectness | Query | 1118 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0002') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 0,15 | | 40797 | windin | 127.0.0.1:59719 | livenewsselectness | Query | 1118 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('G0013','G0005','G0006','G0008') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 105,35 | | 40798 | windin | 127.0.0.1:59725 | livenewsselectness | Query | 1107 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0002') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 140,35 | | 40799 | windin | 127.0.0.1:59741 | livenewsselectness | Query | 1072 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0002') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 105,35 | | 40800 | windin | 127.0.0.1:59743 | livenewsselectness | Query | 1068 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0034') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 0,35 | | 40801 | windin | 127.0.0.1:59745 | livenewsselectness | Query | 1057 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('G0004') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 70,35 | | 40802 | windin | 127.0.0.1:59746 | livenewsselectness | Query | 1057 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0002') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 0,15 | | 40803 | windin | 127.0.0.1:59754 | livenewsselectness | Query | 1046 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0002') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 70,35 | | 40804 | windin | 127.0.0.1:59791 | livenewsselectness | Query | 1012 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0001') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 70,35 | | 40805 | windin | 127.0.0.1:59798 | livenewsselectness | Query | 1007 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0001') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 0,35 | | 40806 | windin | 127.0.0.1:59799 | livenewsselectness | Query | 997 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('G0004') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 70,35 | | 40807 | windin | 127.0.0.1:59810 | livenewsselectness | Query | 991 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0003') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 0,35 | | 40808 | windin | 127.0.0.1:59812 | livenewsselectness | Query | 991 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0034') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 0,35 | | 40809 | windin | 127.0.0.1:59819 | livenewsselectness | Query | 988 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0035') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 105,35 | | 40810 | windin | 127.0.0.1:59825 | livenewsselectness | Query | 986 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0057') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 105,35 | | 40811 | windin | 127.0.0.1:59840 | livenewsselectness | Query | 966 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0002') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 0,15 | | 40812 | windin | 127.0.0.1:53108 | livenewsselectness | Query | 944 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('G0011') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 35,35 | | 40813 | windin | 127.0.0.1:53110 | livenewsselectness | Query | 938 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('G0004') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 70,35 | | 40814 | windin | 127.0.0.1:53114 | livenewsselectness | Query | 929 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('G0017') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 70,35 | | 40815 | windin | 127.0.0.1:53115 | livenewsselectness | Query | 928 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('G0004') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 35,35 | | 40816 | windin | 127.0.0.1:53118 | livenewsselectness | Query | 926 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0051') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 70,35 | | 40817 | windin | 127.0.0.1:53143 | livenewsselectness | Query | 882 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0032') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 70,35 | | 40818 | windin | 127.0.0.1:53150 | livenewsselectness | Query | 869 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0003') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 35,35 | | 40819 | windin | 127.0.0.1:53152 | livenewsselectness | Query | 867 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('G0004') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 105,35 | | 40820 | windin | 127.0.0.1:53154 | livenewsselectness | Query | 865 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0034') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 105,35 | | 40821 | windin | 127.0.0.1:53185 | livenewsselectness | Query | 822 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0034') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 0,35 | | 40823 | windin | 127.0.0.1:53193 | livenewsselectness | Query | 806 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0051') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 70,35 | | 40824 | windin | 127.0.0.1:53195 | livenewsselectness | Query | 806 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('G0016') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 0,35 | | 40825 | windin | 127.0.0.1:53197 | livenewsselectness | Query | 803 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0032') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 70,35 | | 40826 | windin | 127.0.0.1:53238 | livenewsselectness | Query | 760 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0034') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 105,35 | | 40827 | windin | 127.0.0.1:53255 | livenewsselectness | Query | 746 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('G0011') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 105,35 | | 40828 | windin | 127.0.0.1:53258 | livenewsselectness | Query | 745 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('H0005') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 105,35 | | 40829 | windin | 127.0.0.1:53259 | livenewsselectness | Query | 743 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('G0003') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 0,35 | | 40830 | windin | 127.0.0.1:53261 | livenewsselectness | Query | 743 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('H0005') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 70,35 | | 40831 | windin | 127.0.0.1:53288 | livenewsselectness | Query | 700 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('G0013','G0005','G0006','G0008') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 0,35 | | 40832 | windin | 127.0.0.1:53296 | livenewsselectness | Query | 686 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('G0017') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 0,35 | | 40833 | windin | 127.0.0.1:53297 | livenewsselectness | Query | 685 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0032') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 35,35 | | 40834 | windin | 127.0.0.1:53304 | livenewsselectness | Query | 682 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0001') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 105,35 | | 40835 | windin | 127.0.0.1:53546 | livenewsselectness | Query | 638 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0051') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 35,35 | | 40836 | windin | 127.0.0.1:53559 | livenewsselectness | Query | 625 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('G0004') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 105,35 | | 40837 | windin | 127.0.0.1:53561 | livenewsselectness | Query | 625 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('G0002') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 70,35 | | 40838 | windin | 127.0.0.1:53572 | livenewsselectness | Query | 623 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('G0003') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 0,35 | | 40839 | windin | 127.0.0.1:53573 | livenewsselectness | Query | 622 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0035') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 0,35 | | 40840 | windin | 127.0.0.1:53611 | livenewsselectness | Query | 572 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0033') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 70,35 | | 40841 | windin | 127.0.0.1:53623 | livenewsselectness | Query | 565 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('G0004') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 70,35 | | 40842 | windin | 127.0.0.1:53624 | livenewsselectness | Query | 565 | Locked | select distinct tb_livenews_section_mem.newsid from tb_livenews_section_mem where tb_livenews_section_mem.section in ('A0032') order by tb_livenews_section_mem.publishdate desc,tb_livenews_section_mem.newsid desc limit 105,35 | | 40843 | windin | 10.100.3.26:4906 | livenewscommon | Sleep | 61 | | NULL | | 40844 | windin | 10.100.1.72:36456 | NULL | Query | 0 | NULL | show full processlist | +-------+-----------------+-------------------+--------------------+---------+-------+------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 52 rows in set (0.01 sec)