Not the answer you need?
Register and ask your own question!

Mysql Replication Lag is increasing continuously

farhanafarhana EntrantInactive User Role Beginner
Hi Team,
Could anyone please help me to come out of this situation. When i actually change the
pt-online-schema-change -u root --ask-pass --alter "MODIFY COLUMN id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT" on production changes reflected. But it has a slave where i see the relication delay is continuously increasing. unfortunately i dont see any long running query in slave. The queries are changing. Master_Log_File: mysql-bin.001797 Read_Master_Log_Pos: 289879640 Relay_Log_File: mysqld-relay-bin.005384 Relay_Log_Pos: 217855411 Relay_Master_Log_File: mysql-bin.001788 Slave_IO_Running: Yes Slave_SQL_Running: Yes Seconds_Behind_Master: 66980 The table we are updating is around 30G.Please ask if for any queries. Thanks for your time in advance.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.