Take the 2-minute tour ×
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.

I had used --report-host option in one of my slaves, so that I could see that under SHOW SLAVE HOSTS. Now that server is no longer in use. I have uninstalled that server as well. Unfortunately I still see the details of that server under SHOW SLAVE HOSTS(When this is executed on the uninstalled server's master) which is incorrect.

What changes should I make such that SHOW SLAVE HOSTS gives me the correct output?

share|improve this question

2 Answers 2

You will have to check the following items

  • If the decommissioned Slave server still has /etc/my.cnf, do one of the following
    • rm -f /etc/my.cnf
    • mv /etc/my.cnf /etc/my.cnf.old
  • If the Master Server still has any --report-host in its /etc/my.cnf
    • remove report-host from /etc/my.cnf
    • service mysql restart
  • You may need service mysql restart on the Master anyway
  • Make sure you delete master.info in the datadir of the old Slave

Give it a Try !!!

share|improve this answer
I am afraid it did not work. –  omggs Sep 5 '12 at 7:30
Updated my answer... –  RolandoMySQLDBA Sep 5 '12 at 14:52

I find that executing a FLUSH command helps in refreshing the SHOW SLAVE HOSTS output. It isn't deterministic; I sometimes need to execute two or three FLUSH commands, but it certainly refreshes.

I found that either FLUSH LOGS or FLUSH STATUS do the job.

share|improve this answer

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.