技术开发 频道

mysql特定时间运行速度变慢的问题一例

  当时的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

  可惜的是,由于采集间隔的原因,没有采集到当时processlist的更多信息,今天开始,采集间隔为每分钟一次,我不信我看不到系统在干吗?

0
相关文章