当时的processlist的信息如下:
1
2 2010-05-25 23:50:01
3 Id User Host db Command Time State Info
4 1 system user Daemon 0 Waiting for event from ndbcluster NULL
5 10044 session localhost:58941 session Sleep 23 NULL
6 10045 session localhost:58942 session Sleep 23 NULL
7 10046 session localhost:58943 session Sleep 22 NULL
8 10047 session localhost:58944 session Sleep 22 NULL
9 10048 session localhost:58945 session Sleep 22 NULL
10 10049 session localhost:58946 session Sleep 22 NULL
11 10050 session localhost:58947 session Sleep 22 NULL
12 10051 session localhost:58948 session Sleep 22 NULL
13 10052 session localhost:58949 session Sleep 23 NULL
14 10053 session localhost:58950 session Sleep 23 NULL
15 10054 session localhost:58951 session Sleep 23 NULL
16 10055 session localhost:58952 session Sleep 22 NULL
17 10056 session localhost:58953 session Sleep 22 NULL
18 10057 session localhost:58954 session Sleep 23 NULL
19 10058 session localhost:58955 session Sleep 22 NULL
20 10059 session localhost:58956 session Sleep 22 NULL
21 10060 session localhost:58957 session Sleep 22 NULL
22 10061 session localhost:58958 session Sleep 23 NULL
23 10062 session localhost:58959 session Sleep 23 NULL
24 10063 session localhost:58960 session Sleep 23 NULL
25 10064 session localhost:58961 session Sleep 23 NULL
26 10065 session localhost:58962 session Sleep 22 NULL
27 10066 session localhost:58963 session Sleep 22 NULL
28 10067 session localhost:58964 session Sleep 22 NULL
29 10068 session localhost:58965 session Sleep 22 NULL
30 10069 session localhost:58966 session Sleep 23 NULL
31 10070 session localhost:58967 session Sleep 23 NULL
32 10071 session localhost:58968 session Sleep 23 NULL
33 10072 session localhost:58969 session Sleep 22 NULL
34 10073 session localhost:58970 session Sleep 22 NULL
35 10074 session localhost:58971 session Sleep 22 NULL
36 10075 session localhost:58972 session Sleep 23 NULL
37 10076 session localhost:58973 session Sleep 22 NULL
38 10077 session localhost:58974 session Sleep 23 NULL
39 10078 session localhost:58975 session Sleep 22 NULL
40 10079 session localhost:58976 session Sleep 22 NULL
41 10080 session localhost:58977 session Sleep 23 NULL
42 10081 session localhost:58978 session Sleep 22 NULL
43 10082 session localhost:58979 session Sleep 23 NULL
44 10083 session localhost:58980 session Sleep 22 NULL
45 10084 session localhost:58981 session Sleep 22 NULL
46 10085 session localhost:58982 session Sleep 22 NULL
47 10086 session localhost:58983 session Sleep 22 NULL
48 10087 session localhost:58984 session Sleep 22 NULL
49 10088 session localhost:58985 session Sleep 22 NULL
50 10089 session localhost:58986 session Sleep 22 NULL
51 10090 session localhost:58987 session Sleep 22 NULL
52 10091 session localhost:58988 session Sleep 23 NULL
53 10092 session localhost:58989 session Sleep 22 NULL
54 10093 session localhost:58990 session Sleep 23 NULL
55 10094 session localhost:58991 session Sleep 22 NULL
56 10095 session localhost:58992 session Sleep 23 NULL
57 10096 session localhost:58993 session Sleep 23 NULL
58 10097 session localhost:58994 session Sleep 23 NULL
59 10098 session localhost:58995 session Sleep 22 NULL
60 10099 session localhost:58996 session Sleep 23 NULL
61 10100 session localhost:58997 session Sleep 22 NULL
62 10101 session localhost:58998 session Sleep 22 NULL
63 10102 session localhost:58999 session Sleep 22 NULL
64 10103 session localhost:59000 session Sleep 23 NULL
65 10550 session 192.168.3.29:44979 session Sleep 652 NULL
66 10566 session 192.168.3.53:45132 session Sleep 23 NULL
67 10567 session 192.168.3.53:45133 session Sleep 25 NULL
68 10568 session 192.168.3.53:45134 session Sleep 23 NULL
69 10569 session 192.168.3.53:45135 session Sleep 20 NULL
70 10570 session 192.168.3.53:45136 session Sleep 25 NULL
71 10571 session 192.168.3.53:45137 session Sleep 15 NULL
72 10572 session 192.168.3.53:45138 session Sleep 23 NULL
73 10573 session 192.168.3.53:45139 session Sleep 23 NULL
74 10574 session 192.168.3.53:45140 session Sleep 24 NULL
75 10575 session 192.168.3.53:45141 session Sleep 24 NULL
76 10576 session 192.168.3.53:45142 session Sleep 24 NULL
77 10577 session 192.168.3.53:45143 session Sleep 24 NULL
78 10578 session 192.168.3.53:45144 session Sleep 18 NULL
79 10579 session 192.168.3.53:45145 session Sleep 16 NULL
80 10580 session 192.168.3.53:45146 session Sleep 23 NULL
81 10581 session 192.168.3.53:45147 session Sleep 24 NULL
82 10582 session 192.168.3.53:45148 session Sleep 24 NULL
83 10583 session 192.168.3.53:45149 session Sleep 25 NULL
84 10584 session 192.168.3.53:45151 session Sleep 23 NULL
85 10585 session 192.168.3.53:45152 session Sleep 24 NULL
86 10586 session 192.168.3.53:45153 session Sleep 25 NULL
87 10587 session 192.168.3.53:45154 session Sleep 24 NULL
88 10588 session 192.168.3.53:45155 session Sleep 25 NULL
89 10589 session 192.168.3.53:45156 session Sleep 25 NULL
90 10590 session 192.168.3.53:45157 session Sleep 24 NULL
91 10591 session 192.168.3.53:45158 session Sleep 24 NULL
92 10592 session 192.168.3.53:45159 session Sleep 24 NULL
93 10593 session 192.168.3.53:45160 session Sleep 17 NULL
94 10594 session 192.168.3.53:45161 session Sleep 22 NULL
95 10595 session 192.168.3.53:45162 session Sleep 26 NULL
96 10596 session 192.168.3.53:45163 session Sleep 23 NULL
97 10597 session 192.168.3.53:45164 session Sleep 24 NULL
98 10598 session 192.168.3.53:51053 session Sleep 24 NULL
99 10599 session 192.168.3.53:51054 session Sleep 24 NULL
100 10600 session 192.168.3.53:51059 session Sleep 25 NULL
101 10601 session 192.168.3.53:51060 session Sleep 16 NULL
102 10602 session 192.168.3.53:51063 session Sleep 23 NULL
103 10603 session 192.168.3.53:51067 session Sleep 23 NULL
104 10604 session 192.168.3.53:51069 session Sleep 25 NULL
105 10605 session 192.168.3.53:51070 session Sleep 23 NULL
106 10606 session 192.168.3.53:51073 session Sleep 24 NULL
107 10607 session 192.168.3.53:51077 session Sleep 24 NULL
108 10608 session 192.168.3.53:51078 session Sleep 25 NULL
109 10609 session 192.168.3.53:51081 session Sleep 24 NULL
110 10610 session 192.168.3.53:51082 session Sleep 16 NULL
111 10611 session 192.168.3.53:51083 session Sleep 15 NULL
112 10612 session 192.168.3.53:51087 session Sleep 21 NULL
113 10613 session 192.168.3.53:51088 session Sleep 24 NULL
114 10614 session 192.168.3.53:51091 session Sleep 24 NULL
115 10615 session 192.168.3.53:51093 session Sleep 25 NULL
116 10616 session 192.168.3.53:51095 session Sleep 17 NULL
117 10617 session 192.168.3.53:51096 session Sleep 25 NULL
118 10618 session 192.168.3.53:51098 session Sleep 21 NULL
119 10619 session 192.168.3.53:51101 session Sleep 25 NULL
120 10620 session 192.168.3.53:51102 session Sleep 24 NULL
121 10621 session 192.168.3.53:51106 session Sleep 23 NULL
122 10622 session 192.168.3.53:51109 session Sleep 25 NULL
123 10623 session 192.168.3.53:51111 session Sleep 24 NULL
124 10624 session 192.168.3.53:51113 session Sleep 24 NULL
125 10625 session 192.168.3.53:51116 session Sleep 24 NULL
126 10626 session 192.168.3.53:51118 session Sleep 24 NULL
127 10627 session 192.168.3.53:51119 session Sleep 24 NULL
128 10628 session 192.168.3.53:51120 session Sleep 23 NULL
129 10629 session 192.168.3.53:51121 session Sleep 32 NULL
130 10630 session 192.168.3.53:51122 session Sleep 24 NULL
131 10631 session 192.168.3.53:51125 session Sleep 24 NULL
132 10632 session 192.168.3.53:51126 session Sleep 25 NULL
133 10633 session 192.168.3.53:51130 session Sleep 24 NULL
134 10634 session 192.168.3.53:51131 session Sleep 24 NULL
135 10635 session 192.168.3.53:51132 session Sleep 24 NULL
136 10636 session 192.168.3.53:51138 session Sleep 23 NULL
137 10637 session 192.168.3.53:51139 session Sleep 15 NULL
138 10638 session 192.168.3.53:51140 session Sleep 24 NULL
139 10639 session 192.168.3.53:51141 session Sleep 15 NULL
140 10640 session 192.168.3.53:51142 session Sleep 25 NULL
141 10641 session 192.168.3.53:51143 session Sleep 24 NULL
142 10642 session 192.168.3.53:51144 session Sleep 23 NULL
143 10643 session 192.168.3.53:51146 session Sleep 15 NULL
144 10644 session 192.168.3.53:51147 session Sleep 22 NULL
145 10645 session 192.168.3.53:51151 session Sleep 17 NULL
146 10646 session 192.168.3.53:51152 session Sleep 18 NULL
147 10647 session 192.168.3.53:51157 session Sleep 23 NULL
148 10648 session 192.168.3.53:51158 session Sleep 24 NULL
149 10649 session 192.168.3.53:51159 session Sleep 24 NULL
150 10650 session 192.168.3.53:51161 session Sleep 24 NULL
151 10651 session 192.168.3.53:51162 session Sleep 24 NULL
152 10652 session 192.168.3.53:51172 session Sleep 23 NULL
153 10653 session 192.168.3.53:51173 session Sleep 23 NULL
154 10654 session 192.168.3.53:51176 session Sleep 23 NULL
155 10655 session 192.168.3.53:51178 session Sleep 15 NULL
156 10656 session 192.168.3.53:51180 session Sleep 24 NULL
157 10657 session 192.168.3.53:51184 session Sleep 18 NULL
158 10658 session 192.168.3.53:51185 session Sleep 24 NULL
159 10659 session 192.168.3.53:51187 session Sleep 24 NULL
160 10660 session 192.168.3.53:51190 session Sleep 21 NULL
161 10661 session 192.168.3.53:51191 session Sleep 30 NULL
162 10663 session 192.168.3.29:40779 session Sleep 11 NULL
163 10949 root localhost session Query 0 NULL show processlist
164
2 2010-05-25 23:50:01
3 Id User Host db Command Time State Info
4 1 system user Daemon 0 Waiting for event from ndbcluster NULL
5 10044 session localhost:58941 session Sleep 23 NULL
6 10045 session localhost:58942 session Sleep 23 NULL
7 10046 session localhost:58943 session Sleep 22 NULL
8 10047 session localhost:58944 session Sleep 22 NULL
9 10048 session localhost:58945 session Sleep 22 NULL
10 10049 session localhost:58946 session Sleep 22 NULL
11 10050 session localhost:58947 session Sleep 22 NULL
12 10051 session localhost:58948 session Sleep 22 NULL
13 10052 session localhost:58949 session Sleep 23 NULL
14 10053 session localhost:58950 session Sleep 23 NULL
15 10054 session localhost:58951 session Sleep 23 NULL
16 10055 session localhost:58952 session Sleep 22 NULL
17 10056 session localhost:58953 session Sleep 22 NULL
18 10057 session localhost:58954 session Sleep 23 NULL
19 10058 session localhost:58955 session Sleep 22 NULL
20 10059 session localhost:58956 session Sleep 22 NULL
21 10060 session localhost:58957 session Sleep 22 NULL
22 10061 session localhost:58958 session Sleep 23 NULL
23 10062 session localhost:58959 session Sleep 23 NULL
24 10063 session localhost:58960 session Sleep 23 NULL
25 10064 session localhost:58961 session Sleep 23 NULL
26 10065 session localhost:58962 session Sleep 22 NULL
27 10066 session localhost:58963 session Sleep 22 NULL
28 10067 session localhost:58964 session Sleep 22 NULL
29 10068 session localhost:58965 session Sleep 22 NULL
30 10069 session localhost:58966 session Sleep 23 NULL
31 10070 session localhost:58967 session Sleep 23 NULL
32 10071 session localhost:58968 session Sleep 23 NULL
33 10072 session localhost:58969 session Sleep 22 NULL
34 10073 session localhost:58970 session Sleep 22 NULL
35 10074 session localhost:58971 session Sleep 22 NULL
36 10075 session localhost:58972 session Sleep 23 NULL
37 10076 session localhost:58973 session Sleep 22 NULL
38 10077 session localhost:58974 session Sleep 23 NULL
39 10078 session localhost:58975 session Sleep 22 NULL
40 10079 session localhost:58976 session Sleep 22 NULL
41 10080 session localhost:58977 session Sleep 23 NULL
42 10081 session localhost:58978 session Sleep 22 NULL
43 10082 session localhost:58979 session Sleep 23 NULL
44 10083 session localhost:58980 session Sleep 22 NULL
45 10084 session localhost:58981 session Sleep 22 NULL
46 10085 session localhost:58982 session Sleep 22 NULL
47 10086 session localhost:58983 session Sleep 22 NULL
48 10087 session localhost:58984 session Sleep 22 NULL
49 10088 session localhost:58985 session Sleep 22 NULL
50 10089 session localhost:58986 session Sleep 22 NULL
51 10090 session localhost:58987 session Sleep 22 NULL
52 10091 session localhost:58988 session Sleep 23 NULL
53 10092 session localhost:58989 session Sleep 22 NULL
54 10093 session localhost:58990 session Sleep 23 NULL
55 10094 session localhost:58991 session Sleep 22 NULL
56 10095 session localhost:58992 session Sleep 23 NULL
57 10096 session localhost:58993 session Sleep 23 NULL
58 10097 session localhost:58994 session Sleep 23 NULL
59 10098 session localhost:58995 session Sleep 22 NULL
60 10099 session localhost:58996 session Sleep 23 NULL
61 10100 session localhost:58997 session Sleep 22 NULL
62 10101 session localhost:58998 session Sleep 22 NULL
63 10102 session localhost:58999 session Sleep 22 NULL
64 10103 session localhost:59000 session Sleep 23 NULL
65 10550 session 192.168.3.29:44979 session Sleep 652 NULL
66 10566 session 192.168.3.53:45132 session Sleep 23 NULL
67 10567 session 192.168.3.53:45133 session Sleep 25 NULL
68 10568 session 192.168.3.53:45134 session Sleep 23 NULL
69 10569 session 192.168.3.53:45135 session Sleep 20 NULL
70 10570 session 192.168.3.53:45136 session Sleep 25 NULL
71 10571 session 192.168.3.53:45137 session Sleep 15 NULL
72 10572 session 192.168.3.53:45138 session Sleep 23 NULL
73 10573 session 192.168.3.53:45139 session Sleep 23 NULL
74 10574 session 192.168.3.53:45140 session Sleep 24 NULL
75 10575 session 192.168.3.53:45141 session Sleep 24 NULL
76 10576 session 192.168.3.53:45142 session Sleep 24 NULL
77 10577 session 192.168.3.53:45143 session Sleep 24 NULL
78 10578 session 192.168.3.53:45144 session Sleep 18 NULL
79 10579 session 192.168.3.53:45145 session Sleep 16 NULL
80 10580 session 192.168.3.53:45146 session Sleep 23 NULL
81 10581 session 192.168.3.53:45147 session Sleep 24 NULL
82 10582 session 192.168.3.53:45148 session Sleep 24 NULL
83 10583 session 192.168.3.53:45149 session Sleep 25 NULL
84 10584 session 192.168.3.53:45151 session Sleep 23 NULL
85 10585 session 192.168.3.53:45152 session Sleep 24 NULL
86 10586 session 192.168.3.53:45153 session Sleep 25 NULL
87 10587 session 192.168.3.53:45154 session Sleep 24 NULL
88 10588 session 192.168.3.53:45155 session Sleep 25 NULL
89 10589 session 192.168.3.53:45156 session Sleep 25 NULL
90 10590 session 192.168.3.53:45157 session Sleep 24 NULL
91 10591 session 192.168.3.53:45158 session Sleep 24 NULL
92 10592 session 192.168.3.53:45159 session Sleep 24 NULL
93 10593 session 192.168.3.53:45160 session Sleep 17 NULL
94 10594 session 192.168.3.53:45161 session Sleep 22 NULL
95 10595 session 192.168.3.53:45162 session Sleep 26 NULL
96 10596 session 192.168.3.53:45163 session Sleep 23 NULL
97 10597 session 192.168.3.53:45164 session Sleep 24 NULL
98 10598 session 192.168.3.53:51053 session Sleep 24 NULL
99 10599 session 192.168.3.53:51054 session Sleep 24 NULL
100 10600 session 192.168.3.53:51059 session Sleep 25 NULL
101 10601 session 192.168.3.53:51060 session Sleep 16 NULL
102 10602 session 192.168.3.53:51063 session Sleep 23 NULL
103 10603 session 192.168.3.53:51067 session Sleep 23 NULL
104 10604 session 192.168.3.53:51069 session Sleep 25 NULL
105 10605 session 192.168.3.53:51070 session Sleep 23 NULL
106 10606 session 192.168.3.53:51073 session Sleep 24 NULL
107 10607 session 192.168.3.53:51077 session Sleep 24 NULL
108 10608 session 192.168.3.53:51078 session Sleep 25 NULL
109 10609 session 192.168.3.53:51081 session Sleep 24 NULL
110 10610 session 192.168.3.53:51082 session Sleep 16 NULL
111 10611 session 192.168.3.53:51083 session Sleep 15 NULL
112 10612 session 192.168.3.53:51087 session Sleep 21 NULL
113 10613 session 192.168.3.53:51088 session Sleep 24 NULL
114 10614 session 192.168.3.53:51091 session Sleep 24 NULL
115 10615 session 192.168.3.53:51093 session Sleep 25 NULL
116 10616 session 192.168.3.53:51095 session Sleep 17 NULL
117 10617 session 192.168.3.53:51096 session Sleep 25 NULL
118 10618 session 192.168.3.53:51098 session Sleep 21 NULL
119 10619 session 192.168.3.53:51101 session Sleep 25 NULL
120 10620 session 192.168.3.53:51102 session Sleep 24 NULL
121 10621 session 192.168.3.53:51106 session Sleep 23 NULL
122 10622 session 192.168.3.53:51109 session Sleep 25 NULL
123 10623 session 192.168.3.53:51111 session Sleep 24 NULL
124 10624 session 192.168.3.53:51113 session Sleep 24 NULL
125 10625 session 192.168.3.53:51116 session Sleep 24 NULL
126 10626 session 192.168.3.53:51118 session Sleep 24 NULL
127 10627 session 192.168.3.53:51119 session Sleep 24 NULL
128 10628 session 192.168.3.53:51120 session Sleep 23 NULL
129 10629 session 192.168.3.53:51121 session Sleep 32 NULL
130 10630 session 192.168.3.53:51122 session Sleep 24 NULL
131 10631 session 192.168.3.53:51125 session Sleep 24 NULL
132 10632 session 192.168.3.53:51126 session Sleep 25 NULL
133 10633 session 192.168.3.53:51130 session Sleep 24 NULL
134 10634 session 192.168.3.53:51131 session Sleep 24 NULL
135 10635 session 192.168.3.53:51132 session Sleep 24 NULL
136 10636 session 192.168.3.53:51138 session Sleep 23 NULL
137 10637 session 192.168.3.53:51139 session Sleep 15 NULL
138 10638 session 192.168.3.53:51140 session Sleep 24 NULL
139 10639 session 192.168.3.53:51141 session Sleep 15 NULL
140 10640 session 192.168.3.53:51142 session Sleep 25 NULL
141 10641 session 192.168.3.53:51143 session Sleep 24 NULL
142 10642 session 192.168.3.53:51144 session Sleep 23 NULL
143 10643 session 192.168.3.53:51146 session Sleep 15 NULL
144 10644 session 192.168.3.53:51147 session Sleep 22 NULL
145 10645 session 192.168.3.53:51151 session Sleep 17 NULL
146 10646 session 192.168.3.53:51152 session Sleep 18 NULL
147 10647 session 192.168.3.53:51157 session Sleep 23 NULL
148 10648 session 192.168.3.53:51158 session Sleep 24 NULL
149 10649 session 192.168.3.53:51159 session Sleep 24 NULL
150 10650 session 192.168.3.53:51161 session Sleep 24 NULL
151 10651 session 192.168.3.53:51162 session Sleep 24 NULL
152 10652 session 192.168.3.53:51172 session Sleep 23 NULL
153 10653 session 192.168.3.53:51173 session Sleep 23 NULL
154 10654 session 192.168.3.53:51176 session Sleep 23 NULL
155 10655 session 192.168.3.53:51178 session Sleep 15 NULL
156 10656 session 192.168.3.53:51180 session Sleep 24 NULL
157 10657 session 192.168.3.53:51184 session Sleep 18 NULL
158 10658 session 192.168.3.53:51185 session Sleep 24 NULL
159 10659 session 192.168.3.53:51187 session Sleep 24 NULL
160 10660 session 192.168.3.53:51190 session Sleep 21 NULL
161 10661 session 192.168.3.53:51191 session Sleep 30 NULL
162 10663 session 192.168.3.29:40779 session Sleep 11 NULL
163 10949 root localhost session Query 0 NULL show processlist
164
可惜的是,由于采集间隔的原因,没有采集到当时processlist的更多信息,今天开始,采集间隔为每分钟一次,我不信我看不到系统在干吗?