align-toparrow-leftarrow-rightbackbellblockcalendarcamerachatcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-crosscrosseditfacebookglobegoogleimagesinstagramlocation-pinmagnifying-glassmailmoremuplabelShape 3 + Rectangle 1outlookpersonplusImported LayersImported LayersImported Layersshieldstartwitteryahoo

Re: [brisbane-webtech] MySQL Innodb Pool Size

From: Arjen L.
Sent on: Tuesday, October 30, 2012 10:33 AM
Hi Peter

> 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­

Our Sponsors

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy