MySQL: Script to find last Updated time of the Table

In this post, I am sharing one of the basic DBA query to find the last updated time of the MySQL Table.

We can also check the row level last updated time by adding one extra column into table like, last_updated_datetime.
Generally for reporting purpose, we are using this approach to check the row level last updated datetime.

As a Database Administrator, This is our responsibility to monitor some of the important tables of our MySQL database.
Here, The DBA requires to know last updated time at the Table Level.

We can use information_schema.tables to find information of the MySQL tables.

Using information_schema.tables:

Using Status Command:

Anvesh Patel

Leave a Reply

3 Comments on "MySQL: Script to find last Updated time of the Table"

Notify of
avatar
Sort by:   newest | oldest | most voted
Srinu
Guest

Thank U Sir

Srinu
Guest

Hi Sir I am Srinu From Telangana ,
Sir Your Website is Very Use Full Information for Me and Sir Can You Provide me Checkpoint Information and Backups Pls.

wpDiscuz