unauthenticated user | while load testing

--20cf3054a475f577690499144c55
Content-Type: text/plain; charset=ISO-8859-1

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?

--20cf3054a475f577690499144c55--
Yogesh Kore [ Mi, 05 Januar 2011 08:26 ] [ ID #2052565 ]

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2 [at] m.gmane.org
Carsten Pedersen [ Mi, 05 Januar 2011 09:08 ] [ ID #2052566 ]
Datenbanken » gmane.comp.db.mysql.general » unauthenticated user | while load testing

Vorheriges Thema: Best practice migrating mysql 4.1.x -> 5.0.x with mixed innodb myisamtables
Nächstes Thema: Moving data between two servers with SQL