Index Caching with Merge Engine

We are currently evaluating the merge engine. Right now we create and
preload several index caches.

But what is the best way to approach this with a merged table? Do I
create a single index cache and assign all of the shards to it?

Or do I create a separate index cache for each shard?

I didn't get a response on the Merge forum.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2 [at] m.gmane.org
James.W.McKelvey [ Do, 07 April 2011 18:06 ] [ ID #2057704 ]
Datenbanken » gmane.comp.db.mysql.general » Index Caching with Merge Engine

Vorheriges Thema: efficient use of varchar?
Nächstes Thema: MERGE Engine vs. UNION ALL