> I'd suggest avoid taking the advice of random people on the internet,
> and do some tests with anywhere from 8GB to 11GB yourself prior to
> putting it in production.
If you have 12GB, it's fairly safe to say that allocating 11GB for the InnoDB buffer pool will not leave you with enough memory for the OS, filesystem buffers, other MySQL buffers and caches, and the per-connection buffers.
Exec.Director @ Open Query (http://openquery....) MySQL services
Sane business strategy explorations at http://upstarta.c...
Personal blog at http://lentz.com....