Re: unauthenticated user | while load testing

Usually this is caused by DNS-based authentication, where the reverse-DNS lookups are hanging for one reason or another. If you can, switch to IP-based authentication and use --skip-name-resolve. / Carsten On 05.01.2011 08:26, Yogesh Kore wrote: Hi, What is unauthenticated user seen

unauthenticated user | while load testing

Hi, What is unauthenticated user seen in mysql processlist ? I am doing load testing and at a single time more than 1000 users are coming to mysql server. Do any one have idea about it?

Problems with unauthenticated user and DB slowing down

www1 = master DB; www2 = slave DB; What I have noticed is that DB goes slow, there are few, sometimes many (20+) unauthenticated user in process list. They hang there for couple of seconds, then disappear. They are in state of 'connecting' and with action 'login'. They never establish connection

Re: Problems with unauthenticated user and DB slowing down

mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2 www1 = master DB; www2 = slave DB; What I have noticed is that DB goes slow, there are few, sometimes many (20+) unauthenticated user in process list. They hang there for couple of seconds, then disappear

Re: unauthenticated user

In news:[EMAIL PROTECTED], Jerome Macaranas [EMAIL PROTECTED] wrote: Would it be possible to prevent reverse lookup? Im using the latest GA version.. Please read the manual section on how MySQL uses DNS. Maciek -- MySQL General Mailing List For list archives:

unauthenticated user

Hi, i got this results from show processlist | 11186 | unauthenticated user | 192.168.1.106:36198 | | Connect | NULL | login | | | 11187 | unauthenticated user | 192.168.1.106:36200 | | Connect | NULL | login | | | 11188 | unauthenticated

Re: unauthenticated user

Hi JM, JM wrote: i got this results from show processlist | 11186 | unauthenticated user | 192.168.1.106:36198 | | Connect | NULL | login | | | 11187 | unauthenticated user | 192.168.1.106:36200 | | Connect | NULL | login | | That's just

Re: unauthenticated user

Would it be possible to prevent reverse lookup? Im using the latest GA version.. thanks, On Wednesday 21 February 2007 23:12, Nils Meyer wrote: Hi JM, JM wrote: i got this results from show processlist | 11186 | unauthenticated user | 192.168.1.106:36198 | | Connect

Unauthenticated User (lots of connections problem)

as: 19331 | unauthenticated user | XXX.XXX.XXX.XXX BLOCKED::http://www.xamo.com:61519 :61519 | NULL | Connect| NULL | Reading from net | NULL The even wierder part is that the IP address it says the connection is coming from isn't the IP address of where it's actually coming from, its

RE: Unauthenticated User (lots of connections problem)

02, 2005 4:55 PM To: mysql@lists.mysql.com Subject: Unauthenticated User (lots of connections problem) There's very few solutions on this problem in my research. I recently discovered a connection issue I cannot debug for the life of me. I don't know if it's related to a network/dns problem

unauthenticated user

Hello, I have had a few systems that began to generate max connection errors. When I run a processlist, there are a lot of the following entries: 5899 | unauthenticated user | xx.xx.xx.xx | NULL | Connect | NULL | Reading from net | NULL | When I restart mysql the entries

unauthenticated user

Hi all, Today I have a strange problem, all the connections to mysql takes like 15-30 minuts to finally connect. When keeping an eye on the proccesslist I notice that I have a lot of these: | 4650 | unauthenticated user | 172.26.0.118:1037 | NULL | Connect | NULL | login | NULL | | 4651

RE: unauthenticated user

user Hi all, Today I have a strange problem, all the connections to mysql takes like 15-30 minuts to finally connect. When keeping an eye on the proccesslist I notice that I have a lot of these: | 4650 | unauthenticated user | 172.26.0.118:1037 | NULL | Connect | NULL | login | NULL | | 4651

unauthenticated user mystery

Hi all, I've been unable to find a single reference to the thread status of unauthenticated user on any mysql documentation - from time to time I get this status when connecting from one particular host. The real problem is that whilst in this state the requesting host appears to those

unauthenticated user

sql,query I have noticed an entry in the processlist which reads UserHostDBCommandState unauthenticated userconnecting host[blank]connectlogin Can someone shed some light on this for me? Where is it coming from? Is it anything to be concerned about? Thanks

Re: unauthenticated user

On Wed, Oct 16, 2002 at 11:30:47AM +0800, Terence wrote: sql,query I have noticed an entry in the processlist which reads UserHostDBCommandState unauthenticated userconnecting host[blank]connectlogin Can someone shed some light on this for me? Where