Compiling the 4.0.4 source seems to have solved the problem.
Regards,
Tomek
Heikki Tuuri wrote:
Tomek,
then it is best to either test 3.23.53a or wait for 4.0.5. But please
report if those were able to solve the thrashing.
Regards,
Heikki
----- Original Message -----
*From:* Tomek Dudziak <mailto:tomek@;allegro.pl>
*To:* Heikki Tuuri <mailto:Heikki.Tuuri@;innodb.com>
*Cc:* [EMAIL PROTECTED] <mailto:mysql@;lists.mysql.com>
*Sent:* Saturday, November 02, 2002 7:58 PM
*Subject:* Re: 4.0.4 stalls
I am now able to reproduce this bug in testing env. If you'd like
me to run any commands while the server is hanging, please let me
know.
I tried
set-variable = innodb_thread_concurrency=1
and
set-variable = thread_concurrency=1
Didn't help.
Tomek
Heikki Tuuri wrote:
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
---------------------------------------------------------------------
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
