MySQL Bugs: #20681: Support wild cards in table names on CACHE INDEX statement

Bug #20681	Support wild cards in table names on CACHE INDEX statement
Submitted:	24 Jun 2006 22:12	Modified:	29 Jun 2006 13:21
Reporter:	J Rabbit	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: MyISAM storage engine	Severity:	S4 (Feature request)
Version:	5.0.22	OS:	Windows (Windows 2003)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
It would be useful to be able to specify the cache for an entire database in one go with a statement such as:

CACHE INDEX databasename.* IN cachename

or for a group of tables with:

CACHE INDEX LIKE 'pattern%' IN cachename

Currently the cache index statement requires a list of specific table names.

It would also be useful if the first form was applied to any tables created in the database at a future point in time

How to repeat:
n/a

Thank you for a resonable feature requests.