roopurt18 Posted September 27, 2006 Share Posted September 27, 2006 Is there a query that will return the last date all of the tables in a database were last accessed? By accessed I mean data inserted, retrieved, or other such operations.I ask because I've inherited a project that has a lot of tables that need to go. I've done what I can to eliminate some of them but I want to make sure there's no application code still running queries on them. Link to comment https://forums.phpfreaks.com/topic/22279-determine-last-access-date-for-all-tables-in-a-db/ Share on other sites More sharing options...
fenway Posted September 27, 2006 Share Posted September 27, 2006 At least for MyISAM tables, SHOW TABLE STATUS returns a column named update_time. Link to comment https://forums.phpfreaks.com/topic/22279-determine-last-access-date-for-all-tables-in-a-db/#findComment-99792 Share on other sites More sharing options...
roopurt18 Posted September 27, 2006 Author Share Posted September 27, 2006 Thanks! Link to comment https://forums.phpfreaks.com/topic/22279-determine-last-access-date-for-all-tables-in-a-db/#findComment-99899 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.