Link to home
Create AccountLog in
Avatar of Geoff Millikan
Geoff MillikanFlag for United States of America

asked on

MySQL Replication > Seconds behind master

Slave isn't updating but master and slave are talking (see below). This is a Win7 slave pulling from a Linux master over MySQL SSL connection.  

Was working last week.  What gives?

Slave_IO_State: Waiting for master to send event
Master_Log_File: mysqld-bin.000198
Read_Master_Log_Pos: 1791914	
Relay_Log_File: rabbithill-relay-bin.000389
Relay_Log_Pos: 699706784
Relay_Master_Log_File: mysqld-bin.000192
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Last_Errno: 0
Last_Error:
Master_SSL_Allowed: Yes
Seconds_Behind_Master: 849488 *******
Master_Server_Id: 1
Master_SSL_CA_File: C:\Program Files\MySQL\MySQL Server 5.5\certs\ca-cert.pem
Last_IO_Errno: 0

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of johanntagle
johanntagle
Flag of Philippines image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of Geoff Millikan

ASKER

It was a string of huge queries that had the slave bogged down just like you said.