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

Reply via email to