…memory available, and memory is what really really matters. High-Memory Quadruple Extra Large Instance 68.4 GB of memory…buffer pool is sized at 55G and I am using 4 buffer pool instances to reduce the contention caused by buffer pool…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… and fill that in. During the time that you are modifying a partition it fits in main memory (and … B-tree pretty efficiently. With a 55GB buffer pool, we would expect the primary table to simply… Mark wrote http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…and look for memory information block, which can use like this: ———————- BUFFER POOL AND MEMORY ———————- Total memory allocated 132183490560; in additional pool…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… is available in both MySQL 5.6 and MariaDB 5.5. You can read more about BKA in MySQL 5.6 here and BKA in MariaDB 5… workload fits entirely in memory. For the purpose of benchmarking in-memory workload, the InnoDB buffer pool size is set to 6G and the buffer pool was warmed up…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… workload fits entirely in memory. For the purpose of benchmarking in-memory workload, the InnoDB buffer pool size is set to 6G and the buffer pool was warmed up, so that the relevant pages were already loaded in… in MariaDB 5.5 and not in MySQL 5.6, is that because of a bug in MySQL 5.6 code? As MRR was used in both MySQL…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the… available in both MySQL 5.6 and MariaDB 5.5 Now let’s take a look briefly at what this enhancement actually is, and…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 5 Comments
…) writing in the log. Dirty Buffer Pool Pages On the other side, we have dirty buffers. These two numbers are relevant from the BUFFER POOL AND MEMORY section… MySQL server, you should be monitoring your Checkpoint age and your Innodb dirty pages and try to see the relationship with those values and…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
… implementation which appeared in MySQL 4.0 Query Cache was designed to work with single core systems and relatively small memory amounts, both of… we can use same “cheat” as MySQL 5.5 uses for Innodb Buffer Pool and have multiple MySQL Query Cache instances hashed by query hash…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
… to simply check it. Start MySQL With 10GB Innodb buffer pool for example and see how large RSS and VSZ get in “ps” output on Unix… do different VM memory adjustments. You may want to make MySQL to use Large Pages for allocating Innodb Buffer Pool and few other buffers, which may…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… shows that accesses to the fields of buf_pool->stat are unprotected. These are buffer pool statistics counters: number of read, written, evicted…) The RW lock spin stats join the company of the buffer pool and I/O stats. ==9090== Thread #18: lock order “0xF14460 before… consider backporting and using MySQL 5.5 atomic operation primitives with proper memory barriers, so that there is no need for workarounds in mutex…
