"my.cnf" add this: "skip-name-resolve" under "[mysqld]"
On 8/29/05, Callum McGillivray <callummc@stripped> wrote:
> Hi all,
>
> I'm pretty new to the list, so please be kind :)
>
> I'm having serious problems with our core mysql server.
>
> We are running a Dell Poweredge 2850 with dual Xeon 3.0 processors, RAID
> 5 and 1Gb memory.
>
> There are 3 main databases running on this machine, one is a freeradius
> database, one is for vpopmail and the other is for cacti (MRTG based tool).
>
> At the moment, we find the suddenly, our mail server or cacti server
> will establish several hundred connections to the database that just
> seem to be sit in an "unauthenticated" state.
>
> E.G.
> | 6452 | unauthenticated user | xxx.xxx.xxx.xxx:40923 | NULL
> | Connect | NULL | login | NULL |
> | 6453 | unauthenticated user | xxx.xxx.xxx.xxx:40924 | NULL
> | Connect | NULL | login | NULL |
>
> The server starts dragging it's heals and mail and cacti virtually stop
> altogether. There does not seem to be any unusual CPU / I/O or memory
> usage when this happens.
>
> Can anyone point me in the right direction here ?
>
> I'm more than happy to provide any configuration information that is
> required - but this is killing us and I need to know what is going on.
>
> We have run this server for several years (recently we upgraded the
> hardware without problems) and we have never experienced anything like this.
>
> I am at my wits end and not having had any formal training in mySQL
> servers, I simply don't know what I should be looking at next.
>
> Please - if anyone can give me any insight at all on this it would be
> MOST appreciated.
>
> Warm regards,
>
> Callum
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
>
--
Best Wishes,
Xiaodong
