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 in

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?

Re: Problems with unauthenticated user and DB slowing down

d www2 are same hardware. On both is apache, with mysql: > www1:~# mysql --help > 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

Problems with unauthenticated user and DB slowing down

adline 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. They are in state of 'connecting' and with action 'login'. T

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: http://lists.mysql.com/m

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 | unaut

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 |

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 | unaut

RE: Unauthenticated User (lots of connections problem)

Sent: Thursday, June 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 relate

Unauthenticated User (lots of connections problem)

s appear on the server as: 19331 | unauthenticated user | XXX.XXX.XXX.XXX 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

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 are

RE: unauthenticated user

cated 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 | |

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

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 a

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 s

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