What table types? The filesystem doesn't have this info for innodb or memory tables (tablespaces, sure...)
-Sheeri 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 > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
