Find creation date of cache tables
Revision as of 12:12, 22 December 2010 by Libjlrs@leeds.ac.uk (talk | contribs) (Created page with 'To see the date that your cache tables were created, use the following MySQL comment (run as a 'powerful' mysql user): mysql> select TABLE_SCHEMA, TABLE_NAME, CREATE_TIME from i…')
To see the date that your cache tables were created, use the following MySQL comment (run as a 'powerful' mysql user):
mysql> select TABLE_SCHEMA, TABLE_NAME, CREATE_TIME from information_schema.tables WHERE TABLE_NAME RLIKE 'cache[0-9]';
