… spikes and produces a very constant and predictable result. vCache vs. FlashCache – the basics Once I’d determined that configuration C… within acceptable bounds. This is, however, only a hypothesis. vCache vs. FlashCache – dirty page threshold Finally, we examine the impact of… way. The following graph shows sysbench OLTP performance for FlashCache vs. vCache with a 10% dirty threshold versus the same metrics…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… with TokuDB, of course I wanted to compare InnoDB performance vs TokuDB. I have a particular workload I’m interested in…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… able to find any information how memcached cache time expiry being apply into MySQL 5.6 memcached. e.g. if i want… time as 12hours. Can this apply to the MySQL innodb memcache? i.e. will the cache being delete off innodb table… between performance of 5.6 memcached innodb write/read vs 5.6 innodb write/read with no memcached layer? Currently I am considering…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
(This is part one of a two part series) Over the past few weeks I have been looking at a preview release of Virident’s vCache software, which is a kernel module and set of utilities designed to provide functionality similar to that of FlashCache. In particular, Virident engaged Percona to do a …
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… (from Example 1, above), how about maintaining the counter in memcache or redis and only flushing to the database periodically? if…
Comment: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
The point at 685 sec when InnoDB performance drops, is that when data doesn’t fit all in RAM anymore? I would in general expect to see benefits from TokuDB when workload is diskbound. You could artificially reduce InnoDB buffer pool (and corresponding Tokutek setting) to have more SSD vs RAM.
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… a results comparison on a single-node (on the left) vs. two-node (on the right) configuration. No surprises here, the…
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
… graphs were broken due to cacti hexadecimal transformation (bug 1155513) * Memcached graphs were broken when the wrong arguments for nc command…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
It’s not uncommon to promote a server from slave to master. One of the key things to protect your data integrity is to make sure that the promoted slave is permanently disconnected from its old master. If not, it may get writes from the old master, which can cause all kinds of data corruption. …
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… a more scalable Innodb version with more features. Gearman and MemcacheD storage engine plugins are available for MySQL. Facebook mentions they…
