Find creation date of cache tables

From EPrints Documentation
Jump to: navigation, search

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]';