Hi John,
> I've noticed rare occasions (about 1% of the time) when poll()
returns 0
> -- these are always preceeded in the trace output by a signal
handler,
> like this:
> 45689 mysqld 0.000008 CALL sigreturn(0x826ae7c)
> 45689 mysqld 0.000010 RET sigreturn JUSTRETURN
> 45689 mysqld 0.000024 CALL poll(0x8270000,0x91,0)
> 45689 mysqld 0.000041 RET poll 0
> 45689 mysqld 0.000023 CALL poll(0x8270000,0x92,0x1ff)
> 45689 mysqld 0.000040 RET poll 1
I wonder which network card/driver you are using? (output from dmesg)
Is poll 1 what you get when the server is idle?
>
> (Really, I'm not sure what to make of ktrace: which thread makes a
> particular call? Why are the timestamps interleaved?...)
>
The timestamps are relative to the previous call (-R) if you want to
see absolute timestamps use -T with kdump.
> > I was also wondering how much RAM you had, I hope it is about 2
gig
>
> I have 768 MB here, for 50 databases with about 10 tables each,
getting
> 6 queries per second. My current mysqld has been running since
> yesterday and now has a resident size of about 100MB. I did restart
the
The reason I asked about the memory is you are allocation 1 meg for
sort_buffer and 1 meg for record buffers and allow 600 connections
plus key buffer of 256Meg and Isam sort of 64Meg, this adds up to
(600* 1meg (minimum))+256+64= 920Meg of potential memory usage maybe
more if requests often use ORDER BY or need to sort the result. Of
course this depends mainly on the number of connections happening.
> server yesterday to get it back to normal, and I can't reproduce the
> problem, but I can leave it running and expect the problem to
reappear
> within about 10 days. When it comes back, I will take a good look
at
> memory and the processlist. My recollection is that the condition
will
> persist without there being any currently running query at all...
>
Great I look forward to receiving this. Also try to recompile without
the -O3, optimization sometimes causes problems because it can
optimize away needed instructions. I don't think this is the case,
but it would make my compile environment and yours equivalent and I
don't have the problem. My guess might be something in the particular
netword card. I use mostly Intel etherexpress and 3com 3905 cards.
I may be away next week, however, I might cancel as I hurt my foot
and am having trouble walking, so I might just sit in this chair! :(
Ken
> - JD
>
> -------------------------------------------
> John David Duncan
> Systems Administrator
> Great Schools, Inc.
>
>
> --------------------------------------------------------------------
-
> 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
>
>
---------------------------------------------------------------------
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
