We're getting loads of binlog files in our MySQL 5.0.x. We have a normal master/slave replication thing going with 1 master, 1 slave. Looking at /var/log/mysql.log, nearly 90% of the time the replicator connects and does a
SHOW SLAVE HOSTS causes a bin log dump.
7020 Query SHOW SLAVE HOSTS 7020 Binlog Dump Log: 'mysql-bin.029634' Pos: 13273
However when I do a
SHOW SLAVE HOSTS on the mysql myself, I get no results.
Occasionally when the replicator does a
SHOW SLAVE HOSTS, mysql will hang for hours. I see nothing in the
/var/log/syslog at the same time...
What's going on here? How can I debug this more?
For the record the MySQL master and slave servers are ubuntu dapper.