mysql ssd 性能测试 写入_sysbench mysql-ssd与hdd性能测试

测试环境

操作系统：CentOS7.2.1511 64位

mysql：MySQL5.7.12 64位

硬盘：SSD、HDD

测试工具：sysbench0.5

安装sysbench0.5

更新和安装依赖包git clone https://github.com/akopytov/sysbench

cd  sysbench

./autogen.sh

# with-mysql-includes 指定MySQL安装目录

# with-mysql-libs 指定MySQL lib所在目录./configure --with-mysql-includes=/usr/local/mysql/include/ --with-mysql-libs=/usr/local/mysql/lib/

make && make install

出现如下报错

/bin/sh ../libtool --tag=CC   --mode=link gcc -pthread -g -O2      -o sysbench sysbench.o sb_timer.o sb_options.o sb_logger.o db_driver.o tests/fileio/libsbfileio.a tests/threads/libsbthreads.a tests/memory/libsbmemory.a tests/cpu/libsbcpu.a tests/oltp/libsboltp.a tests/mutex/libsbmutex.a drivers/mysql/libsbmysql.a -L/usr/mysql/lib -lmysqlclient_r not foundcd /usr/local/mysql/lib/mysql/

ln -s libmysqlclient.so.15.0