Jens Hjalmarsson wrote:
> 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?
Please repost and include the output of:
uname -a (hide the host in the post if you want)
ldd /path/to/mysqld
You did not even include your OS which makes it kinda hard for at least me
to help.
--Bill
---------------------------------------------------------------------
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
