MySQL Forums
Forum List  »  InnoDB

Re: Exact table count for all tables in a schema.
Posted by: Peter Brawley
Date: September 19, 2019 09:38AM

Think about it---if any transactions are active, there can be no exact answer to your question.

About replication lag ...

- do master & slave status show the same log file name?

- what is master log position - Read_Master_Log_Pos

- what is master Position - Exec_Master_Log_Pos

- what is slave Read_Master_Log_Pos - Exec_Master_Log_Pos

- if using GTIDs see https://blogs.oracle.com/jsmyth/what-causes-replication-lag

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.