… 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: Should I buy a Fast SSD or more memory?
April 8, 2010 By 10 Comments
… point out that once you hit this point, a further increase in memory at all. The B arrow is where the data… get the same improvement with memory, you would have needed to add 60% more memory -or- 260% more memory for a 5x improvement… interesting: Can you easily add another 32G RAM (are your memory slots already filled?) Does your budget allow to install SSD…
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…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
… a chance to check out MySQL Performance on “Memory Appliance” by Violin Memory which can be used as extremely high speed storage system. I helped Violin Memory to optimize MySQL for customer workload and Violin memory and also had a chance to… with single thread it also did not scale well with increased concurrency even though we had 8 cores available for disposal…
Post: When is it a time to upgrade memory ?
September 16, 2008 By 11 Comments
… IO bound or may be just because amount of queries increased dramatically or may be because queries changed their plans. Do… depends on buffer size so you get and understanding what Memory-To-Disk ratio is optimal for your application, or at…_size you can use it as guidance to add more memory or more servers. Of course this is all oversimplifications – you…
Post: Percona-XtraDB-9.1: released and new coming features
March 17, 2010 By 14 Comments
…, was temporary table used, was it disk table or in-memory, and how big was temporary table. Also you can profile… scalability Separate purge thread Limited size of data dictionary in memory Increased number of concurrent write transactions (undo slots) ( up to 4000…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… to have issues as the data size increases and you blow through your available memory. Is there a better architecture?Â… to have issues as the data size increases and you blow through your available memory. Is there a better architecture? Is there… of memory allocated to memcached (full dataset fits ): Here you can see that our “transactions†per second for this app increased…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… optimizations when the workload fits entirely in memory. For the purpose of benchmarking in-memory workload, the InnoDB buffer pool size is…/mrr_buffer_size and both of these buffers should be increased appropriately for the best possible performance gain. This is not… either for MariaDB or MySQL, but you need to appropriately increase read_rnd_buffer_size/mrr_buffer_size because these have…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
… for large data sets. Larger sizes offer better performance but increase recovery times so be careful. I normally use values 64M… might want to increase it. Do not set it too high however as it would be waste of memory – it is flushed… queries there is no reason to increase sort_buffer_size even if you have 64GB of memory to waste. Furthermore doing so…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… if your write working set is, say, 100 GB, then increasing the buffer pool size does not help. PZ: I should… may need to increase size of your Innodb log files to be able to use a lot of memory for write buffering… these non-mysql processes drops rapidly when you increase the amount of system memory. We just deployed a new Linux/Mysql server…
