On 2/3/06, Andrew Braithwaite <[EMAIL PROTECTED]> 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? > > Cheers, > > Andrew > > SQL, Query
Well, you didn't include your MySQL version, but if you're 5.0+ you could do: select update_time from information_schema.tables where table_name='tablename' Otherwise, you could try to use the binlog. The filesystem sure would be easy though... -jp