… primary key lookup. Thereby, converting Random access to one or more sequential access. There is one another interesting thing that has… workload fits entirely in memory, because there is no extra cost for memory access at random locations versus memory access at sequential locations… is no performance improvement when the workload is in-memory, in fact MRR adds extra sorting overhead which means that the queries…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… their features and intended purpose. I want to add a little context. What problem were we … so the problem remains undetected while it becomes more and more severe. This can cause two serious …unix-memory plugin checks for a single process consuming too much memory and/or for too little free memory…
Post: Should I buy a Fast SSD or more memory?
April 8, 2010 By 10 Comments
… To get the same improvement with memory, you would have needed to add 60% more memory -or- 260% more memory for a 5x improvement. Imagine… add another 32G RAM (are your memory slots already filled?) Does your budget allow to install SSD cards? (You may still need more… enough? There are more wins to be had if you can afford to buy all the memory that is required. The…
Post: When is it a time to upgrade memory ?
September 16, 2008 By 11 Comments
… is already 90% full, should I be thinking about upgrading memory already?” This is a wrong way to put the question… depends on buffer size so you get and understanding what Memory-To-Disk ratio is optimal for your application, or at…_buffer_pool_size you can use it as guidance to add more memory or more servers. Of course this is all oversimplifications – you’ve…
Post: More patches
November 11, 2008 By 2 Comments
… process, more – innodb_io_pattern.patch. The patch shows IO accesses to InnoDB tablespaces, more – innodb_show_hashed_memory.patch. This adds more information into SHOW INNODB STATUS about internal InnoDB memory allocations, more – microsec_process.patch – adds new table…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 16 Comments
… to MySQL make it scale better for this workload when more resources (such as additional CPUs) are added. By scaling better…. If I needed more performance I could divide the data between two or more shards, or if possible, I could add more CPU cores… adding CPUs will help only until we run out of memory bandwidth. Test #2 My second test involved the next four…
Post: Finding an optimal balance of I/O, CPU, and RAM for MySQL
May 16, 2011 By 4 Comments
… how MySQL scales as you add more memory to the server. Vadim recently benchmarked the effects of increasing memory and CPU core count. He… was sponsored by Virident, is that as you add CPUs and increase memory size, MySQL doesn’t scale as well as we…, and solid-state storage — specifically, the Virident tachIOn drive — has more bandwidth than MySQL can fully utilize at present. Therefore, to…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
…. Take this number add to it number of memory Operation System and other applications need, add might be 32MB more for MySQL Server code and various small static buffers. This is memory…. If transaction is started some more space can add up. Running small queries might only barely increase memory consumption for given thread, however…
Post: Replication of MEMORY (HEAP) Tables
October 15, 2010 By 6 Comments
… will bite when you will be looking to add Replication to your environment as MEMORY tables do not play well with replication… could have features to make it more convenient. It would be great to have MEMORY table option which would save table to… simply allow to avoid all replication errors for MEMORY table which would make things more robust if table is regenerated periodically. It…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
… a good use for that memory anyway. Another thing you should keep into account is Innodb allocates more memory in structures related to… allocated. There are also things like innodb additional memory pool (which can grow more than memory you allocated for it, especially in case… numbers, for example sum up all your global buffers plus add 1MB for each connection you’re planning to have but…
