… by engine operations ( SQL Parsing, Query analyzer etc.. ), but while using handler socket to have massive concurrent writes thus bypassing all those operations… using 16 core machine to process requests with the traditional mysql socket but slave process the binary log using HandlerSocket it might …
Comment: What's up with HandlerSocket?
March 29, 2011 By 42 Comments
…coarse query cache in It would be strange for me to see someone using Handler Socket actually looking to use query cache at the same time. Query …be good it is fixed some way, whenever it is disabling query cache if Handler Socket is enabled or actually invalidating items is enabled is both OK with…
Comment: What's up with HandlerSocket?
March 29, 2011 By 42 Comments
…coarse query cache in It would be strange for me to see someone using Handler Socket actually looking to use query cache at the same time. Query …be good it is fixed some way, whenever it is disabling query cache if Handler Socket is enabled or actually invalidating items is enabled is both OK with…
Comment: High Rate insertion with MySQL and Innodb
January 7, 2011 By 13 Comments
… I would not expect significant gains from Handler Socket in this case. The main gain from Handler Socket is a lot of small selects as in this case parsing, locking tables etc is majority of execution time, for LOAD DATA INFILE and even multiple value insert …
Post: Diagnosing and Fixing MySQL Replication + Early Bird Registration Extended!
September 19, 2011 By 1 Comment
… logs, and how to recover a replication slave from many types of real-world failures.”
Not interested in Replication? Come see others speak on topics from Handler Socket to Programmatic Queries. With 45 sessions not including the keynotes you are bound to find…
Comment: What's up with HandlerSocket?
March 29, 2011 By 42 Comments
By convenience I mean that my existing application continues to work unmodified which is not the case with handler socket. I also mean that all existing technologies, libs and tutorials work (not the case). The move towards nosql is driven primarily by performance but only few need it.
Comment: What's up with HandlerSocket?
March 29, 2011 By 42 Comments
…support handlersockets, if you’re on PHP you’d want support in PHP_MYSQLND, etc.
Or would handler sockets just work with those drivers (looser abstraction layer)?
Naturally, the problem is that I’m not even sure how you’d map the HandlerSockets API onto …
Comment: What's up with HandlerSocket?
March 29, 2011 By 42 Comments
By convenience I mean that my existing application continues to work unmodified which is not the case with handler socket. I also mean that all existing technologies, libs and tutorials work (not the case). The move towards nosql is driven primarily by performance but only few need it.
Comment: What's up with HandlerSocket?
March 29, 2011 By 42 Comments
… to support handlersockets, if you’re on PHP you’d want support in PHP_MYSQLND, etc.
Or would handler sockets just work with those drivers (looser abstraction layer)?
Naturally, the problem is that I’m not even sure how you’d map the HandlerSockets API onto a …
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
…use of more than 8 cores effectively (which would correspond to single CPU socket these days)
Here are some more details. oprofile:
867964 15.1181 mysqld…_clust_rec_for_mysql,row_search_for_mysql,ha_innobase::general_fetch,handler::read
_multi_range_next,QUICK_RANGE_SELECT::get_next,rr_quick,sub…
