On 2/3/06, Andrew Braithwaite <Andrew@stripped> wrote:
> Hi everyone,
> Does anyone know if there is a way to get the last access time from a
> mysql table through mysql commands/queries?
> I don't want to go to the filesystem to get this info.
> I understand that this could be tricky especially as we have query
> caching turned on and serve quite a few sql requests from query cache.
> Can anyone help?
> SQL, Query
Well, you didn't include your MySQL version, but if you're 5.0+ you could
select update_time from information_schema.tables where
Otherwise, you could try to use the binlog. The filesystem sure would be