On Wed, Apr 11, 2001 at 12:33:44PM -0400, Ken Menzel wrote:
> The list reject my trace (it was too large), so here is a smaller
> one! Stops after info from first top starts showing CPU usage of 99%
> Ken
>
> Hi Tim, I just had it happen. Overall average 14 queries per second
> on this machine. Single CPU Kernel Dell 2400 600MHZ FreeBSD-stable
> from January. Almost generic kernel. I have attahced some output
> from truss, followed by 'top' followed by the stop and start of
> mysql, followed by the output from 'top' again. Hope this helps
> someone!
>
> Ken
>
> -----------------------------------------------------
> Ken Menzel ICQ# 9325188
> www.icarz.com [EMAIL PROTECTED]
> pread(0x186,0x18563010,0x2a9,0x0,0x4bb094,0x0) = 681 (0x2a9)
> lseek(173,0x1b20,0) = 6944 (0x1b20)
> read(0xad,0xbf515028,0x14) = 20 (0x14)
> pread(0xad,0x187e5018,0x33,0x0,0x1b2d,0x0) = 51 (0x33)
> lseek(173,0x1b74,0) = 7028 (0x1b74)
> read(0xad,0xbf515028,0x14) = 20 (0x14)
> pread(0xad,0x187e504b,0x17,0x0,0x1b78,0x0) = 23 (0x17)
> SIGNAL 27
> SIGNAL 27
> pread(0x186,0x18563010,0x2a9,0x0,0x2cac03,0x0) = 681 (0x2a9)
> gettimeofday(0x2828a568,0x0) = 0 (0x0)
> sigprocmask(0x3,0x2828a5d8,0x0) = 0 (0x0)
> sigaltstack(0x282a5c20,0x0) = 0 (0x0)
> poll(0x8212000,0x54,0x0) = 0 (0x0)
> sigreturn(0x182a1864) = 20 (0x14)
> pread(0xe5,0x1843a09f,0x9,0x0,0x4f777,0x0) = 9 (0x9)
> lseek(229,0x4f758,0) = 325464 (0x4f758)
> read(0xe5,0xbf39ef98,0x14) = 20 (0x14)
> pread(0xe5,0x1843a0a8,0x9,0x0,0x4f763,0x0) = 9 (0x9)
> lseek(229,0x5ae64,0) = 372324 (0x5ae64)
> read(0xe5,0xbf39ef98,0x14) = 20 (0x14)
> pread(0xe5,0x1843a0b1,0xd,0x0,0x5ae68,0x0) = 13 (0xd)
> lseek(229,0x4963c,0) = 300604 (0x4963c)
That's different to what I was seeing.
I saw a tight loop of
poll(...) = 1
gettimeofday(...) = ...
poll(...) = 1
gettimeofday(...) = ...
poll(...) = 1
gettimeofday(...) = ...
poll(...) = 1
gettimeofday(...) = ...
Tim.
---------------------------------------------------------------------
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
