… percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_…warmed up with chunk 3. The result is similar for every single graph, each chunk warmed up…cached if we warmed the cache with the exact same data. All the graphs from such self-warming…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
…the fact removing slave read traffic from non warmed up slave will often cause warmup to be longer… reason as MySQL Restart – the traffic on different boxes might be different and hence cache content. … and slave never is able to catch up. MySQL or OS version changesMySQL version changes (even minor…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
…join_cache_incremental=on’ optimizer_switch=’join_cache_hashed=on’ optimizer_switch=’join_cache_bka=on’ join_cache_level=…pool was not warmed up, so that it does not have the relevant pages loaded up already. Now …at the status counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=…
Post: Getting real life query speeds with MySQL
January 10, 2007 By 10 Comments
… by MySQL restart. Even if you restart MySQL server there is significant chance data will still remain in Operation System cache speeding up query… started and is warming up ? Sometimes it makes sense. In this case you would want to clean MySQL and OS caches, most simple way… you however are interested on server performance when it is warmed up. This is the stage your server should spend more than…
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 were no code which would allow to do it on application side so we did it on MySQL side…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
…you can fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, this is …else. The problem is that the passive server’s caches start to get skewed to handle the write …”small” these days), it starts to matter a lot. Warming up a system so it’s actually responsive can …
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… case of MySQL 5.5 and ~5 hours in case of MySQL 5.6 and MariaDB 5.5. Note that query cache is… 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: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… unsync with internal Innodb dictionary may cause MySQL to fail with wierd error messages. In MySQL 4.1 sync_frm option was… – If you restart MySQL server its caches (key_buffer, innodb_buffer_pool, query_cache,table_cache) are cleaned, so may be OS caches. This may… error to others) and gradually increase the load as server warms up. This may sound strange but makes a lot of sense…
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…
