1

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?

Thanks

1
  • 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). Commented Aug 3, 2012 at 17:40

1 Answer 1

3

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

http://dev.mysql.com/doc/refman/5.0/en/host-cache.html

1
  • Dont forget --skip-host-cache. +1 !!! Commented Aug 3, 2012 at 15:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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