List:General Discussion« Previous MessageNext Message »
From:Xiaodong Deng Date:August 29 2005 9:30am
Subject:Re: mySQL Performance Problems - Help !!
View as plain text  
"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
Thread
mySQL Performance Problems - Help !!Callum McGillivray29 Aug
  • Re: mySQL Performance Problems - Help !!Xiaodong Deng29 Aug
  • Re: mySQL Performance Problems - Help !!Brent Baisley29 Aug