MySQL Forums
Forum List  »  InnoDB

30GB innodb_buffer_pool_size?
Posted by: James Day
Date: January 28, 2005 05:17PM

For Wikipedia's English database servers, which make up about half of all database load, I'm considering recommending the purchase of quad Opteron servers with 16GB or 32GB of RAM (and 12-16 or more 15K SCSI drives).

What can I/we expect to see in the way of issues with buffer pools in this size range? How has testing and production use gone? Are there a few customers using equipment of the 16-32GB capacity in production, ideally in a Linux/Opteron setting? What's the theoretical maximum capacity and how high have you gone in practical testing?

As well as read caching, one of my objectives at this size is to hold a large portion of the write working set in dirty pages in the buffer pool, to reduce disk write loads. Here, the 4GB maximum combined log file size is an issue. How many GB of dirty pages can I expect to hold? 2GB? 4GB?

In theory I'm not interested in such large servers. I'd much prefer smaller. But I have to anticipate rapid doubling rates and delivery of software changes allowing load spreading not happening fast enough. Cluster and maybe the federated engine are definitely of interest... but may not be suitably stable and able to handle our record lengths and capacity needs before we need the capacity, so we need to be planning and buying for a few doublings today without assuming their availability. Doesn't stop me from wanting disk-capable Cluster with a year of integration work to be available yesterday though...:)

Options: ReplyQuote

Written By
30GB innodb_buffer_pool_size?
January 28, 2005 05:17PM
January 31, 2005 11:35AM
January 31, 2005 01:39PM
January 31, 2005 05:18PM
January 31, 2005 07:28PM
February 04, 2005 12:16PM
February 04, 2005 08:33PM
February 05, 2005 02:49AM
February 05, 2005 10:33PM
February 08, 2005 01:05PM
February 06, 2005 06:37PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.