Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I got cacti running the mysql monitoring templates (http://mysql-cacti-templates.googlecode.com/files/better-cacti-templates-1.1.8.tar.gz). I have multiple servers with each running multiple mysql instances on different ports. I'm getting tons of errors along the lines of

"WARNING: Result from CMD not valid. Partial Result: MySQL: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 "

The weird thing is some of the checks are working properly. It doesn't seem to be 100% failure per host or per port.

What's going on?

share|improve this question

1 Answer 1

It seems that you should check your ports configurations as well as try to increase maximum number of connections allowed by adding in your configuration file the following

max_connection=N

where N is large enough. Then restart mysql. You can also see here (http://forums.cacti.net/viewtopic.php?f=21&t=44773). If it is your question there, probably it is better to post here that you've resolved your problem and what was the matter.

share|improve this answer

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.