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

MERGE Engine vs. UNION ALL

We've been experimenting with the merge engine. But suppose that instead of using the MERGE engine I instead modified my code to UNION ALL the shards. Would I get worse performance? In other words, besides the convenience, does the MERGE engine have specific performance optimizations that mak

Load Data Infile Errors

Hello, I have a question about the execution cycle of LOAD DATA INFILE. If I issue a large file via LDI LOCAL, I know that the file is copied to the MySQL server and executed there. But at what point does the statement finish from the sender's point of view? 1) When the file is successfully c

Implementation of Key Caches

According to the 5.1 docs, I can have multiple key caches for MYISAM on a 32-bit host, each with up to 4G. But that means that each cache can take the entire address space of a process. How does the MySQL server get around the limitation? -- MySQL General Mailing List For list archives: http: