We talk about HandlerSocket with special guest Patrick Galbraith of Blue Gecko, have some Ear Candy and talk about OSCon and the Strata Conferences
The HandlerSocket announcement blog post from Yoshinori Matsunobu of DeNA: http://yoshinorimatsunobu.blogspot.com/2010/10/using-mysql-as-nosql-stor...
HandlerSocket in Percona's build: http://www.mysqlperformanceblog.com/2010/12/14/percona-server-now-both-s...
PBXT has had it for years: http://pbxt.blogspot.com/2010/12/handlersocket-why-did-out-version-did.h...
sample MySQL settings using HandlerSocket from Patrick:
First you have to:
mysql> install plugin handlersocket soname 'handlersocket.so';
Then you can add to your my.cnf:
# HandlerSocket settings
loose_handlersocket_port = 9998 # the port number to bind to for read requests
loose_handlersocket_port_wr = 9999 # the port number to bind to for write requests
loose_handlersocket_threads = 16 # the number of worker threads for read requests
loose_handlersocket_threads_wr = 1 # the number of worker threads for write requests
open_files_limit = 65535
# to allow handlersocket to accept many concurrent
# connections, make open_files_limit as large as
IRC channels at irc.freenode.net:
Patrick's handle is capttofu
Henrik Ingo did in fact leave Monty Program: http://openlife.cc/blogs/2010/november/leaving-monty-program-and-mariadb
Blue Gecko blog: http://www.bluegecko.net/community/blog/
Expert PHP and MySQL - http://www.wiley.com/WileyCDA/WileyTitle/productCd-0470563125.html
Developing Web Applications with Apache, MySQL, memcached, and Perl - http://www.amazon.com/Developing-Applications-Apache-MySQL-memcached/dp/...
The five-minute video guide to NoSQL redux by Mark Atwood - http://www.youtube.com/watch?v=zAbFRiyT3LU
Monty Program has put out a trademark policy: http://kb.askmonty.org/v/trademark-policy Very readable translation from the legalese of when one can use a trademark.
ALTER TABLE...DISABLE/ENABLE KEYS is MyISAM only.
mysql> alter table foo disable keys;
Query OK, 0 rows affected, 1 warning (0.00 sec)
| Note | 1031 | Table storage engine for 'foo' doesn't have this option |
O’Reilly’s Strata, a conference about big data, is Feb 1-3 in Santa Clara, CA. https://en.oreilly.com/strata2011/public/register?cmp=il-radar-st11-stra... The speaker list is at http://strataconf.com/strata2011/public/schedule/speakers