Difference between revisions of "Find creation date of cache tables"
(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…') |
m |
||
| 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]';
