Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do you get the last access (and/or write) time of a MySQL database?

How do you find out the last time a MySQL database was read or written to?

Can you even do that check per table?

like image 864
Neil Avatar asked Jan 01 '26 07:01

Neil


1 Answers

SELECT UPDATE_TIME
FROM   INFORMATION_SCHEMA.TABLES
WHERE  TABLE_SCHEMA = 'dbname'
AND    TABLE_NAME = 'tabname'

Source: How can I tell when a MySQL table was last updated?

like image 52
lecodesportif Avatar answered Jan 03 '26 22:01

lecodesportif



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!