… Percona Monitoring Plugins 1.0.3 for MySQL — high-quality components to add enterprise-grade MySQL monitoring and graphing capabilities to your… you rebuilt the poller cache under Cacti -> System Utilities. Also the following Cacti graphs need to be recreated: MySQL “MySQL Threads”, Linux “Network…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… with by fsyncing to memory (Battery or capacitor-backed write cache), etc., but the principle is basically the same. If we… no effect on standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication? It’s actually… to the tradeoffs we take when deploying conventional stand-alone MySQL Innodb with asynchronous slaves. We may not think about the…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…, and I also included a “no cache” test run as well using the base HDD MySQL configuration for purposes of comparison. Given the apparent differences in time-based flushing in vCache and FlashCache, both cache devices…-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… to conduct some benchmarks for the use case where the MySQL working set is significantly larger than the InnoDB buffer pool… many of the same parameters, but doing so requires a cache flush, detach, and reattach. Winner: FlashCache. Operational Flexibility: Both solutions… “1″ to the do_sync sysctl of the cache device triggers a cache flush, but it happens in the background, and while…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…=insert_roll.lua –oltp-table-size=10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on…_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4… = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related options are…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… how memcached cache time expiry being apply into MySQL 5.6 memcached. e.g. if i want to store a cache object for… I can set cache life time as 12hours. Can this apply to the MySQL innodb memcache? i.e. will the cache being delete off innodb table after 12hours or they remain permanent? for doing cache…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 30, 2013 By 10 Comments
…://dev.mysql.com/doc/refman/5.6/en/innodb-memcached-internals.html there are some caching settings to play with: “Table cache_policies… to use the traditional memcached engine as the backstore (cache-only), or both (caching). In the last case, if memcached cannot find…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… table is too big to be cached, but * One partition is small enough to be cached, and * Your accesses are to that… (within a single connection) anywhere in any ‘free’ variant of MySQL. PARTITIONs are scanned one at a time. (Please provide specific… PARTITIONing. I go into more details (and code) here: http://mysql.rjweb.org/doc.php/partitionmaint The third use case for…
Comment: Is MySQL 5.6 slower than MySQL 5.5?
March 27, 2013 By 23 Comments
…,it seams to be something whrong … with your build of mysql-5.6! On 64bit Win7 host running 512 MB VirtulBox… monitor ssse3 lahf_lm bogomips : 5756.60 clflush size : 64 cache_alignment : 64 address sizes : 36 bits physical, 48 bits virtual… (538.76 per sec.) # using skip-performance-schema with standard mysql-5.6.10-debian6.0-x86_64.deb package ! You…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… the size of the partitions, the whole partition can be cached, as opposed to a single table, where probably only recently read records will be cached, resulting in more disc reads. 2. If you need to…, these could easily be quicker on a partitioned table, as Mysql can fire off one thread per partition (at least I…
