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


Subject
Views
Written By
Posted
Re: Exact table count for all tables in a schema.
484
September 19, 2019 09:38AM


Sorry, you can't reply to this topic. It has been closed.

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.