3 ms·
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://yoshin
by TY 15y ago
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-as-nosql-story-for.html 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.
- deleted 15y ago[deleted]
- EGreg 15y agoFacebook uses mysql as a key-value store. HandlerSocket is great for avoiding SQL parsing -- is it the same thing basically as ODBC?