…. All OS caches are dropped at this time as well. These set of queries were tested on …=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_… to prevent assorted security risks symbolic-links=0 innodb_stats_persistent innodb_stats_auto_update=off…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
…mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query-log-stdin –dispatcher-plugin thread-pool –thread-pool-threads-count 100 –session-init-query \”set…
Post: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
… solution for keeping the caches of a MySQL standby server hot using MySQL slow logs with long_query_time set to 0. Here are a some lessons we learned when logging a high volume of queries… mysql mysql size 1G dateext missingok notifempty sharedscripts postrotate /usr/local/bin/mysql -e ‘select @@global.long_query_time into @lqt_save; set global long_query…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… MySQL 5.6 is to use a caching layer to store expensive result sets or objects. Some typical use cases include: Complicated query result set… / 100000; $timer->start(); for ($i = 0; $i < 10; $i++) { for ($i = 0; $i < 100000; $i++) { $obj = $cache->load(“key_$i”); } } $totalTimeFetch = $timer->stop…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… designed to look solely at vCache performance under some different sets of MySQL configuration parameters. For example, given that the front-end…_cache_size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…cache_size = 16M max_heap_table_size = 64M sort_buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0… = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-…from documentation TokuDB comes with good settings out-of-box, but I …
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
…set of applications. Many applications in MySQL have very large number of queries…MySQL Query Cache is most useful for complex expensive queries, for which tracking exact rows used from query syntax may be hard. Query Cache Storage Engines MySQL Query Cache…
Post: Write contentions on the query cache
September 5, 2012 By 5 Comments
…query cache as it was enabled. Contention on the query cache mutex when checking if the result set…MySQL need so many accesses to the query cache lock? The answer is in the way the query cache…
Post: MySQL Query Cache WhiteSpace and comments
March 20, 2008 By 9 Comments
…MySQL Query Cache Gerry pokes me as I’m all wrong and both comments and whitespace are fixed in MySQL 5.0…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…query cache lock | 0.000003 | | end | 0.000006 | | query end | 0.000003 | | closing tables | 0.000008 | | freeing items | 0.000016 | | cleaning up | 0.000004 | +——————————+———–+ 18 rows in set (0…
