Mailing List Archive


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[tlug] How to check when a MySQL table was last SELECTED



Hello TLUG,

Oddball MySQL question:

Does anyone know if there is a way to get when a table was last used
by a SELECT?

It would be something I would expect to find in 'SHOW TABLE STATUS
LIKE ...' but I guess that would be quite expensive to track all of
the time. Maybe there is an extended stats mode?

Cheers,
Sach


Home | Main Index | Thread Index

Home Page Mailing List Linux and Japan TLUG Members Links