I have a large database running on a machine with 4GB of RAM, so I thought I’d take advantage of this fact, and allocate 1.4GB to the key file and 1GB to the query cache.
For some reason, when I try to set the query_cache_size in my.cnf or use a SET GLOBAL query_cache_size = 1073741824, the value reported by SHOW VARIABLES like ‘%cache%’; goes to 0.
Is there an upper limit determined by MySQL somewhere? I’ve even tried upping the limit gradually, from it’s current setting of 104857600 (100MB) by a few bytes and I get the same result.
Anyone else experienced this or know how this can be circumvented?