The last time a MyISAM table was accessed
HI All,
I am trying to determine when the last time certain tables were accessed [possibly using a SELECT statement].
Using SHOW TABLE STATUS does not give this information.
Using atime [ls -lut], I did not see the date/time change on the files for these tables when I ran either a select or flush.
MySQL Version: 5.0.51a
Debain - Lenny
Any ideas would be appreciated.
Thanks,
- Gabe
Subject
Views
Written By
Posted
The last time a MyISAM table was accessed
4285
February 09, 2010 03:27PM
2171
February 10, 2010 08:31PM
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.