今天上午10点左右，正准备参加oracle的一个网络研讨会，结果，系统又出现了堵塞的情况。看看系统当时在干吗
1 mysql> show processlist;
2 +——-+————-+——————–+———+———+——+———————————–+——————————————————————————————————+
3 | Id | User | Host | db | Command | Time | State | Info |
4 +——-+————-+——————–+———+———+——+———————————–+——————————————————————————————————+
5 | 1 | system user | | | Daemon | 0 | Waiting for event from ndbcluster | NULL |
6 | 10044 | session | localhost:58941 | session | Query | 1 | closing tables | insert into session(sky_id, user_name, nick_name, nick_name1, gender, age, portrait_id, token, provi |
7 | 10045 | session | localhost:58942 | session | Query | 1 | Opening tables | insert into session(sky_id, user_name, nick_name, nick_name1, gender, age, portrait_id, token, provi |
8 | 10046 | session | localhost:58943 | session | Query | 1 | Opening tables | insert into session(sky_id, user_name, nick_name, nick_name1, gender, age, portrait_id, token, provi |
9 | 10047 | session | localhost:58944 | session | Query | 2 | closing tables | select * from session where sky_id=124845460 |
10 | 10048 | session | localhost:58945 | session | Query | 1 | Opening tables | select * from session where sky_id in (111632535,0) |
11 | 10049 | session | localhost:58946 | session | Query | 4 | closing tables | select * from session where sky_id in (121003591,0) |
12 | 10050 | session | localhost:58947 | session | Query | 2 | closing tables | select * from session where sky_id in (109077997,0) |
13 | 10051 | session | localhost:58948 | session | Query | 1 | closing tables | select * from session where sky_id=120590438 |
14 | 10052 | session | localhost:58949 | session | Query | 1 | Opening tables | update access set acc_state=0, update_time=1274926614 where acc_addr=38952 |
15 | 10053 | session | localhost:58950 | session | Query | 2 | Opening tables | insert into session(sky_id, user_name, nick_name, nick_name1, gender, age, portrait_id, token, provi |
16 | 10054 | session | localhost:58951 | session | Query | 2 | Opening tables | select * from session where sky_id in (126785023,0) |
17 | 10055 | session | localhost:58952 | session | Query | 2 | closing tables | update session set pos_code=41280 , pos_desc=’??????? – ????’ where sky_id=125 |
18 | 10056 | session | localhost:58953 | session | Query | 2 | closing tables | select * from session where sky_id=122892277 |
19 | 10057 | session | localhost:58954 | session | Query | 1 | Opening tables | insert into session(sky_id, user_name, nick_name, nick_name1, gender, age, portrait_id, token, provi |
20 | 10058 | session | localhost:58955 | session | Query | 2 | Opening tables | select * from session where sky_id in (110471422,0) |
21 | 10059 | session | localhost:58956 | session | Query | 3 | closing tables | select * from session where sky_id in (112560231,0) |
22 | 10060 | session | localhost:58957 | session | Query | 1 | Opening tables | select * from session where sky_id=125792895 |
23 | 10061 | session | localhost:58958 | session | Query | 1 | Opening tables | select acc_state from access where acc_addr=39045 |
24 | 10062 | session | localhost:58959 | session | Query | 3 | closing tables | select * from session where sky_id in (101879399,0) |
25 | 10063 | session | localhost:58960 | session | Query | 1 | Opening tables | select * from session where sky_id=126830482 |
26 | 10064 | session | localhost:58961 | session | Query | 1 | Opening tables | select * from session where sky_id=123943933 |
27 | 10065 | session | localhost:58962 | session | Query | 1 | Opening tables | select * from session where sky_id=126898963 |
28 | 10066 | session | localhost:58963 | session | Query | 1 | closing tables | select * from session where sky_id=109099740 |
29 | 10067 | session | localhost:58964 | session | Query | 1 | Opening tables | select * from session where sky_id in (119894995,0) |
30 | 10068 | session | localhost:58965 | session | Query | 2 | closing tables | delete from session where sky_id=126556735 |
31 | 10069 | session | localhost:58966 | session | Query | 3 | closing tables | select * from session where sky_id in (118097526,0) |
32 | 10070 | session | localhost:58967 | session | Query | 1 | Opening tables | select acc_state from access where acc_addr=38913 |
33 | 10071 | session | localhost:58968 | session | Query | 1 | Opening tables | select * from session where sky_id=123152695 |
34 | 10072 | session | localhost:58969 | session | Query | 2 | closing tables | select * from session where sky_id=124863995 |
35 | 10073 | session | localhost:58970 | session | Query | 2 | closing tables | select * from session where sky_id=124845484 |
36 | 10074 | session | localhost:58971 | session | Query | 1 | Opening tables | select * from session where sky_id in (123835360,0) |
37 | 10075 | session | localhost:58972 | session | Query | 2 | closing tables | select * from session where sky_id in (123975391,0) |
38 | 10076 | session | localhost:58973 | session | Query | 2 | closing tables | select * from session where sky_id in (118881656,0) |
39 | 10077 | session | localhost:58974 | session | Query | 2 | closing tables | select * from session where sky_id in (108121954,0) |
40 | 10078 | session | localhost:58975 | session | Query | 1 | closing tables | select * from session where sky_id=121395441 |
41 | 10079 | session | localhost:58976 | session | Query | 2 | Opening tables | select * from session where sky_id in (123468430,0) |
42 | 10080 | session | localhost:58977 | session | Query | 2 | Opening tables | select * from session where sky_id in (120744279,0) |
43 | 10081 | session | localhost:58978 | session | Query | 2 | closing tables | select * from session where sky_id in (124513205,0) |
44 | 10082 | session | localhost:58979 | session | Query | 1 | Opening tables | select * from session where sky_id in (108639095,0) |
45 | 10083 | session | localhost:58980 | session | Query | 2 | Opening tables | select * from session where sky_id=122634881 |
46 | 10084 | session | localhost:58981 | session | Query | 1 | Opening tables | select * from session where sky_id=108865098 |
47 | 10085 | session | localhost:58982 | session | Query | 3 | closing tables | select * from session where sky_id in (118117228,0) |
48 | 10086 | session | localhost:58983 | session | Query | 2 | Opening tables | select * from session where sky_id in (120903327,0) |
49 | 10087 | session | localhost:58984 | session | Query | 5 | closing tables | select * from session where sky_id in (117771831,0) |
50 | 10088 | session | localhost:58985 | session | Query | 1 | Opening tables | select * from session where sky_id in (101143532,0) |
51 | 10089 | session | localhost:58986 | session | Query | 1 | Opening tables | insert into session(sky_id, user_name, nick_name, nick_name1, gender, age, portrait_id, token, provi |
52 | 10090 | session | localhost:58987 | session | Query | 3 | closing tables | select * from session where sky_id=125284199 |
53 | 10091 | session | localhost:58988 | session | Query | 1 | closing tables | select * from session where sky_id in (112197775,0) |
54 | 10092 | session | localhost:58989 | session | Query | 2 | closing tables | select * from session where sky_id in (119670638,0) |
55 | 10093 | session | localhost:58990 | session | Query | 0 | Opening tables | select * from session where sky_id=122174655 |
56 | 10094 | session | localhost:58991 | session | Query | 1 | closing tables | select * from session where sky_id=107754958 |
57 | 10095 | session | localhost:58992 | session | Query | 1 | Opening tables | select * from session where sky_id=124731148 |
58 | 10096 | session | localhost:58993 | session | Query | 1 | Opening tables | select * from session where sky_id in (102387333,0) |
59 | 10097 | session | localhost:58994 | session | Query | 1 | Opening tables | select * from session where sky_id=125736384 |
60 | 10098 | session | localhost:58995 | session | Query | 2 | Opening tables | select * from session where sky_id in (112651179,0) |
61 | 10099 | session | localhost:58996 | session | Query | 1 | closing tables | select * from session where sky_id in (124550937,0) |
62 | 10100 | session | localhost:58997 | session | Query | 1 | Opening tables | select * from session where sky_id in (124550775,0) |
63 | 10101 | session | localhost:58998 | session | Query | 1 | closing tables | select * from session where sky_id in (110934430,0) |
64 | 10102 | session | localhost:58999 | session | Query | 2 | Opening tables | select * from session where sky_id=112118211 |
65 | 10103 | session | localhost:59000 | session | Query | 2 | Opening tables | select * from session where sky_id in (123846550,0) |
66 | 10550 | session | 192.168.3.29:44979 | session | Sleep | 29 | | NULL |
67 | 10566 | session | 192.168.3.53:45132 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
68 | 10567 | session | 192.168.3.53:45133 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
69 | 10568 | session | 192.168.3.53:45134 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
70 | 10569 | session | 192.168.3.53:45135 | session | Query | 4 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
71 | 10570 | session | 192.168.3.53:45136 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
72 | 10571 | session | 192.168.3.53:45137 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
73 | 10572 | session | 192.168.3.53:45138 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
74 | 10573 | session | 192.168.3.53:45139 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
75 | 10574 | session | 192.168.3.53:45140 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
76 | 10575 | session | 192.168.3.53:45141 | session | Query | 0 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
77 | 10576 | session | 192.168.3.53:45142 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
78 | 10577 | session | 192.168.3.53:45143 | session | Query | 2 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
79 | 10578 | session | 192.168.3.53:45144 | session | Query | 2 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
80 | 10579 | session | 192.168.3.53:45145 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
81 | 10580 | session | 192.168.3.53:45146 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
82 | 10581 | session | 192.168.3.53:45147 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
83 | 10582 | session | 192.168.3.53:45148 | session | Query | 2 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
84 | 10583 | session | 192.168.3.53:45149 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
85 | 10584 | session | 192.168.3.53:45151 | session | Query | 2 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
86 | 10585 | session | 192.168.3.53:45152 | session | Query | 2 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
87 | 10586 | session | 192.168.3.53:45153 | session | Query | 6 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
88 | 10587 | session | 192.168.3.53:45154 | session | Query | 2 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
89 | 10588 | session | 192.168.3.53:45155 | session | Query | 2 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
90 | 10589 | session | 192.168.3.53:45156 | session | Query | 5 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
91 | 10590 | session | 192.168.3.53:45157 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
92 | 10591 | session | 192.168.3.53:45158 | session | Query | 2 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
93 | 10592 | session | 192.168.3.53:45159 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
94 | 10593 | session | 192.168.3.53:45160 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
95 | 10594 | session | 192.168.3.53:45161 | session | Query | 2 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
96 | 10595 | session | 192.168.3.53:45162 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
97 | 10596 | session | 192.168.3.53:45163 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
98 | 10597 | session | 192.168.3.53:45164 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
99 | 10598 | session | 192.168.3.53:51053 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
100 | 10599 | session | 192.168.3.53:51054 | session | Query | 2 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
101 | 10600 | session | 192.168.3.53:51059 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
102 | 10601 | session | 192.168.3.53:51060 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
103 | 10602 | session | 192.168.3.53:51063 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
104 | 10603 | session | 192.168.3.53:51067 | session | Query | 0 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
105 | 10604 | session | 192.168.3.53:51069 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
106 | 10605 | session | 192.168.3.53:51070 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
107 | 10606 | session | 192.168.3.53:51073 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
108 | 10607 | session | 192.168.3.53:51077 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
109 | 10608 | session | 192.168.3.53:51078 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
110 | 10609 | session | 192.168.3.53:51081 | session | Query | 4 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
111 | 10610 | session | 192.168.3.53:51082 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
112 | 10611 | session | 192.168.3.53:51083 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
113 | 10612 | session | 192.168.3.53:51087 | session | Query | 2 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
114 | 10613 | session | 192.168.3.53:51088 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
115 | 10614 | session | 192.168.3.53:51091 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
116 | 10615 | session | 192.168.3.53:51093 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
117 | 10616 | session | 192.168.3.53:51095 | session | Query | 2 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
118 | 10617 | session | 192.168.3.53:51096 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
119 | 10618 | session | 192.168.3.53:51098 | session | Query | 3 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
120 | 10619 | session | 192.168.3.53:51101 | session | Query | 4 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
121 | 10620 | session | 192.168.3.53:51102 | session | Query | 2 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
122 | 10621 | session | 192.168.3.53:51106 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
123 | 10622 | session | 192.168.3.53:51109 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
124 | 10623 | session | 192.168.3.53:51111 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
125 | 10624 | session | 192.168.3.53:51113 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
126 | 10625 | session | 192.168.3.53:51116 | session | Query | 3 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
127 | 10626 | session | 192.168.3.53:51118 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
128 | 10627 | session | 192.168.3.53:51119 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
129 | 10628 | session | 192.168.3.53:51120 | session | Query | 0 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
130 | 10629 | session | 192.168.3.53:51121 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
131 | 10630 | session | 192.168.3.53:51122 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
132 | 10631 | session | 192.168.3.53:51125 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
133 | 10632 | session | 192.168.3.53:51126 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
134 | 10633 | session | 192.168.3.53:51130 | session | Query | 2 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
135 | 10634 | session | 192.168.3.53:51131 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
136 | 10635 | session | 192.168.3.53:51132 | session | Query | 2 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
137 | 10636 | session | 192.168.3.53:51138 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
138 | 10637 | session | 192.168.3.53:51139 | session | Query | 2 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
139 | 10638 | session | 192.168.3.53:51140 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
140 | 10639 | session | 192.168.3.53:51141 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
141 | 10640 | session | 192.168.3.53:51142 | session | Query | 4 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
142 | 10641 | session | 192.168.3.53:51143 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
143 | 10642 | session | 192.168.3.53:51144 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
144 | 10643 | session | 192.168.3.53:51146 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
145 | 10644 | session | 192.168.3.53:51147 | session | Query | 5 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
146 | 10645 | session | 192.168.3.53:51151 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
147 | 10646 | session | 192.168.3.53:51152 | session | Query | 2 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
148 | 10647 | session | 192.168.3.53:51157 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
149 | 10648 | session | 192.168.3.53:51158 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
150 | 10649 | session | 192.168.3.53:51159 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
151 | 10650 | session | 192.168.3.53:51161 | session | Query | 2 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
152 | 10651 | session | 192.168.3.53:51162 | session | Query | 2 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
153 | 10652 | session | 192.168.3.53:51172 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
154 | 10653 | session | 192.168.3.53:51173 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
155 | 10654 | session | 192.168.3.53:51176 | session | Query | 2 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
156 | 10655 | session | 192.168.3.53:51178 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
157 | 10656 | session | 192.168.3.53:51180 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
158 | 10657 | session | 192.168.3.53:51184 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
159 | 10658 | session | 192.168.3.53:51185 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
160 | 10659 | session | 192.168.3.53:51187 | session | Query | 4 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
161 | 10660 | session | 192.168.3.53:51190 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
162 | 10661 | session | 192.168.3.53:51191 | session | Query | 2 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
163 | 10663 | session | 192.168.3.29:40779 | session | Sleep | 28 | | NULL |
164 | 14144 | session | 192.168.3.29:33168 | session | Sleep | 28 | | NULL |
165 | 14147 | session | 192.168.3.29:33238 | session | Query | 1 | Opening tables | select * from session where sky_id=126899311 |
166 | 14164 | session | 192.168.3.29:44682 | session | Query | 1 | Opening tables | update session set longitude=11351329,latitude=2230310,loc_desc=”,city=” where sky_id=126812291 |
167 | 14174 | root | localhost | session | Query | 0 | NULL | show processlist |
168 | 14234 | session | 192.168.3.29:50465 | session | Sleep | 27 | | NULL |
169 +——-+————-+——————–+———+———+——+———————————–+——————————————————————————————————+
170 164 rows in set (0.00 sec)
2 +——-+————-+——————–+———+———+——+———————————–+——————————————————————————————————+
3 | Id | User | Host | db | Command | Time | State | Info |
4 +——-+————-+——————–+———+———+——+———————————–+——————————————————————————————————+
5 | 1 | system user | | | Daemon | 0 | Waiting for event from ndbcluster | NULL |
6 | 10044 | session | localhost:58941 | session | Query | 1 | closing tables | insert into session(sky_id, user_name, nick_name, nick_name1, gender, age, portrait_id, token, provi |
7 | 10045 | session | localhost:58942 | session | Query | 1 | Opening tables | insert into session(sky_id, user_name, nick_name, nick_name1, gender, age, portrait_id, token, provi |
8 | 10046 | session | localhost:58943 | session | Query | 1 | Opening tables | insert into session(sky_id, user_name, nick_name, nick_name1, gender, age, portrait_id, token, provi |
9 | 10047 | session | localhost:58944 | session | Query | 2 | closing tables | select * from session where sky_id=124845460 |
10 | 10048 | session | localhost:58945 | session | Query | 1 | Opening tables | select * from session where sky_id in (111632535,0) |
11 | 10049 | session | localhost:58946 | session | Query | 4 | closing tables | select * from session where sky_id in (121003591,0) |
12 | 10050 | session | localhost:58947 | session | Query | 2 | closing tables | select * from session where sky_id in (109077997,0) |
13 | 10051 | session | localhost:58948 | session | Query | 1 | closing tables | select * from session where sky_id=120590438 |
14 | 10052 | session | localhost:58949 | session | Query | 1 | Opening tables | update access set acc_state=0, update_time=1274926614 where acc_addr=38952 |
15 | 10053 | session | localhost:58950 | session | Query | 2 | Opening tables | insert into session(sky_id, user_name, nick_name, nick_name1, gender, age, portrait_id, token, provi |
16 | 10054 | session | localhost:58951 | session | Query | 2 | Opening tables | select * from session where sky_id in (126785023,0) |
17 | 10055 | session | localhost:58952 | session | Query | 2 | closing tables | update session set pos_code=41280 , pos_desc=’??????? – ????’ where sky_id=125 |
18 | 10056 | session | localhost:58953 | session | Query | 2 | closing tables | select * from session where sky_id=122892277 |
19 | 10057 | session | localhost:58954 | session | Query | 1 | Opening tables | insert into session(sky_id, user_name, nick_name, nick_name1, gender, age, portrait_id, token, provi |
20 | 10058 | session | localhost:58955 | session | Query | 2 | Opening tables | select * from session where sky_id in (110471422,0) |
21 | 10059 | session | localhost:58956 | session | Query | 3 | closing tables | select * from session where sky_id in (112560231,0) |
22 | 10060 | session | localhost:58957 | session | Query | 1 | Opening tables | select * from session where sky_id=125792895 |
23 | 10061 | session | localhost:58958 | session | Query | 1 | Opening tables | select acc_state from access where acc_addr=39045 |
24 | 10062 | session | localhost:58959 | session | Query | 3 | closing tables | select * from session where sky_id in (101879399,0) |
25 | 10063 | session | localhost:58960 | session | Query | 1 | Opening tables | select * from session where sky_id=126830482 |
26 | 10064 | session | localhost:58961 | session | Query | 1 | Opening tables | select * from session where sky_id=123943933 |
27 | 10065 | session | localhost:58962 | session | Query | 1 | Opening tables | select * from session where sky_id=126898963 |
28 | 10066 | session | localhost:58963 | session | Query | 1 | closing tables | select * from session where sky_id=109099740 |
29 | 10067 | session | localhost:58964 | session | Query | 1 | Opening tables | select * from session where sky_id in (119894995,0) |
30 | 10068 | session | localhost:58965 | session | Query | 2 | closing tables | delete from session where sky_id=126556735 |
31 | 10069 | session | localhost:58966 | session | Query | 3 | closing tables | select * from session where sky_id in (118097526,0) |
32 | 10070 | session | localhost:58967 | session | Query | 1 | Opening tables | select acc_state from access where acc_addr=38913 |
33 | 10071 | session | localhost:58968 | session | Query | 1 | Opening tables | select * from session where sky_id=123152695 |
34 | 10072 | session | localhost:58969 | session | Query | 2 | closing tables | select * from session where sky_id=124863995 |
35 | 10073 | session | localhost:58970 | session | Query | 2 | closing tables | select * from session where sky_id=124845484 |
36 | 10074 | session | localhost:58971 | session | Query | 1 | Opening tables | select * from session where sky_id in (123835360,0) |
37 | 10075 | session | localhost:58972 | session | Query | 2 | closing tables | select * from session where sky_id in (123975391,0) |
38 | 10076 | session | localhost:58973 | session | Query | 2 | closing tables | select * from session where sky_id in (118881656,0) |
39 | 10077 | session | localhost:58974 | session | Query | 2 | closing tables | select * from session where sky_id in (108121954,0) |
40 | 10078 | session | localhost:58975 | session | Query | 1 | closing tables | select * from session where sky_id=121395441 |
41 | 10079 | session | localhost:58976 | session | Query | 2 | Opening tables | select * from session where sky_id in (123468430,0) |
42 | 10080 | session | localhost:58977 | session | Query | 2 | Opening tables | select * from session where sky_id in (120744279,0) |
43 | 10081 | session | localhost:58978 | session | Query | 2 | closing tables | select * from session where sky_id in (124513205,0) |
44 | 10082 | session | localhost:58979 | session | Query | 1 | Opening tables | select * from session where sky_id in (108639095,0) |
45 | 10083 | session | localhost:58980 | session | Query | 2 | Opening tables | select * from session where sky_id=122634881 |
46 | 10084 | session | localhost:58981 | session | Query | 1 | Opening tables | select * from session where sky_id=108865098 |
47 | 10085 | session | localhost:58982 | session | Query | 3 | closing tables | select * from session where sky_id in (118117228,0) |
48 | 10086 | session | localhost:58983 | session | Query | 2 | Opening tables | select * from session where sky_id in (120903327,0) |
49 | 10087 | session | localhost:58984 | session | Query | 5 | closing tables | select * from session where sky_id in (117771831,0) |
50 | 10088 | session | localhost:58985 | session | Query | 1 | Opening tables | select * from session where sky_id in (101143532,0) |
51 | 10089 | session | localhost:58986 | session | Query | 1 | Opening tables | insert into session(sky_id, user_name, nick_name, nick_name1, gender, age, portrait_id, token, provi |
52 | 10090 | session | localhost:58987 | session | Query | 3 | closing tables | select * from session where sky_id=125284199 |
53 | 10091 | session | localhost:58988 | session | Query | 1 | closing tables | select * from session where sky_id in (112197775,0) |
54 | 10092 | session | localhost:58989 | session | Query | 2 | closing tables | select * from session where sky_id in (119670638,0) |
55 | 10093 | session | localhost:58990 | session | Query | 0 | Opening tables | select * from session where sky_id=122174655 |
56 | 10094 | session | localhost:58991 | session | Query | 1 | closing tables | select * from session where sky_id=107754958 |
57 | 10095 | session | localhost:58992 | session | Query | 1 | Opening tables | select * from session where sky_id=124731148 |
58 | 10096 | session | localhost:58993 | session | Query | 1 | Opening tables | select * from session where sky_id in (102387333,0) |
59 | 10097 | session | localhost:58994 | session | Query | 1 | Opening tables | select * from session where sky_id=125736384 |
60 | 10098 | session | localhost:58995 | session | Query | 2 | Opening tables | select * from session where sky_id in (112651179,0) |
61 | 10099 | session | localhost:58996 | session | Query | 1 | closing tables | select * from session where sky_id in (124550937,0) |
62 | 10100 | session | localhost:58997 | session | Query | 1 | Opening tables | select * from session where sky_id in (124550775,0) |
63 | 10101 | session | localhost:58998 | session | Query | 1 | closing tables | select * from session where sky_id in (110934430,0) |
64 | 10102 | session | localhost:58999 | session | Query | 2 | Opening tables | select * from session where sky_id=112118211 |
65 | 10103 | session | localhost:59000 | session | Query | 2 | Opening tables | select * from session where sky_id in (123846550,0) |
66 | 10550 | session | 192.168.3.29:44979 | session | Sleep | 29 | | NULL |
67 | 10566 | session | 192.168.3.53:45132 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
68 | 10567 | session | 192.168.3.53:45133 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
69 | 10568 | session | 192.168.3.53:45134 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
70 | 10569 | session | 192.168.3.53:45135 | session | Query | 4 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
71 | 10570 | session | 192.168.3.53:45136 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
72 | 10571 | session | 192.168.3.53:45137 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
73 | 10572 | session | 192.168.3.53:45138 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
74 | 10573 | session | 192.168.3.53:45139 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
75 | 10574 | session | 192.168.3.53:45140 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
76 | 10575 | session | 192.168.3.53:45141 | session | Query | 0 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
77 | 10576 | session | 192.168.3.53:45142 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
78 | 10577 | session | 192.168.3.53:45143 | session | Query | 2 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
79 | 10578 | session | 192.168.3.53:45144 | session | Query | 2 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
80 | 10579 | session | 192.168.3.53:45145 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
81 | 10580 | session | 192.168.3.53:45146 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
82 | 10581 | session | 192.168.3.53:45147 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
83 | 10582 | session | 192.168.3.53:45148 | session | Query | 2 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
84 | 10583 | session | 192.168.3.53:45149 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
85 | 10584 | session | 192.168.3.53:45151 | session | Query | 2 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
86 | 10585 | session | 192.168.3.53:45152 | session | Query | 2 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
87 | 10586 | session | 192.168.3.53:45153 | session | Query | 6 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
88 | 10587 | session | 192.168.3.53:45154 | session | Query | 2 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
89 | 10588 | session | 192.168.3.53:45155 | session | Query | 2 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
90 | 10589 | session | 192.168.3.53:45156 | session | Query | 5 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
91 | 10590 | session | 192.168.3.53:45157 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
92 | 10591 | session | 192.168.3.53:45158 | session | Query | 2 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
93 | 10592 | session | 192.168.3.53:45159 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
94 | 10593 | session | 192.168.3.53:45160 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
95 | 10594 | session | 192.168.3.53:45161 | session | Query | 2 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
96 | 10595 | session | 192.168.3.53:45162 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
97 | 10596 | session | 192.168.3.53:45163 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
98 | 10597 | session | 192.168.3.53:45164 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
99 | 10598 | session | 192.168.3.53:51053 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
100 | 10599 | session | 192.168.3.53:51054 | session | Query | 2 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
101 | 10600 | session | 192.168.3.53:51059 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
102 | 10601 | session | 192.168.3.53:51060 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
103 | 10602 | session | 192.168.3.53:51063 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
104 | 10603 | session | 192.168.3.53:51067 | session | Query | 0 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
105 | 10604 | session | 192.168.3.53:51069 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
106 | 10605 | session | 192.168.3.53:51070 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
107 | 10606 | session | 192.168.3.53:51073 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
108 | 10607 | session | 192.168.3.53:51077 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
109 | 10608 | session | 192.168.3.53:51078 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
110 | 10609 | session | 192.168.3.53:51081 | session | Query | 4 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
111 | 10610 | session | 192.168.3.53:51082 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
112 | 10611 | session | 192.168.3.53:51083 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
113 | 10612 | session | 192.168.3.53:51087 | session | Query | 2 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
114 | 10613 | session | 192.168.3.53:51088 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
115 | 10614 | session | 192.168.3.53:51091 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
116 | 10615 | session | 192.168.3.53:51093 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
117 | 10616 | session | 192.168.3.53:51095 | session | Query | 2 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
118 | 10617 | session | 192.168.3.53:51096 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
119 | 10618 | session | 192.168.3.53:51098 | session | Query | 3 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
120 | 10619 | session | 192.168.3.53:51101 | session | Query | 4 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
121 | 10620 | session | 192.168.3.53:51102 | session | Query | 2 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
122 | 10621 | session | 192.168.3.53:51106 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
123 | 10622 | session | 192.168.3.53:51109 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
124 | 10623 | session | 192.168.3.53:51111 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
125 | 10624 | session | 192.168.3.53:51113 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
126 | 10625 | session | 192.168.3.53:51116 | session | Query | 3 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
127 | 10626 | session | 192.168.3.53:51118 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
128 | 10627 | session | 192.168.3.53:51119 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
129 | 10628 | session | 192.168.3.53:51120 | session | Query | 0 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
130 | 10629 | session | 192.168.3.53:51121 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
131 | 10630 | session | 192.168.3.53:51122 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
132 | 10631 | session | 192.168.3.53:51125 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
133 | 10632 | session | 192.168.3.53:51126 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
134 | 10633 | session | 192.168.3.53:51130 | session | Query | 2 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
135 | 10634 | session | 192.168.3.53:51131 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
136 | 10635 | session | 192.168.3.53:51132 | session | Query | 2 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
137 | 10636 | session | 192.168.3.53:51138 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
138 | 10637 | session | 192.168.3.53:51139 | session | Query | 2 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
139 | 10638 | session | 192.168.3.53:51140 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
140 | 10639 | session | 192.168.3.53:51141 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
141 | 10640 | session | 192.168.3.53:51142 | session | Query | 4 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
142 | 10641 | session | 192.168.3.53:51143 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
143 | 10642 | session | 192.168.3.53:51144 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
144 | 10643 | session | 192.168.3.53:51146 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
145 | 10644 | session | 192.168.3.53:51147 | session | Query | 5 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
146 | 10645 | session | 192.168.3.53:51151 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
147 | 10646 | session | 192.168.3.53:51152 | session | Query | 2 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
148 | 10647 | session | 192.168.3.53:51157 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
149 | 10648 | session | 192.168.3.53:51158 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
150 | 10649 | session | 192.168.3.53:51159 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
151 | 10650 | session | 192.168.3.53:51161 | session | Query | 2 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
152 | 10651 | session | 192.168.3.53:51162 | session | Query | 2 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
153 | 10652 | session | 192.168.3.53:51172 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
154 | 10653 | session | 192.168.3.53:51173 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
155 | 10654 | session | 192.168.3.53:51176 | session | Query | 2 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
156 | 10655 | session | 192.168.3.53:51178 | session | Query | 1 | Opening tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
157 | 10656 | session | 192.168.3.53:51180 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
158 | 10657 | session | 192.168.3.53:51184 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
159 | 10658 | session | 192.168.3.53:51185 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
160 | 10659 | session | 192.168.3.53:51187 | session | Query | 4 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
161 | 10660 | session | 192.168.3.53:51190 | session | Query | 3 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
162 | 10661 | session | 192.168.3.53:51191 | session | Query | 2 | closing tables | select sky_id, nick_name, gender, age, portrait_id, province, pos_desc, loc_desc, last_oltime, login |
163 | 10663 | session | 192.168.3.29:40779 | session | Sleep | 28 | | NULL |
164 | 14144 | session | 192.168.3.29:33168 | session | Sleep | 28 | | NULL |
165 | 14147 | session | 192.168.3.29:33238 | session | Query | 1 | Opening tables | select * from session where sky_id=126899311 |
166 | 14164 | session | 192.168.3.29:44682 | session | Query | 1 | Opening tables | update session set longitude=11351329,latitude=2230310,loc_desc=”,city=” where sky_id=126812291 |
167 | 14174 | root | localhost | session | Query | 0 | NULL | show processlist |
168 | 14234 | session | 192.168.3.29:50465 | session | Sleep | 27 | | NULL |
169 +——-+————-+——————–+———+———+——+———————————–+——————————————————————————————————+
170 164 rows in set (0.00 sec)
居然一堆的进程在等待这两个事件。
