…presumably busier with more writes coming from more nodes), the more leeway each node …single node writing in PXC to perform better. gcs.fc_factor If …on your cluster. The cost of increasing the fc_limit Keeping the … the certification index smaller in memory. It keeps the certification interval small…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… refer to the bug #1168032 description for more details. Thanks to Mark McKinstry for …library. Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost…Fixed the upstream bug #68845 which could unnecessarily increase contention on log_sys->mutex in write-…
Post: Should I buy a Fast SSD or more memory?
April 8, 2010 By 10 Comments
… buffer pool of between 2G and 22G (to test performance compared to memory fit). Hardware was our Dell 900 (specs here). To… pool (best performance). It’s important to point out that once you hit this point, a further increase in memory at all. The… To get the same improvement with memory, you would have needed to add 60% more memory -or- 260% more memory for a 5x improvement.Â…
Post: Is there benefit from having more memory ?
November 19, 2010 By 10 Comments
…-or-more-memory/, caused quite interest, especially on topic SSD vs Memory. That time I used fairy small dataset, so it caused more questions… of memory? If we use fast solid state drive, should we still be looking to increase memory, or that configuration provides best possible performance…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… increasing data size? Here is where people start to scratch their heads. They naturally assume they need to scale more, we need more memory! If performance sucks, we must need more. So here comes the bigger boxes…
Post: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
… I guess is how much should I see performance improved in case I increase memory say from 16GB to 32GB. The benefit indeed… not expect to gain much by increasing the memory. This however have to be watched carefully. Performance does not always stays the same… with same cache hit ratio more data and more load means there are higher demands for IO subsystem performance. By far the best…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…a sharp memory increase after executing a particular query. Or, maybe mysqld is seemingly using too much memory overall… to pin down a memory leak bug on a filtered slave (read more in the actual bug…you’ll likely find that the default options will perform well in most scenario’s. For the technically…
Post: When is it a time to upgrade memory ?
September 16, 2008 By 11 Comments
…load is getting more IO bound or may be just because amount of queries increased dramatically or … and see how performance depends on buffer size so you get and understanding what Memory-To-Disk …you can use it as guidance to add more memory or more servers. Of course this is all oversimplifications -…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… some more space can add up. Running small queries might only barely increase memory consumption for given thread, however if table will perform complex… you may find out increasing sort_buffer_size from 1MB to 4MB and 1000 max_connections increases peak memory consumption just 30MB not…
Post: Impact of memory allocators on MySQL performance
July 5, 2012 By 11 Comments
…memory allocator should help to improve scalability, increase throughput and keep memory footprint under the control. In this post I’m going to check impact of several memory allocators on the performance…
