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 command
> Otherwise, you could try to use the binlog. The filesystem sure would be
> easy though...
for mysql < 5.0
show table status
--
Pooly
Webzine Rock : http://www.w-fenec.org/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[E
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 esp
