Tomek, ----- Original Message ----- From: "Tomek Dudziak" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Saturday, November 02, 2002 1:34 PM Subject: Re: 4.0.4 stalls
> [EMAIL PROTECTED] (Tomek Dudziak) wrote in message news:<[EMAIL PROTECTED]>... > > > about 300 queries per second > > > > Server runs nicely for some time. Then suddenly processes begin to eat > > up all the CPU. Load goes to 100s. It takes several seconds to > > connect, so number of processes rises. Disk activity stops after some > > time, but still it's hard to connect. > > > > When I shut down apache servers, problem IMMEDIATELY (1-2 sec) goes > > away. Server goes back to normal. > > I was told that this is a glibc problem and 4.0.4 was not compiled > right. Can someone from MySQL confirm this? When's the next release the problem certainly sounded like thread thrashing. My guess is that 4.0.5 will be released Nov 15th, 2002. If possible, you can try 3.23.53a which has a new glibc. You can also try adding to the [mysqld] section of my.cnf: set-variable = innodb_thread_concurrency=1 Please report to the mailing list [EMAIL PROTECTED] if you were able to solve the thrashing problem. We want feedback from the field about how the new glibc is faring. > date? > Tomek Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB sql query --------------------------------------------------------------------- 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