From: Date: August 29 2005 11:30am
Subject: Re: mySQL Performance Problems - Help !!
List-Archive: http://lists.mysql.com/mysql/188400
Message-Id: <8d4c7b07050829023010a1e775@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

"my.cnf" add this: "skip-name-resolve" under "[mysqld]"


On 8/29/05, Callum McGillivray <callummc@stripped> wrote:
> Hi all,
>=20
> I'm pretty new to the list, so please be kind :)
>=20
> I'm having serious problems with our core mysql server.
>=20
> We are running a Dell Poweredge 2850 with dual Xeon 3.0 processors, RAID
> 5 and 1Gb memory.
>=20
> 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=
).
>=20
> 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.
>=20
> 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             |
>=20
> 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.
>=20
> Can anyone point me in the right direction here ?
>=20
> 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.
>=20
> We have run this server for several years (recently we upgraded the
> hardware without problems) and we have never experienced anything like th=
is.
>=20
> 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.
>=20
> Please - if anyone can give me any insight at all on this it would be
> MOST appreciated.
>=20
> Warm regards,
>=20
> Callum
>=20
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=3Dkafeifei@stripped=
m
>=20
>=20


--=20
Best Wishes,

Xiaodong