In all the examples of a processlist on a mysql slave I've seen, there are two system users. I have a slave that is very far behind the master. When I do show a processlist, there is only one system user (State: "Waiting for master to send event"), the event scheduler, and a trigger user. Is t...
Please look at the Last Paragraph of my answer. Then, please answer all of the following questions: 1) Is Seconds_Behind_Master 0 ? 2) Are there two system user connections in the Processlist ? 3) Is Last Errno 0 ? 4) Does any text appear after Last Error ? 5) Did you run LOAD DATA INFILE on the Master ?
Also I should add that I have seen the second system user pop in and out just lately.
show processlist; +-------+-----------------+-------------------+-------+---------+--------+----------------------------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+-----------------+-------------------+-------+---------+--------+----------------------------------------+------------------+ | 1 | event_scheduler | localhost | NULL | Daemon | 287 | Waiting for next activation | NULL |
You many have to disable binary logging on the Slave.
I had this problem on Friday with a client whose Slave I would reload and setup replication using a bash script. Replication would fall behind 1 sec every 2 seconds with the slave's binary logging enabled. When I disabled binary logging on that slave, the replication lag vanishes in like 2 min.
Discussion between RolandoMySQLDBA an…
Discussion between RolandoMySQLDBA an…