大家好，又见面了，我是你们的朋友全栈君。如果您正在找激活码,请点击查看最新教程,关注关注公众号 “全栈程序员社区” 获取激活教程,可能之前旧版本教程已经失效.最新Idea2022.1教程亲测有效,一键激活。
Jetbrains全系列IDE使用 1年只要46元 售后保障 童叟无欺
OS:Centos
1.安装编译时所需文件
yum install bison gcc gcc-c++ autoconf automake zlib* libxml* ncurses-devel libtool-ltdl-devel*
2.安装Cmake
wget http://www.cmake.org/files/v2.8/cmake-2.8.6.tar.gz
tar zxvf cmake-2.8.6.tar.gz
cd cmake-2.8.6/
./configure
gmake
gmake install
3.下载Mysql源码安装Mysql
wget http://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.17.tar.gz/from/http://mysql.ntu.edu.tw/
tar -xzvf mysql-5.5.17.tar.gz
cp mysql-5.5.17.tar.gz /usr/local
tar -xzvf mysql-5.5.17.tar.gz
mv mysql-5.5.17 mysql
cd mysql
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data
-DSYSCONFDIR=/etc/
make
make install
初始化数据库
scripts/mysql_install_db –user=mysql
ps:如果此处遇到权限不够的错误，请将mysql_install_db 的权限+x
chmod +x mysql_install_db
启数据库
bin/mysqld_safe –user=mysql &
cp ./support-files/my-huge.cnf /etc/my.cnf
cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld
chmod +x /etc/init.d/mysqld
chkconfig –add mysqld
进入数据库
bin/mysql
4.安装handlersocket
从 https://github.com/DeNADev/HandlerSocket-Plugin-for-MySQL/downloads获得安装包 上传到服务器
tar -xzvf ahiguti-HandlerSocket-Plugin-for-MySQL-1[1].1.0-2-g395fa55.tar.gz
cd ahiguti-HandlerSocket-Plugin-for-MySQL-395fa55
./autogen.sh
./configure –with-mysql-source=/usr/local/mysql –with-mysql-bindir=/usr/local/mysql/bin
make
make install
在my.cnf中添加相关参数
plugin-load=handlersocket.so
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
重启mysql服务
service mysqld restart
重启mysql服务后install plugin
mysql> INSTALL PLUGIN handlersocket soname ‘handlersocket.so’;
发布者：全栈程序员-站长，转载请注明出处：https://javaforall.net/172635.html原文链接：https://javaforall.net
