Hello,
After upgrading to 4.0.4 from 4.0.2 on three server we have got some
mysterious problems with one of the server.
Several times it appears to be dead. Connecting takes a very long time,
and the CPU load goes throug the roof and beyond.
The two other servers runs without problems. The only difference between
the servers is that the one with problems is a master for the two others
(replicating one DB), and the machine is dual CPU. All serveres run Linux.
When the problem occurs I have tailed the slow-log. This crops up every
time when there is a problem. I have no idea what it is!
# administrator command: Statistics;
# User@Host: xxx
# Query_time: 31 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
# administrator command: Statistics;
# User@Host: xxx
# Query_time: 32 Lock_time: 0 Rows_sent: 1 Rows_examined: 70
# administrator command: Statistics;
# User@Host: xxx
# Query_time: 33 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
I think this statistics command may be what is causing the problems, so
can anybody tell me what is happening?
Regards,
Arne
--
--------------------------------
Arne K. Haaje | T: 69 92 04 90
Bregneveien 9 | F: 69 92 04 91
1825 Tomter | M: 92 88 44 66
--------------------------------
http://www.drlinux.no/
---------------------------------------------------------------------
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
