Re: Does CACHE INDEX support wildcards?
Posted by:
J Jorgenson
Date: September 13, 2006 11:12AM
Is there any mechanisim to 'Round-Robin' / wildcard usage of multiple key-cache.
Currently the docs only provide a means to assign a table's index to a single *specific* keycage...
How about multiple 'default' key-caches?
I've got some 5 databases.... each with 5000+ tables... 20g RAM each (to be increased). Many tables are VERY large (300gb) & partitioned (*10), some small... It is not reasonable to specify EACH table to a specific key-cache.
(Please don't go into a discussion on 'normalizing' data... That would be an issue out-of-scope to this thread)
If there is no built-in 'mysql' mechanisim to 'round-robin' multiple key-buffers, I would recommend to other users to write a script/SQL procedure that does an 'information_schema.tables' query to assign tables to the key-cache, in a round-robin fashion.
Subject
Views
Written By
Posted
2507
June 27, 2006 10:20PM
1491
June 28, 2006 08:06AM
Re: Does CACHE INDEX support wildcards?
1539
September 13, 2006 11:12AM
1423
October 04, 2006 02:12PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.