… 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: 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: 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: Impact of memory allocators on MySQL performance
July 5, 2012 By 11 Comments
… utilization of CPU/RAM resources. Efficient 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…
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: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… graph). MySQL’s general recommendation for this case is to increase innodb_io_capacity and decrease innodb_max_dirty_pages_pct…_dirty_pages_pct limit. Another possible solution would be to increase innodb_log_file_size, but that: 1) only delays the… throttling mechanism that will limit the rate of changes in memory. Optimize the flushing of sequential neighbor pages in a way…
