Try compiling form source instead of running binary. ~K Black
-----Original Message----- From: Mark [mailto:admin@;asarian-host.net] Sent: Thursday, October 31, 2002 12:33 PM To: heath boutwell; [EMAIL PROTECTED] Subject: Re: Thread Thrashing and 3.23.53a ----- Original Message ----- From: "heath boutwell" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, October 31, 2002 5:22 PM Subject: Re: Thread Thrashing and 3.23.53a > Aren't these just aborted clients? When you upgraded before did mysql > bring the server to its knees or just yield many aborted clients/connects? > Any idea what your show processlist looks like when this is happening? I ran mysqld (.53) with logging, in a test box, this time. That does indeed reveal that a connection is lost; or, more appropriately, never gets established. First, when everything goes ok (I had to start the news server a few times before the problem would reoccur, the log says this: 5 Quit 7 Connect news@localhost on xovers 7 Query SELECT ... That is correct. The 'quit' is from a table-check program, then the news server connects itself. Now the faulty condition: 9 Quit 8 Query SELECT ... It seems the connection the news server tries to make never gets established. Which is really strange. For had the connection tangibly failed (as in: returned an error), my news server would have logged the resulting error string. Instead, it seems to think the connection succeeded. Then starts a query, and, of course, reports that it lost the connection "during" the query. But I am beginning to doubt there even was a valid connection to begin with. This is all the more bewildering to me, as I thought these problems only occured on TCP/IP sockets, and not on domain sockets (and the news server, of course, connects via the much faster domain socket). > Since my load averages are now 3 times what they were with the older > versions (I am using MySQL binaries), I think its just a matter of time > for me as well, but I wanted to give it a shot. Load averages are consistently higher here too, with the .53 built. And I have no real indication why this should occur. This will take a bit of sorting out. And mind you, that this really never happened with my .49 version. - Mark --------------------------------------------------------------------- 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
