… chunk 4’s workload warmed up with chunk 3. The result is similar for every single graph, each chunk warmed up the buffer pool… everything to be cached if we warmed the cache with the exact same data. All the graphs from such self-warming experiments look like this one. The green part of the graph lines up with the blue part…
Post: More on dangers of the caches
September 23, 2010 By 5 Comments
… cache with new items is lower than speed with which items expire due to timeout you may never get a system warmed up… system up was surprisingly simple. We just had to get traffic on the system in stages allowing Memcache to be warmed up. There… some cases you can also do ramp up feature by feature. Consider Pre-Priming Caches In some cases when cold performance gives…
Post: Here's a quick way to Foresee if Replication Slave is ever going to catch up and When!
August 29, 2012 By 11 Comments
…: sometimes replication would break and then it needs to catch up after it is fixed, other times new replication slave is… could be that replication slave became too slow to catch up due to missing index Whatever the case is, single question… few reasons catching up is so unstable: If you have restarted the server, or started a new one, caches are cold and…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…. One particular point of investigation which needs to be followed up on, including testing innodb_old_blocks_time=1000 on MySQL… size BP, this means the FS cache is warm. For the 4G BP, the BP is completely warm. The idea here is to… smaller than the data but underlying IO is fast (a warm FS cache reduces IO cost significantly) And finally, testing with a…
Post: Getting real life query speeds with MySQL
January 10, 2007 By 10 Comments
… is significant chance data will still remain in Operation System cache speeding up query run. So what can you do ? First decide… started and is warming up ? Sometimes it makes sense. In this case you would want to clean MySQL and OS caches, most simple… you however are interested on server performance when it is warmed up. This is the stage your server should spend more than…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
…’ optimizer_switch=’join_cache_incremental=on’ optimizer_switch=’join_cache_hashed=on’ optimizer_switch=’join_cache_bka=on’ join_cache_level=8 join_buffer… size is set to 6G and the buffer pool was warmed up, so that the relevant pages were already loaded in the… the buffer pool was not warmed up, so that it does not have the relevant pages loaded up already. Now let’s take…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
I have been working with 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 same way this blog post is aimed at a new optimizer enhancement Index Condition …
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… nothing else. The problem is that the passive server’s caches start to get skewed to handle the write workload from… arguably “small” these days), it starts to matter a lot. Warming up a system so it’s actually responsive can take hours… on the passive master, too. Is that all? “Buffer pool warmed up, performance is better, case closed!” No. This isn’t as…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… MySQL 5.6 and MariaDB 5.5. Note that query cache is disabled during these benchmark runs and that the disks… size is set to 6G and the buffer pool was warmed up, so that the relevant pages were already loaded in the… the buffer pool was not warmed up, so that it does not have the relevant pages loaded up already: MRR does make a…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… without a lengthy “warm up” time. If provisioning a slave, this means your new slave will end up with a warmed up buffer pool to…. The new xbstream format works with parallel compression to (without caching) stream several compressed files at once. tar4ibd functionality is replaced…
