… with highest memory available, and memory is what really really matters. High-Memory Quadruple Extra Large Instance 68.4 GB of memory 26 EC2… rate drop was mainly caused by IO pressure caused by increase in flushing and checkpointing activity. This caused spikes in write… even going away with secondary indexes causes a write throughput increase of 2x to 3x. In this particular case, since I…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 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: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 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: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… workload fits entirely in memory, because there is no extra cost for memory access at random locations versus memory access at sequential locations…, and hence, there is a slight increase in query time for MySQL 5.6, increase of 0.02s. But the query times… Innodb_rows_read. While MySQL 5.6 is also reporting increased numbers for the counter Handler_read_key. This is because…
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: MySQL Server Memory Usage
May 17, 2006 By 18 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: 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…
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…
