…memory available, and memory is what really really matters. High-Memory Quadruple Extra Large Instance 68.4 GB of memory… indexes causes a write throughput increase of 2x to 3x. In this particular case,… things to consider when you are concerned with write performance is using partitioning to reduce…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… when connection is closed, other correspond to global memory allocation and will result in increased memory allocation until server is restarted. I would suspect memory leak when you see memory usage growing…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… that with just the join_buffer_size increased to 6M, the query time was ~300s while when both the join_buffer_size and… set to 6M, the query time dropped to ~40s. So the maximum possible benefit is when size of both the buffers is increased appropriately… in-memory workload. I intend to run tests to see what specific types of queries would benefit from Hash Join as compared to Nested…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… MRR when the workload fits entirely in memory. For the purpose of benchmarking in-memory workload, the InnoDB buffer pool size is set to… difference to the query times for MySQL 5.6, when the workload fits entirely in memory, because there is no extra cost for memory…, and hence, there is a slight increase in query time for MySQL 5.6, increase of 0.02s. But the query times…
Post: When is it a time to upgrade memory ?
September 16, 2008 By 11 Comments
…busy sooner or later. How to figure out if it is time for upgrade when ? Look at number of …your working set fits to the memory very well if it is hundreds you’re likely to be IO bound or…to 50 reads/sec may be because load is getting more IO bound or may be just because amount of queries increased…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… gains to very significant ones. Also do not forget you may need to increase size of your Innodb log files to be able to use a lot of memory for write buffering efficiently… used for these non-mysql processes drops rapidly when you increase the amount of system memory. We just deployed a new Linux/Mysql…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
… buffers. This is memory which you can consider used when you just start MySQL Server. The rest of memory is available for connections… space can add up. Running small queries might only barely increase memory consumption for given thread, however if table will perform complex… simple queries memory consumption is often less than 1MB per thread with default buffers, and you really do not need to increase per…
Post: Should I buy a Fast SSD or more memory?
April 8, 2010 By 10 Comments
… performance). It’s important to point out that once you hit this point, a further increase in memory at all. The B arrow is where the data just started to exceed the size of… needed to add 60% more memory -or- 260% more memory for a 5x improvement. Imagine a situation where your C point is when…
Post: When to use Hardware upgrade instead of Software Optimization
December 5, 2008 By 5 Comments
… be valid choice allowing to take a hardware boost later down the road when you need a major performance increase and do not…. You add the index to avoid full table scan and make given query faster. You add memory to avoid disk IO and make… use to understand what needs to be done (gettings SSD, upgrading memory, upgrading CPUs). There are number of balancing questions you have to solve…
Post: How adding another table to JOIN can improve performance ?
August 1, 2008 By 12 Comments
… many similar cases when it is not possible. I have described couple of solutions to this problem – using … for this (in memory) table but will become unacceptable as soon as you get to do random disk IO… it is. I also tried to increase cardinality by having all rows to have different group_id and it …
