I have a slave that claims, in SHOW SLAVE STATUS
, to be zero seconds behind the master.
However, it also says it's on Master_Log_File binlog.009636, which is 46.9 gig behind where the master is. I can look at the database and see the tables are all out of date.
No replication-related queries are running; the threads say "Waiting for master to send event" and "Has read all relay log; waiting for the slave I/O thread to update it." Yet the log IS moving, as it's now 46.7 gig behind.
What is going on here? Server is MySQL 5.0.95.