MySQL Forums
Forum List  »  MyISAM

The last time a MyISAM table was accessed
Posted by: Gabe Tucker
Date: February 09, 2010 03:27PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
The last time a MyISAM table was accessed
4285
February 09, 2010 03:27PM


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.