Results of Michael Bacarella's request (too big for dist list, so only
Michael and Michael/Monty got the full reply, this is shortened for the
list so a possible light bulb can go off):
3.23.51:
> ps -eo pid,tt,user,fname,tmout,f,wchan
PID TT USER COMMAND TMOUT F WCHAN
1 ? root init - 100 do_select
2 ? root keventd - 040 context_thread
3 ? root ksoftirq - 040 ksoftirqd
4 ? root ksoftirq - 040 -
5 ? root kswapd - 040 kswapd
6 ? root bdflush - 040 bdflush
7 ? root kupdated - 040 kupdate
8 ? root mdrecove - 040 md_thread
17 ? root kjournal - 040 end
92 ? root khubd - 040 end
192 ? root kjournal - 040 end
193 ? root kjournal - 040 end
685 ? root syslogd - 040 do_select
690 ? root klogd - 140 do_syslog
710 ? rpc portmap - 140 do_poll
738 ? rpcuser rpc.stat - 140 do_select
923 ? root xinetd - 140 do_select
963 ? root sendmail - 140 do_select
994 ? root crond - 040 nanosleep
1044 ? xfs xfs - 140 do_select
1080 ? daemon atd - 040 nanosleep
1112 ? root miniserv - 040 do_select
1117 tty2 root mingetty - 100 read_chan
1118 tty3 root mingetty - 100 read_chan
1119 tty4 root mingetty - 100 read_chan
1120 tty5 root mingetty - 100 read_chan
1121 tty6 root mingetty - 100 read_chan
1285 tty1 root mingetty - 100 read_chan
14125 ? root sshd - 140 do_select
409 ? root php - 000 inet_wait_for_connect
9097 ? root sshd - 140 -
9099 pts/0 root bash - 100 wait4
9164 pts/0 root safe_mys - 100 wait4
9192 pts/0 mysql mysqld - 100 -
9194 pts/0 mysql mysqld - 040 do_poll
9195 pts/0 mysql mysqld - 040 rt_sigsuspend
9196 pts/0 mysql mysqld - 040 -
9197 pts/0 mysql mysqld - 040 rt_sigsuspend
9198 pts/0 mysql mysqld - 040 rt_sigsuspend
9199 pts/0 mysql mysqld - 040 -
9200 pts/0 mysql mysqld - 040 -
9201 pts/0 mysql mysqld - 040 -
9202 pts/0 mysql mysqld - 040 -
9203 pts/0 mysql mysqld - 040 -
9204 pts/0 mysql mysqld - 040 rt_sigsuspend
9205 pts/0 mysql mysqld - 040 -
9206 pts/0 mysql mysqld - 040 -
9207 pts/0 mysql mysqld - 040 -
9208 pts/0 mysql mysqld - 040 rt_sigsuspend
9209 pts/0 mysql mysqld - 040 rt_sigsuspend
9210 pts/0 mysql mysqld - 040 -
9211 pts/0 mysql mysqld - 040 unix_stream_data_wait
9212 pts/0 mysql mysqld - 040 -
9213 pts/0 mysql mysqld - 040 -
9214 pts/0 mysql mysqld - 040 -
9215 pts/0 mysql mysqld - 040 tcp_data_wait
9216 pts/0 mysql mysqld - 040 -
9217 pts/0 mysql mysqld - 040 -
9218 pts/0 mysql mysqld - 040 rt_sigsuspend
9219 pts/0 mysql mysqld - 040 -
9220 pts/0 mysql mysqld - 040 -
9221 pts/0 mysql mysqld - 040 -
9222 pts/0 mysql mysqld - 040 -
9223 pts/0 mysql mysqld - 040 -
9224 pts/0 mysql mysqld - 040 -
9225 pts/0 mysql mysqld - 040 -
9226 pts/0 mysql mysqld - 040 -
9227 pts/0 mysql mysqld - 040 -
9228 pts/0 mysql mysqld - 040 -
9229 pts/0 mysql mysqld - 040 -
9230 pts/0 mysql mysqld - 040 -
9231 pts/0 mysql mysqld - 040 -
9232 pts/0 mysql mysqld - 040 -
9233 pts/0 mysql mysqld - 040 -
9234 pts/0 mysql mysqld - 040 -
9235 pts/0 mysql mysqld - 040 -
9236 pts/0 mysql mysqld - 040 -
9237 pts/0 mysql mysqld - 040 -
9238 pts/0 mysql mysqld - 040 -
9239 pts/0 mysql mysqld - 040 -
9240 pts/0 mysql mysqld - 040 -
9241 pts/0 mysql mysqld - 040 -
9242 pts/0 mysql mysqld - 040 -
9243 pts/0 mysql mysqld - 040 -
9244 pts/0 mysql mysqld - 040 -
9245 pts/0 mysql mysqld - 040 -
9247 pts/0 mysql mysqld - 040 -
9248 pts/0 mysql mysqld - 040 -
9249 pts/0 mysql mysqld - 040 -
9250 pts/0 mysql mysqld - 040 tcp_data_wait
9251 pts/0 mysql mysqld - 040 tcp_data_wait
9252 pts/0 mysql mysqld - 040 -
9254 pts/0 mysql mysqld - 040 -
9255 pts/0 mysql mysqld - 040 -
9256 pts/0 mysql mysqld - 040 -
9258 pts/0 mysql mysqld - 040 -
9259 pts/0 mysql mysqld - 040 -
9260 pts/0 mysql mysqld - 040 -
9261 pts/0 mysql mysqld - 040 -
9263 pts/0 mysql mysqld - 040 -
9264 pts/0 mysql mysqld - 040 -
9265 pts/0 mysql mysqld - 040 -
9266 pts/0 mysql mysqld - 040 -
9267 pts/0 mysql mysqld - 040 -
9268 pts/0 mysql mysqld - 040 -
9269 pts/0 mysql mysqld - 040 -
9274 pts/0 mysql mysqld - 040 -
9275 pts/0 mysql mysqld - 040 -
9276 pts/0 mysql mysqld - 040 -
9277 pts/0 mysql mysqld - 040 -
9278 pts/0 mysql mysqld - 040 -
9279 pts/0 mysql mysqld - 040 -
9280 pts/0 mysql mysqld - 040 -
9281 pts/0 mysql mysqld - 040 -
9282 pts/0 mysql mysqld - 040 -
9283 pts/0 mysql mysqld - 040 -
9285 pts/0 mysql mysqld - 040 -
9286 pts/0 mysql mysqld - 040 -
9287 pts/0 mysql mysqld - 040 -
9289 pts/0 mysql mysqld - 040 -
9290 pts/0 mysql mysqld - 040 -
9291 pts/0 mysql mysqld - 040 -
9292 pts/0 mysql mysqld - 040 -
9293 pts/0 mysql mysqld - 040 -
9294 pts/0 mysql mysqld - 040 -
9296 pts/0 mysql mysqld - 040 -
9297 pts/0 mysql mysqld - 040 -
9298 pts/0 mysql mysqld - 040 tcp_data_wait
9299 pts/0 mysql mysqld - 040 -
9300 pts/0 mysql mysqld - 040 -
9301 pts/0 mysql mysqld - 040 -
9302 pts/0 mysql mysqld - 040 -
9303 pts/0 mysql mysqld - 040 -
9304 pts/0 mysql mysqld - 040 -
9305 pts/0 mysql mysqld - 040 -
9306 pts/0 mysql mysqld - 040 -
9307 pts/0 mysql mysqld - 040 -
9308 pts/0 mysql mysqld - 040 -
9309 pts/0 mysql mysqld - 040 -
9310 pts/0 mysql mysqld - 040 rt_sigsuspend
9311 pts/0 mysql mysqld - 040 -
9312 pts/0 mysql mysqld - 040 rt_sigsuspend
9313 pts/0 mysql mysqld - 040 -
9314 pts/0 mysql mysqld - 040 -
9315 pts/0 mysql mysqld - 040 -
9316 pts/0 mysql mysqld - 040 -
9317 pts/0 mysql mysqld - 040 -
9318 pts/0 mysql mysqld - 040 -
9319 pts/0 mysql mysqld - 040 -
9320 pts/0 mysql mysqld - 040 -
9321 pts/0 mysql mysqld - 040 -
9322 pts/0 mysql mysqld - 040 -
9324 pts/0 mysql mysqld - 040 -
9325 pts/0 mysql mysqld - 040 -
9326 pts/0 mysql mysqld - 040 -
9327 pts/0 mysql mysqld - 040 -
9328 pts/0 mysql mysqld - 040 -
9329 pts/0 mysql mysqld - 040 -
9330 pts/0 mysql mysqld - 040 -
9331 pts/0 mysql mysqld - 040 rt_sigsuspend
9332 pts/0 mysql mysqld - 040 rt_sigsuspend
9333 pts/0 mysql mysqld - 040 rt_sigsuspend
9334 pts/0 mysql mysqld - 040 rt_sigsuspend
9335 pts/0 mysql mysqld - 040 rt_sigsuspend
9339 pts/0 mysql mysqld - 040 rt_sigsuspend
9340 pts/0 mysql mysqld - 040 rt_sigsuspend
9341 pts/0 mysql mysqld - 040 -
9342 pts/0 mysql mysqld - 040 rt_sigsuspend
9344 pts/0 mysql mysqld - 040 -
9345 pts/0 mysql mysqld - 040 rt_sigsuspend
9346 pts/0 mysql mysqld - 040 -
9348 pts/0 root ps - 000 -
9349 pts/0 mysql mysqld - 040 -
9350 pts/0 mysql mysqld - 040 -
9351 pts/0 mysql mysqld - 040 -
9352 pts/0 mysql mysqld - 040 -
9353 pts/0 mysql mysqld - 040 -
9354 pts/0 mysql mysqld - 040 -
The server was at load 0.70. Then I switched to .51 and the above is at
load 53.
So I switched back to .47 and this is the result:
3.23.47:
> ps -eo pid,tt,user,fname,tmout,f,wchan
PID TT USER COMMAND TMOUT F WCHAN
1 ? root init - 100 do_select
2 ? root keventd - 040 context_thread
3 ? root ksoftirq - 040 ksoftirqd
4 ? root ksoftirq - 040 ksoftirqd
5 ? root kswapd - 040 kswapd
6 ? root bdflush - 040 bdflush
7 ? root kupdated - 040 kupdate
8 ? root mdrecove - 040 md_thread
17 ? root kjournal - 040 end
92 ? root khubd - 040 end
192 ? root kjournal - 040 end
193 ? root kjournal - 040 end
685 ? root syslogd - 040 do_select
690 ? root klogd - 140 do_syslog
710 ? rpc portmap - 140 do_poll
738 ? rpcuser rpc.stat - 140 do_select
923 ? root xinetd - 140 do_select
963 ? root sendmail - 140 do_select
994 ? root crond - 040 nanosleep
1044 ? xfs xfs - 140 do_select
1080 ? daemon atd - 040 nanosleep
1112 ? root miniserv - 040 do_select
1117 tty2 root mingetty - 100 read_chan
1118 tty3 root mingetty - 100 read_chan
1119 tty4 root mingetty - 100 read_chan
1120 tty5 root mingetty - 100 read_chan
1121 tty6 root mingetty - 100 read_chan
1285 tty1 root mingetty - 100 read_chan
14125 ? root sshd - 140 do_select
409 ? root php - 000 nanosleep
9097 ? root sshd - 140 do_select
9099 pts/0 root bash - 100 wait4
9369 pts/0 root safe_mys - 100 wait4
9397 pts/0 mysql mysqld - 100 do_select
9399 pts/0 mysql mysqld - 040 do_poll
9400 pts/0 mysql mysqld - 040 rt_sigsuspend
9401 pts/0 mysql mysqld - 040 tcp_data_wait
9402 pts/0 mysql mysqld - 040 tcp_data_wait
9403 pts/0 mysql mysqld - 040 tcp_data_wait
9404 pts/0 mysql mysqld - 040 tcp_data_wait
9405 pts/0 mysql mysqld - 040 tcp_data_wait
9406 pts/0 mysql mysqld - 040 tcp_data_wait
9407 pts/0 mysql mysqld - 040 tcp_data_wait
9408 pts/0 mysql mysqld - 040 tcp_data_wait
9409 pts/0 mysql mysqld - 040 tcp_data_wait
9410 pts/0 mysql mysqld - 040 tcp_data_wait
9411 pts/0 mysql mysqld - 040 tcp_data_wait
9412 pts/0 mysql mysqld - 040 tcp_data_wait
9413 pts/0 mysql mysqld - 040 tcp_data_wait
9414 pts/0 mysql mysqld - 040 tcp_data_wait
9415 pts/0 mysql mysqld - 040 rt_sigsuspend
9416 pts/0 mysql mysqld - 040 tcp_data_wait
9417 pts/0 mysql mysqld - 040 tcp_data_wait
9418 pts/0 mysql mysqld - 040 tcp_data_wait
9419 pts/0 mysql mysqld - 040 tcp_data_wait
9420 pts/0 mysql mysqld - 040 tcp_data_wait
9421 pts/0 mysql mysqld - 040 tcp_data_wait
<more of same>
9854 pts/0 mysql mysqld - 040 rt_sigsuspend
9855 pts/0 mysql mysqld - 040 rt_sigsuspend
9856 pts/0 mysql mysqld - 040 tcp_data_wait
9857 pts/0 mysql mysqld - 040 tcp_data_wait
9858 pts/0 mysql mysqld - 040 tcp_data_wait
9859 pts/0 mysql mysqld - 040 rt_sigsuspend
9860 pts/0 mysql mysqld - 040 tcp_data_wait
9861 pts/0 mysql mysqld - 040 rt_sigsuspend
9862 pts/0 mysql mysqld - 040 tcp_data_wait
9865 pts/0 mysql mysqld - 040 rt_sigsuspend
9866 pts/0 mysql mysqld - 040 tcp_data_wait
9870 pts/0 mysql mysqld - 040 tcp_data_wait
9873 pts/0 mysql mysqld - 040 rt_sigsuspend
9874 pts/0 mysql mysqld - 040 tcp_data_wait
9875 pts/0 mysql mysqld - 040 rt_sigsuspend
9876 pts/0 mysql mysqld - 040 tcp_data_wait
9878 pts/0 mysql mysqld - 040 rt_sigsuspend
9885 pts/0 root ps - 100 -
9886 pts/0 root more - 000 read_chan
This is obviously different. 3.23.47 is in tcp_data_wait. 3.23.51 is
usually doing nothing (!) or in suspend. Odd.
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
> -----Original Message-----
> From: Michael Bacarella [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, June 29, 2002 11:20 pm
> To: Steven Roussey
> Subject: Re: Load problems with 3.23.51
>
> Can you humor me and try running the command:
>
> ps -eo pid,tt,user,fname,tmout,f,wchan
>
> on that system a few times? Mine was far too hosed for this command
> to ever get off the ground. I think that'd help determine
> if there's some syscall that's sucking up all that cpu.
>
> -M
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
