Hello,
I just moved my databases from one machine to another. I recompiled
the whole thing, but I have some problems. MySQL now locks up, and
takes 100% cpu, after an hour or two. I need to shut it down and
restart it, and then it goes another hour again.
The machine is a dual pIII 866 with 2gb ram, dedicated to MySQL. It
serves two frontends running Apache. I am using the my-huge.cnf, with
max_connections set to (currently) 250, but I've tried both more and
less.
I am currently testing it with the binaries provided on MySQL.com,
and so far it hasn't crashed. But, it hasn't gone two hours yet.
So, why does MySQL lock up on me?
Jens
---------------------------------------------------------------------
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
