Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a mysql slave on AWS/EC2 that receives peak CPU randomally.

I run show full processlits and I get many (few 100s) of processes like this:

'1141944', 'unauthenticated user', 'connecting host', NULL, 'Connect', NULL, 'login', NULL

What is it ?

Any idea on how I can detect what causes the server to suddnely climb to 200 load average?


share|improve this question
Mahesh covered the answer, but please, upgrade your MySQL installation. The early 5.1 builds were some of the worst in the history of MySQL. At least upgrade to a more recent 5.1.x build (5.1.63 is the latest 5.1 rev). – Aaron Brown Aug 3 '12 at 17:40
up vote 3 down vote accepted

Setting skip_name_resolve disables the MySQL server's ability to perform DNS lookups. DNS servers can be unavailable and for a production server it is usually better to specify and ip and not a hostname as the 'host' specifier of a username. However users must then be created as 'user'@’ip’ and not as 'user'@'host' (except for ‘localhost’ what is accepted with this setting ON)

Do not resolve host names when checking client connections. Use only IP addresses. If you use this option, all Host column values in the grant tables must be IP addresses or localhost

share|improve this answer
Dont forget --skip-host-cache. +1 !!! – RolandoMySQLDBA Aug 3 '12 at 15:09

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.