You Got NoSQL in MySQL: Memcached Plugin in MySQL Technology Preview

Re:You Got NoSQL in MySQL: Memcached Plugin in MySQL Technol... by TY on Saturday April 16, 2011 @08:59PM (#2455296)

Unfortunately, it's not that easy. Don't forget about the impact of SQL parsing and connection costs.

Here is a very illuminating post about it:

http://yoshinorimatsunobu.blogspot.com/2010/10/using-mysql-a...

The authors created a MySQL plugin that served as a network server and hooked into InnoDB without SQL parsing overhead. It also avoided the cost of opening/closing tables by keeping them open.

According to their benchmark, performance went from 100,000 queries per second to 750,000 per second on the same server.

Well worth the read.

[ Parent | on HN ]

Re:You Got NoSQL in MySQL: Memcached Plugin in MySQL Technol... by EGreg on Sunday April 17, 2011 @02:58AM (#2455719)

Facebook uses mysql as a key-value store. HandlerSocket is great for avoiding SQL parsing -- is it the same thing basically as ODBC?

[ Parent | on HN ]