ubuntu11.10安装mysql+handlersocket_MySQL
程序员文章站
2022-06-16 10:57:53
...
Ubuntu
bitsCN.com
1.安装mysql：（不管要啥，一股脑都装上）
sudo apt-get install mysql-serversudo apt-get install mysql-clientsudo apt-get install libmysqlclient-devsudo apt-get install libmysqld-dev
2.下载mysql和handlersocket源代码：
mysql-5.1.62.tar.gz 可以自己百度
ahiguti-HandlerSocket-Plugin-for-MySQL-1.1.0-2-g395fa55.tar.gz 这个都不好下，在实验室才下到。。
3.解压
sudo tar -zxvf mysql-5.1.62.tar.gz -C /usr/local/src/sudo tar -zxvf handlersocket_1.0.6-80-g88bf1e0.orig.tar.gz -C /usr/local/src/
4.编译安装handler socket
cd /usr/local/src/ahiguti-HandlerSocket-Plugin-for-MySQL-395fa55/sudo ./autogen.sh
小插曲：
这里出现：
错误1
Searching libtoolize...-e WARNING: Cannot Found libtoolize... input libtool command^C
解决：
sudo apt-get install libtool
错误2
Searching libtoolize...-e FOUND: libtoolize -> libtoolizeSearching aclocal...-e WARNING: Cannot Found aclocal... input aclocal command^C
解决：
sudo apt-get install autotools-devsudo apt-get install automake
插曲结束~
sudo ./configure --with-mysql-source=../mysql-5.1.62 --with-mysql-bindir=/usr/bin --with-mysql-plugindir=/usr/lib/mysql/plugin
with-mysql-source 表示MySQL源代码目录，with-mysql-bindir 表示MySQL二进制可执行文件目录（也就是 mysql_config 所在目录，可以用whereis mysql_config找到），with-mysql-plugindir 表示MySQL插件目录
如果不清楚这个目录在哪，可以按如下方法查询：
mysql> SHOW VARIABLES LIKE 'plugin%';
+---------------+-----------------------+
| Variable_name | Value |
+---------------+-----------------------+
| plugin_dir | /usr/lib/mysql/plugin |
+---------------+-----------------------+
sudo make & make install
5.修改mysql配置文件my.cnf，添加相关端口配置：
# sudo vi /etc/my.cnf [mysqld] 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 accept many concurren connections, make open_files_limit as large as possible.
6.登陆mysql
bobo@master:/usr/local/src$ mysql -u root -pEnter password: Welcome to the MySQL monitor. Commands end with ; or /g.Your MySQL connection id is 45Server version: 5.1.62-0ubuntu0.11.10.1 (Ubuntu)Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '/h' for help. Type '/c' to clear the current input statement.mysql> install plugin handlersocket soname 'handlersocket.so';Query OK, 0 rows affected (0.30 sec)
插曲二：
中间又出现错误了。。
mysql> install plugin handlersocket soname 'handlersocket.so';ERROR 1126 (HY000): Can't open shared library '/usr/lib/mysql/plugin/handlersocket.so' (errno: 2 cannot open shared object file: No such file or directory)
莫名其妙的，结果我又单独make一下，再make install一下，就好了。。
我也不知道跟这个又没有关系。。。
插曲二终
通过show processlist 能在MySQL里看到HandlerSocket的线程了：
mysql> show processlist -> ;+----+-------------+-----------------+---------------+---------+------+-------------------------------------------+------------------+| Id | User | Host | db | Command | Time | State | Info |+----+-------------+-----------------+---------------+---------+------+-------------------------------------------+------------------+| 45 | root | localhost | NULL | Query | 0 | NULL | show processlist || 46 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL || 47 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL || 48 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL || 49 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL || 50 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL || 51 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL || 52 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL || 53 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL || 54 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL || 55 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL || 56 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL || 57 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL || 58 | system user | connecting host | handlersocket | Connect | NULL | handlersocket: mode=wr, 0 conns, 0 active | NULL || 59 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL || 60 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL || 61 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL || 62 | system user | connecting host | NULL | Connect | NULL | handlersocket: mode=rd, 0 conns, 0 active | NULL |+----+-------------+-----------------+---------------+---------+------+-------------------------------------------+------------------+18 rows in set (0.00 sec)
也可以查看端口占用来验证你的mysql装好了：
bobo@master:~$ sudo lsof -i :9998COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAMEmysqld 14173 mysql 30u IPv4 49030 0t0 TCP *:9998 (LISTEN)bobo@master:~$ sudo lsof -i :9999COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAMEmysqld 14173 mysql 77u IPv4 49032 0t0 TCP *:9999 (LISTEN)
7.简单测试
参考http://lsddesign.blog.163.com/blog/static/170908080201231895758377/
看了许多教程，有许多问题，觉得这个的参考价值大一些：
http://leishguolearn.googlecode.com/svn-history/r296/trunk/learn_doc/final_shguo/handlersocket
bitsCN.com