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

[24 Jun 2006 22:12] J Rabbit
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
[29 Jun 2006 13:21] Valeriy Kravchuk
Thank you for a resonable feature requests.