安装handlersocket插件

注意：mysql的版本不能是debug版本的，否则在安装插件的时候可能会报初始化失败，导致虽然handlersocket安装了，但状态为disabled，无法重启服务器等一系列后遗症……

另外，如果mysql重新编译了，记得也要把handlersocket重新编译下，否则，会出现一堆诡异的错误……

下载：

wget -c http://github.com/ahiguti/HandlerSocket-Plugin-for-MySQL/tarball/master --no-check-certificate

解压

./autogen.sh

$./configure --prefix=/u01/handlesocket --with-mysql-source=/home/yinfeng.zwx/mysql-5.1.48 --with-mysql-bindir=/u01/mysql5.1.48/bin --with-mysql-plugindir=/u01/mysql5.1.48/lib/mysql/plugin/

make

make install

修改my.cnf,增加：

loose_handlersocket_port = 9998
loose_handlersocket_port_wr = 9999
loose_handlersocket_threads = 16
loose_handlersocket_threads_wr = 1

启动mysqld，安装：install plugin handlersocket soname 'handlersocket.so';

报了个很诡异的错误：Duplicate entry 'handlersocket' for key 'PRIMARY'
show plugins也没有显示handlersocket，不管他了，重启服务器，查看alter.log，初始化成功！！

show processlist:

root@(none) 11:05:24>show processlist;
+----+-------------+-----------------+---------------+---------+------+-----------------------------------------------------------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+-------------+-----------------+---------------+---------+------+-----------------------------------------------------------------------+------------------+
| 1 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL |
| 2 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL |
| 3 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL |
| 4 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL |
| 5 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL |
| 6 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL |
| 7 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL |
| 8 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL |
| 9 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL |
| 10 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL |
| 11 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL |
| 12 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL |
| 13 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL |
| 14 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL |
| 15 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL |
| 16 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL |
| 17 | system user | connecting host | handlersocket | Connect | NULL | handlersocket: mode=wr, 0 conns, 0 active | NULL |
| 18 | system user | | NULL | Connect | 534 | Waiting for master to send event | NULL |
| 19 | system user | | NULL | Connect | 534 | Has read all relay log; waiting for the slave I/O thread to update it | NULL |
| 20 | root | localhost | NULL | Query | 0 | NULL | show processlist |
+----+-------------+-----------------+---------------+---------+------+-----------------------------------------------------------------------+------------------+
20 rows in set (0.00 sec)

安装成功！