"my.cnf" add this: "skip-name-resolve" under "[mysqld]"
On 8/29/05, Callum McGillivray <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] > > -- Best Wishes, Xiaodong -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]