… to think that: HASH SQL Find packet in query cache Write packet to wire is faster than PARSE SQL Execute plan…) Go right, read next node (data block) Construct response packet Write packet to wire Even if the whole table is memory… think of it, isn’t that one of the reasons HandlerSockets is so fast? Doesn’t have to deal with parse…
Comment: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… to think that: HASH SQL Find packet in query cache Write packet to wire is faster than PARSE SQL Execute plan…) Go right, read next node (data block) Construct response packet Write packet to wire Even if the whole table is memory… think of it, isn’t that one of the reasons HandlerSockets is so fast? Doesn’t have to deal with parse…
Comment: High Rate insertion with MySQL and Innodb
January 8, 2011 By 17 Comments
… frequent workload. When it comes for focusing on heavy read write I believe this is there a lot of problems are… etc but still scaling reads is a lot easier than writes) and when MySQL scales a lot better for reads these… about making simple selects faster in direct way (not via HandlerSocket and such which reinvents rules of the game) typically there…
Post: How Can Percona MySQL Server Development Services Help ?
January 28, 2013 By 3 Comments
… Server such as the Percona PAM authentication plugin or the HandlerSocket interface. If you have some custom authentication, auditing, or storage…. Percona Toolkit and Other Tools – So far I’ve been writing about MySQL Server only, though this is not the only…
Comment: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… possible that even for 100% write load multi-master cluster would produce some benefit. Certainly HandlerSocket too has proven to us that…
Comment: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
This sounds nice. – How does failover work in Galera? If 1 node fail, would a writing node keep waiting for responses from the failed node? Would future requests be automatically routed around the failed node? – Does Galera work with handlersocket?
Comment: Percona Server now both SQL and NOSQL
December 14, 2010 By 19 Comments
Do writes to HandlerSocket get written to the binary log?
