On Tue, Jun 9, 2009 at 5:23 PM, Gaby Vanhegan <g...@vanhegan.net> wrote: > On 9 Jun 2009, at 22:07, Ted Unangst wrote: > >> There are hard limits that you can't exceed. > > If the machine has mare than enough physical RAM and tons of swap, is there > no way to configure MySQL to hold a 2Gb buffer in memory? I really want to > avoid building a custom kernel and it feels like I should be able to get > this working using login.conf, ulimit and sysctl settings. Or is this a > wall that is not meant to be broken through?
The short answer is that you can't use more than 1GB of memory.