</pre><span><strong>1.简介</strong></span><p></p><p><span><span><span> sysbench</span></span><span>是一款开源的多</span><span><span>线程性状测试</span></span><span>工具，可以履行</span><span><span>CPU</span></span><span>/</span><span><span>内存</span></span><span>/</span><span><span>线程</span></span><span>/</span><span><span>IO</span></span><span>/</span><span><span>数据库</span></span><span>等方面的性状测试。</span><span><span>数据库</span></span><span>目前支撑</span><span><span>MySQL</span></span><span>/</span><span><span>Oracle</span></span><span>/PostgreSQL。本篇文章只是简略演示一下几种测试的用法，后续预备应用</span><span><span>sysbench</span></span><span>来对MySQL进行一系列的测试。具体的一些参数设置，须要依据不同的测试要求来进行调剂。</span></span></p><p><span><span></span></span></p><p><span><strong><span>2.安装</span></strong></span></p><p><span><strong><span># yum打包、增长环境变量</span></strong></span></p><p><span><span>yum -y install bzr libtool wget https://imysql.com/wp-content/uploads/2014/09/sysbench-0.4.12-1.1.tgzcat "export LD_LIBRARY_PATH=/db/mysql/lib" >> /etc/profilesource /etc/profile</span></span></p><p><span><span></span></span></p><p><span><strong><span># 创立目录</span></strong></span></p><p><span><span>mkdir -p /Data/apps/sysbenchmkdir -p /Data/apps/sysbench/logtar -zxvf sysbench-0.4.12-1.1.tgzcd sysbench-0.4.12-1.1./autogen.sh./configure --prefix=/Data/apps/sysbench --with-mysql-includes=/Data/apps/mysql/include --with-mysql-libs=/Data/apps/mysql/libmake && make installcp /Data/apps/sysbench/bin/sysbench /usr/local/bin/</span></span></p><p><span><span><strong><span># 此时 /Data/package/sysbench-0.4.12-1.1为安装包目录</span></strong>cp -a /Data/package/sysbench-0.4.12-1.1/sysbench/tests /Data/apps/sysbench/</span></span></p><p></p><p><span><strong><span>3.测试</span></strong></span></p><p><span><strong><span><span> </span><span> 3.1 <span>Mysql 数据库</span></span></span></strong></span></p><p><span></span><pre><span>mysql > create database sbtest;
sysbench --mysql-host=127.0.0.1 --mysql-port=3306 --mysql-user=root --mysql-password="" --test=/Data/apps/sysbench/tests/db/oltp.lua --oltp_tables_count=10 --oltp-table-size=100000 --rand-init=on prepare</span></pre><span><strong>1.简介</strong></span><p></p>
