tag:blogger.com,1999:blog-4614960018934857975.post3229757358907909014..comments2023-11-27T09:32:36.643+00:00Comments on Mablomy: Playing with Memcached PluginUnknownnoreply@blogger.comBlogger4125tag:blogger.com,1999:blog-4614960018934857975.post-85597491732834736702012-03-30T02:01:15.793+01:002012-03-30T02:01:15.793+01:00Hi Mario.
>> For InnoDB logs and replicatio...Hi Mario.<br /><br />>> For InnoDB logs and replication logs (binlog) I do not expect any batching<br />I really want this function. so I'm wondering memcached plugin can eliminate previous change of the same key.<br />Anyway, memcached plugin still run every single query(can be batched) to innodb storage engine.<br />Right ?<br /><br />Really thanks.토토https://www.blogger.com/profile/13365204800755945163noreply@blogger.comtag:blogger.com,1999:blog-4614960018934857975.post-69724181287566648812012-03-29T14:42:13.423+01:002012-03-29T14:42:13.423+01:00As always with InnoDB the data will be stored in t...As always with InnoDB the data will be stored in the buffer pool first. If you modify that data before it is committed, it is really batched. You will write only the final version of the data block. For InnoDB logs and replication logs (binlog) I do not expect any batching. The parameter "daemon_memcached_w_batch_size" means that each SET will result in one INSERT or UPDATE on InnoDB, and every n (default=32) statements, the memcached plugin will add a "COMMIT".Mario Beckhttps://www.blogger.com/profile/04044394976329123982noreply@blogger.comtag:blogger.com,1999:blog-4614960018934857975.post-69659230442497015772012-03-29T14:22:40.689+01:002012-03-29T14:22:40.689+01:00Hi Mario, thanks for good post.
I'm really in...Hi Mario, thanks for good post.<br /><br />I'm really interested in Memcached intergrated InnoDB.<br />Above post, you said power of "daemon_memcached_w_batch_size" option.<br />I'm wondering memcached plugin can merge multiple update statement.<br /><br />for example, below query is buffering in memcached plugin.<br />00:00;00 update tb_test set v=1 where id=1;<br />00:00;01 update tb_test set v=2 where id=2;<br />00:00;02 update tb_test set v=3 where id=1;<br />00:00;03 update tb_test set v=4 where id=2;<br />00:00;05 ...<br /><br />memcached plugin can merge these batched update statements like below,<br />00:00;01 update tb_test set v=2 where id=2;<br />00:00;03 update tb_test set v=4 where id=2;<br />00:00;05 ...<br /><br />Really thanks for your answer in advance.토토https://www.blogger.com/profile/13365204800755945163noreply@blogger.comtag:blogger.com,1999:blog-4614960018934857975.post-20716640778395147852012-01-19T14:23:50.059+00:002012-01-19T14:23:50.059+00:00Hi Mario, great post. If someone wants to use the ...Hi Mario, great post. If someone wants to use the Memcached API but with MySQL as the storage engine rather than InnoDB then that's possible too.... http://www.clusterdb.com/mysql-cluster/scalabale-persistent-ha-nosql-memcache-storage-using-mysql-cluster/<br /><br />With the MySQL Cluster version you can also use the key prefix to map keys/values to differnt columns in different tables - that way you can add Memcached API access to your existing schema.Andrew Morganhttps://www.blogger.com/profile/08593968879243742268noreply@blogger.com