The default bug view has changed. See this FAQ.

[AMO] Increase innodb_buffer_pool



Infrastructure & Operations
WebOps: Other
8 years ago
4 years ago


(Reporter: jbalogh, Assigned: justdave)


Bug Flags:
needs-downtime +


(Whiteboard: 10/29/2009 @ 9pm)



8 years ago
From bug 522112 comment 0:
> Per recommendation from Percona, our addons DB would perform best with at least
> 10 GB of innodb_buffer_pool and at least a few gigs of index cache.  To achieve
> this, we need to get all of the servers up to 16 GB of RAM.

We have the RAM now, let's use it. :)
Assignee: server-ops → justdave
Master database will need downtime for a mysqld restart (should be fairly instantaneous, but might throw a few spurious errors to web clients when it happens)

Slaves can be done while pulled from the load balancer pool, so can be done whenever.  They all need to be done.

I know innodb_buffer_pool needs to go to 10G.  There's a couple other memory-related settings that needed to be tweaked, too, and I still need to research on those.
Flags: needs-downtime+


8 years ago
Whiteboard: 10/27/2009 @ 9pm


8 years ago
Whiteboard: 10/27/2009 @ 9pm → 10/29/2009 @ 9pm
OK, this is done.

Made the following changes:

innodb_buffer_pool_size=10G (up from 2G)
innodb_flush_method=O_DIRECT  (wasn't present before - based on Percona recommendation)
key_buffer=1G   (up from 300M)
query_cache_size=1G (up from 128M)
Last Resolved: 8 years ago
Resolution: --- → FIXED
Group: infra

Comment 3

8 years ago
(In reply to comment #2)
> query_cache_size=1G (up from 128M)

"Be cautious about sizing the query cache excessively large, which increases the overhead required to maintain the cache, possibly beyond the benefit of enabling it. Sizes in tens of megabytes are usually beneficial. Sizes in the hundreds of megabytes might not be."

I'm not sure how you profile the effectiveness of the query cache, but we should be mindful of this.
Is there really a point to using the query cache?  Our data gets cached in memcache, the query cache isn't buying us much.
ok, we should probably bump that one back down again then.
Component: Server Operations: Web Operations → WebOps: Other
Product: → Infrastructure & Operations
You need to log in before you can comment on or make changes to this bug.