Tell me more ×
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. It's 100% free, no registration required.
up vote 1 down vote favorite

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

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

1 Answer

up vote 3 down vote

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

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

Your Answer

 
discard

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.