CETNOS6.5下MYSQL+sysbenchmark0.5安装

安装MYSQL5.5

检查是否已经安装mysql

rpm -qa|grep mysql

如果安装则卸载

rpm -e mysql-libs –nodeps

增加repo：

rpm -Uvh http://mirror.steadfast.net/epel/6/i386/epel-release-6-8.noarch.rpm

rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm

安装

yum --enablerepo=remi,remi-test install mysqlmysql-server

远程登录赋权

GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%'IDENTIFIED BY 'mypassword' WITH GRANT OPTION; 

 

安装sysbench

为了进行oltp,首先安装

yum install mysql-devel

 

yum install m4  autoconf automake libtool

./autogen.sh

./configure --prefix=/usr/local/sysbench--with-mysql-includes=/usr/local/mysql/include --with-mysql-libs=/usr/local/mysql/lib

 

Mysqlinclude和mysqllib通过whereismysql均可查看