Find creation date of cache tables: Difference between revisions
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…' |
mNo edit summary |
||
| Line 2: | Line 2: | ||
mysql> select TABLE_SCHEMA, TABLE_NAME, CREATE_TIME from information_schema.tables WHERE TABLE_NAME RLIKE 'cache[0-9]'; | mysql> select TABLE_SCHEMA, TABLE_NAME, CREATE_TIME from information_schema.tables WHERE TABLE_NAME RLIKE 'cache[0-9]'; | ||
[[Category:Snippets]] | |||
Latest revision as of 12:16, 22 December 2010
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]';