… inadvertently cause flow control on your cluster. The cost of increasing the fc_limit Keeping the fc_limit small has two… fc_limit does however keep the certification index smaller in memory. It keeps the certification interval small, which minimizes replication conflicts…. On a master/slave cluster, therefore, it’s reasonable to increase the fc_limit because the only lagging nodes will be…
Comment: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
April 4, 2013 By 17 Comments
… please guide me, is it safe values ? or can i increase (max_heap_table_size & tmp_table_size) , what values you… temp tables, 44% were created on disk Perhaps you should increase your tmp_table_size and/or max_heap_table_size… tables Note! BLOB and TEXT columns are not allow in memory tables. If you are using these columns raising these values…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… scalability on read-only workloads, especially when the default glibc memory allocator is used. Bug fixed #1131187 (Alexey Kopytov). Removed trx… (Sergei Glushchenko). Fixed the upstream bug #68845 which could unnecessarily increase contention on log_sys->mutex in write-intensive workloads. Bug…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… scalability on read-only workloads, especially when the default glibc memory allocator is used. Bug fixed #1131187 (Alexey Kopytov). Removed trx… (Sergei Glushchenko). Fixed the upstream bug #68845 which could unnecessarily increase contention on log_sys->mutex in write-intensive workloads. Bug…
Post: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
… space can add up. Running small queries might only barely increase memory consumption for given thread, however if table will perform complex…. Monitor how the value changes so you know memory requirements with current settings and increase/decrease values appropriately. Some may say, Hey… you may find out increasing sort_buffer_size from 1MB to 4MB and 1000 max_connections increases peak memory consumption just 30MB not…
Post: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
… how much should I see performance improved in case I increase memory say from 16GB to 32GB. The benefit indeed can be… wait we typically do not expect to gain much by increasing the memory. This however have to be watched carefully. Performance does… runs too slow (and affects other transaction) and may be increasing memory is helpful to solve this problem. If it is IO…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
… have noticed a sharp memory increase after executing a particular query. Or, maybe mysqld is seemingly using too much memory overall. Or again… would execute whatever steps you think are necessary to increase memory usage/trigger the memory problem. You could also just leave the server running for some time (for example, if you have experienced memory increase over…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… whenever sending long data feature is used as it can increase amount of resources prepared statements take on server. There is… are allocated (and how much memory they use). Memory Tables MEMORY tables can take memory. There are implicit MEMORY tables which are allocated for query… 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…
Post: MySQL performance: Impact of memory allocators (Part 2)
March 8, 2013 By 12 Comments
… have a drop at 64/128 threads to ~3500tps 16vcpu – increase in throughput and quite stable results for jemalloc and tcmalloc… allocation,purging of the dirty pages, minimize impact of the memory fragmentation is so significant that becomes bottleneck for the query… better – for instance allocate more arenas but that may notably increase memory footprint. Conclusion: – if your box has 8 cores or less…
Post: Is there benefit from having more memory ?
November 19, 2010 By 10 Comments
…/04/08/fast-ssd-or-more-memory/, caused quite interest, especially on topic SSD vs Memory. That time I used fairy small… more then 128GB of memory? If we use fast solid state drive, should we still be looking to increase memory, or that configuration… same – you should try to fit your active dataset into memory, and it is possible as nowadays systems with 300GB+ RAM…
