MySQL CPU usage skyrocketing
Hi,
I am running MySQL 3.23.41 on a FreeBSD 4.4, and I experience very high
loads of the machine, without any apparent reason. We have a new project
using this MySQL engine, with lots of inserts/deletes. But it happens that
in the mornings, when nobody makes any kind of access to the database, we
still have a MySQL daemon eating up 99% of CPU. If I log in as 'root' to
the mysql server and make a 'show processlist', the only process in the
'query' command is mine ('show processlist'), all the others are in sleep
mode (with NULL info). Is there any periodic maintanance/optimization work
that the mysql server is doing? If so, why does it take so long? Can I
schedule it sometimes during the night (and if so, how?)
Thanks,
bogdan
iCom Media AG
Kirchweg 36
Koln, 50858
Germany
Phone: +49-(0)221-485-689-16
Fax : +49-(0)221-485-689-20
Mobile:+49-(0)173-906-46-01
-
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
RE: MySQL CPU usage skyrocketing
See links form mail list.
http://jeremy.zawodny.com/blog/archives/000203.html#000203
http://jeremy.zawodny.com/blog/archives/000264.html#000264
Simon
-Original Message-
From: Bogdan TARU [mailto:bgd;icomag.de]
Sent: 07 November 2002 10:35
To: [EMAIL PROTECTED]
Subject: MySQL CPU usage skyrocketing
Hi,
I am running MySQL 3.23.41 on a FreeBSD 4.4, and I experience very high
loads of the machine, without any apparent reason. We have a new project
using this MySQL engine, with lots of inserts/deletes. But it happens that
in the mornings, when nobody makes any kind of access to the database, we
still have a MySQL daemon eating up 99% of CPU. If I log in as 'root' to
the mysql server and make a 'show processlist', the only process in the
'query' command is mine ('show processlist'), all the others are in sleep
mode (with NULL info). Is there any periodic maintanance/optimization work
that the mysql server is doing? If so, why does it take so long? Can I
schedule it sometimes during the night (and if so, how?)
Thanks,
bogdan
iCom Media AG
Kirchweg 36
Koln, 50858
Germany
Phone: +49-(0)221-485-689-16
Fax : +49-(0)221-485-689-20
Mobile:+49-(0)173-906-46-01
-
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
RE: MySQL CPU usage skyrocketing
Ok, we know that FreeBSD has problems with its thread implementation;
however, I'd like to know if the MySql guys know exactly what causes the
problems to which Mr Zawodny refers.
I'm running FreeBSD 4.6.2, and have seen the 'rogue thread' problem before
which leads me to believe that either FreeBSD has not addressed the problem
or MySql hasn't. To be fair MySql says in its documentation that FreeBSD is
not recommended because of its threading implementation.
Furthermore, I wonder if anyone has been working with MySql and FreeBSD 5.0
DP1 and, if so, what behavior they've experienced.
Peter
^_^
-Original Message-
From: Simon Green [mailto:sgreen;eurobell.net]
Sent: Thursday, November 07, 2002 6:04 AM
To: 'Bogdan TARU'; [EMAIL PROTECTED]
Subject: RE: MySQL CPU usage skyrocketing
See links form mail list.
http://jeremy.zawodny.com/blog/archives/000203.html#000203
http://jeremy.zawodny.com/blog/archives/000264.html#000264
Simon
-Original Message-
From: Bogdan TARU [mailto:bgd;icomag.de]
Sent: 07 November 2002 10:35
To: [EMAIL PROTECTED]
Subject: MySQL CPU usage skyrocketing
Hi,
I am running MySQL 3.23.41 on a FreeBSD 4.4, and I experience very high
loads of the machine, without any apparent reason. We have a new project
using this MySQL engine, with lots of inserts/deletes. But it happens that
in the mornings, when nobody makes any kind of access to the database, we
still have a MySQL daemon eating up 99% of CPU. If I log in as 'root' to
the mysql server and make a 'show processlist', the only process in the
'query' command is mine ('show processlist'), all the others are in sleep
mode (with NULL info). Is there any periodic maintanance/optimization work
that the mysql server is doing? If so, why does it take so long? Can I
schedule it sometimes during the night (and if so, how?)
Thanks,
bogdan
iCom Media AG
Kirchweg 36
Koln, 50858
Germany
Phone: +49-(0)221-485-689-16
Fax : +49-(0)221-485-689-20
Mobile:+49-(0)173-906-46-01
-
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
-
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
Re: MySQL CPU usage skyrocketing
On Thu, Nov 07, 2002 at 08:48:15AM -0500, Grigor, Peter wrote: Ok, we know that FreeBSD has problems with its thread implementation; however, I'd like to know if the MySql guys know exactly what causes the problems to which Mr Zawodny refers. The problem is the MySQL (by default) uses name resolution extensively. But the resolver calls are not thread-safe on FreeBSD. Race coniditions exist that can cause odd cicumstances which result in MySQL thrashing a bit. I'm running FreeBSD 4.6.2, and have seen the 'rogue thread' problem before which leads me to believe that either FreeBSD has not addressed the problem or MySql hasn't. To be fair MySql says in its documentation that FreeBSD is not recommended because of its threading implementation. It's not a MySQL problem--it's a FreeBSD problem. This problem doesn't exist on other platforms. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 93 days, processed 1,954,122,045 queries (241/sec. avg) - 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
