乱爱性全过程免费视频/午夜毛片视频/中文字幕av三区/一级视频网址

當(dāng)前位置： 維易PHP培訓(xùn)學(xué)院 > MYSQL教程 > 內(nèi)容正文

MYSQL數(shù)據(jù)庫(kù)sysbench-0.4.12編譯安裝和CPU測(cè)試?yán)臃窒?/h1>

作者：VEPHP   時(shí)間 2017-10-21

《MYSQL數(shù)據(jù)庫(kù)sysbench-0.4.12編譯安裝和CPU測(cè)試?yán)臃窒怼芬c(diǎn)：
本文介紹了MYSQL數(shù)據(jù)庫(kù)sysbench-0.4.12編譯安裝和CPU測(cè)試?yán)臃窒恚Ｍ麑?duì)您有用。如果有疑問(wèn)，可以聯(lián)系我們。

MYSQL入門一、獲取安裝包

MYSQL入門最近的版本為0.4.12,下載地址：http://sourceforge.net/projects/sysbench/

MYSQL入門二、編譯安裝

MYSQL入門我的環(huán)境為RHEL6.2 + MySQL 5.6.16,搭建參考上兩篇文章<<RHEL6.2編譯安裝MySQL 5.6.16>><<MySQL Benchmark安裝DBI組件>>,安裝步驟如下：

代碼如下:

[root@beanvm ~]# tar -xvf sysbench-0.4.12.tar.gz
[root@beanvm ~]# cd sysbench-0.4.12
[root@beanvm sysbench-0.4.12]# ./configure --with-mysql-includes=/usr/local/mysql/include --with-mysql-libs=/usr/local/mysql/lib && make && make install

MYSQL入門因?yàn)槲业腗ySQL是編譯安裝的,所以上面需要給出MySQL的庫(kù)文件位置(對(duì)應(yīng)―with―mysql-includes和Cwith-mysql-libs選項(xiàng)).

MYSQL入門安裝過(guò)程中常見(jiàn)的報(bào)錯(cuò)如下：

代碼如下:

../libtool: line 841: X--tag=CC: command not found
../libtool: line 874: libtool: ignoring unknown tag : command not found
../libtool: line 841: X--mode=link: command not found
../libtool: line 1007: *** Warning: inferring the mode of operation is deprecated.: command not found
../libtool: line 1008: *** Future versions of Libtool will require --mode=MODE be specified.: command not found
../libtool: line 2234: X-g: command not found
../libtool: line 2234: X-O2: command not found
../libtool: line 1954: X-L/usr/local/mysql/lib: No such file or directory
../libtool: line 2403: Xsysbench: command not found

MYSQL入門在之前版本中,碰見(jiàn)這個(gè)問(wèn)題我們只需要在編譯操作前執(zhí)行sysbench解壓目錄下的autogen.sh腳本即可；不過(guò)現(xiàn)在這樣做還是會(huì)報(bào)同樣的錯(cuò)誤,原因是sysbench自帶的libtool有問(wèn)題,我們可以比較它和/usr/bin/libtool文件的區(qū)別得知,總之可以通過(guò)替換這個(gè)libtool文件來(lái)解決,或者修改aclocal.m4文件的如下內(nèi)容

代碼如下:

# Always use our own libtool.
LIBTOOL='$(SHELL) $(top_builddir)/libtool'
AC_SUBST(LIBTOOL)dnl

MYSQL入門將LIBTOOL變量的值修改為：'$(SHELL)? /usr/bin/libtool',即使用系統(tǒng)的libtool工具包.

MYSQL入門修改后再執(zhí)行make && make install即可順利安裝.

MYSQL入門安裝完成馬上測(cè)試一下：

代碼如下:

[root@beanvm sysbench-0.4.12]# sysbench
sysbench: error while loading shared libraries: libmysqlclient.so.18: cannot open shared object file: No such file or directory

MYSQL入門說(shuō)是缺少libmysqlclient.so.18文件,額,這個(gè)文件是存在的,需要手動(dòng)鏈接一下：

代碼如下:

[root@beanvm ~]# ls -l /usr/local/mysql/lib/libmysqlclient.so.18*
lrwxrwxrwx. 1 mysql mysql????? 24 Feb 15 14:39 /usr/local/mysql/lib/libmysqlclient.so.18 -> libmysqlclient.so.18.1.0
-rwxr-xr-x. 1 mysql mysql 7654927 Feb 15 14:30 /usr/local/mysql/lib/libmysqlclient.so.18.1.0
[root@beanvm ~]# ls -l /usr/lib/libmysqlclient.so.18*
ls: cannot access /usr/lib/libmysqlclient.so.18*: No such file or directory
[root@beanvm ~]# ln ln -s /usr/local/mysql/lib/libmysqlclient.so.18 /usr/lib/

MYSQL入門部署完成,運(yùn)行一個(gè)CPU基準(zhǔn)測(cè)試：

代碼如下:

[root@beanvm ~]# sysbench --test=cpu --cpu-max-prime=20000 run
sysbench 0.4.12:? multi-threaded system evaluation benchmark

MYSQL入門Running the test with following options:
Number of threads: 1

MYSQL入門Doing CPU performance benchmark

MYSQL入門Threads started!
Done.

MYSQL入門Maximum prime number checked in CPU test: 20000

MYSQL入門Test execution summary:
??? total time:????????????????????????? 40.4541s
??? total number of events:????????????? 10000
??? total time taken by event execution: 40.4165
??? per-request statistics:
???????? min:????????????????????????????????? 3.64ms
???????? avg:????????????????????????????????? 4.04ms
???????? max:???????????????????????????????? 21.82ms
???????? approx.? 95 percentile:?????????????? 5.20ms

MYSQL入門Threads fairness:
??? events (avg/stddev):?????????? 10000.0000/0.00
??? execution time (avg/stddev):?? 40.4165/0.00

維易PHP培訓(xùn)學(xué)院每天發(fā)布《MYSQL數(shù)據(jù)庫(kù)sysbench-0.4.12編譯安裝和CPU測(cè)試?yán)臃窒怼返葘?shí)戰(zhàn)技能，PHP、MYSQL、LINUX、APP、JS,CSS全面培養(yǎng)人才。

轉(zhuǎn)載請(qǐng)注明本頁(yè)網(wǎng)址：
http://www.fzlkiss.com/jiaocheng/11940.html


    標(biāo)簽：