handlersocket installation

install.sh

apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A
echo "deb http://repo.percona.com/apt trusty main" > /etc/apt/sources.list.d/percona.list
echo "deb-src http://repo.percona.com/apt trusty main" >> /etc/apt/sources.list.d/percona.list
apt-get update

apt-get install -y percona-server-server-5.6

mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"

mysql -e "install plugin handlersocket soname 'handlersocket.so'"

# [mysqld] section
# 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

service mysql restart
mysql -e"show processlist"