On 09-Jul-01 Mario Witte wrote:
> Hello,
>
> we are running a mysql-3.23-39 server under Suse 7.1 which has to do a very
> high number of insert-queries (somewhere around 600 queries/minute).
>
> But since yesterday the server kepps on spawing processes which are
> reported to belong to "Unauthenticated user" and in state "Login". This
> continues until max_connections is reached and then the server quits
> without further error messages. (Neither in the error log nor in the
> query-log).
>
> We have already tried reinserting all data from a dump, using a different
> server and different mysql-version.
> It shouldn't be a load problem, because before the problem occured the
> server (a Compaq Proliant with a 933 Mhz Xeon cpu) was running on a load
> average below 0.10.
>
Stop Apache (or whatever the source of your logins), shut down & restart
mysqld, then check/repair the tables in the mysql database; might want check
any other high activity tables also.
restart Apache.
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
---------------------------------------------------------------------
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
