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:

Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

If you like this post, then please share it with others.
Please follow, I will share my experience towards the success of Database Research and Development Activity.

I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.

More from

Leave a Reply

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

Notify of

Sort by:   newest | oldest | most voted
6 months 8 days ago

Thank U Sir

6 months 8 days ago

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.