…cluster to instruct the group when it needs replication to pause and when it is ready for replication to…however keep the certification index smaller in memory. It keeps the certification interval small, … master/slave cluster, therefore, it’s reasonable to increase the fc_limit because the only …
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…-29.3 which could cause a server to hang when binary log is enabled. Bug fixed #… scalability on read-only workloads, especially when the default glibc memory allocator is used. Bug fixed #1131187… Fixed the upstream bug #68845 which could unnecessarily increase contention on log_sys->mutex in write-…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…-29.3 which could cause a server to hang when binary log is enabled. Bug fixed #… scalability on read-only workloads, especially when the default glibc memory allocator is used. Bug fixed #1131187… Fixed the upstream bug #68845 which could unnecessarily increase contention on log_sys->mutex in write-…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
… downloaded (3.8.1 here) There are several advantages to self-compiling: When using the latest version of Valgrind, even compiled ‘out…), you would execute whatever steps you think are necessary to increase memory usage/trigger the memory problem. You could also just leave the server…
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: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 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: MySQL Server Memory Usage
May 17, 2006 By 21 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: MySQL performance: Impact of memory allocators (Part 2)
March 8, 2013 By 12 Comments
… the very specific case when overhead from the advanced techniques used in these allocators that should help to speed up allocation,purging… allocators can be tuned to handle such cases better – for instance allocate more arenas but that may notably increase memory footprint. Conclusion: – if…
