June 18, 2013

Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer

…, I would point out something else. For many applications the memcache is used as a cache because of SQL overhead to… simple lookup queries. This means in number of cases using memcached access may simply allow you to get the data from… suffering badly from large number of concurrent request is another memcache advantage.

Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer

… does it compare to InnoDB Memcache storing? 2) The gain in performance from SQL SELECT to InnoDB Memcache fetching seems very small… performance? Why? In comparison Handlersocket does similar things as the memcache plugin and managed to become several times faster than the… also benchmark Handlersocket and see how it compares to Innodb memcache plugin?

Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer

With mysqlnd it can even be used without directly using the memcached API, it can be configured to translate simple SELECT queries to memcached. http://www.php.net/manual/en/intro.mysqlnd-memcache.php

Comment: MySQL caching methods and tips

… connection to database. I have read your article about using Memcached and thinking it maybe good idea to use it for…

Comment: MySQL 5.6 Compatible Percona Toolkit 2.2 Released

Aurimas, Thanks! No plans for pt-memcached-digest or others, but if needed, you can still used …

Comment: MySQL 5.6 Compatible Percona Toolkit 2.2 Released

Daniel, – any plans for pt-memcached-digest or pt-httpd-digest? :) I realize I’m the …

Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released

… objective: analyzing MySQL query logs. So the ability to parse memcached, Postgres, Apache, and other logs was removed. We also removed…

Comment: SimCity outages, traffic control and Thread Pool for MySQL

… almost to zero. We will run benchmarks with Thread Pool vs no-Thread Pool so we will see exact curve there…

Post: Testing the Virident FlashMAX II

… II: we see a read throughput of approximately 2580MiB/sec vs. 1450MiB/sec with the previous generation of hardware, an improvement…

Post: Read/Write Splitting with PHP Webinar Questions Followup

…/disadvantages of filtering-out tables from replication in master side vs slave side? A: You can configure filtering either on the… different modes on successive queries. Q: Is RBR faster replicating vs SBR replication?  RBR is faster than statement based, correct? A… storing $_SESSION in an in-memory data store such as Memcached or APC.  Store in $_SESSION only values that are ephemeral and…