MySQL中sysbench如何使用
MySQL中 sysbench如何使用，很多新手對(duì)此不是很清楚，為了幫助大家解決這個(gè)難題，下面小編將為大家詳細(xì)講解，有這方面需求的人可以來(lái)學(xué)習(xí)下，希望你能有所收獲。
創(chuàng)新互聯(lián)建站是一家專(zhuān)業(yè)提供淥口企業(yè)網(wǎng)站建設(shè),專(zhuān)注與網(wǎng)站制作、成都網(wǎng)站制作、H5高端網(wǎng)站建設(shè)、小程序制作等業(yè)務(wù)。10年已為淥口眾多企業(yè)、政府機(jī)構(gòu)等服務(wù)。創(chuàng)新互聯(lián)專(zhuān)業(yè)網(wǎng)站設(shè)計(jì)公司優(yōu)惠進(jìn)行中。
sysbench
mysql,postgresql,oracle,cpu，內(nèi)存，磁盤(pán)，效率高，可根據(jù)特點(diǎn)編寫(xiě)lua腳本
pgbench
postgresql，專(zhuān)業(yè)測(cè)試pg，簡(jiǎn)單高效
sysbench 安裝
sysbench2.1支持系統(tǒng)版本，linux,windows 10 以上，windows需要開(kāi)啟wsl
https://github.com/akopytov/sysbench
git clone https://github.com/akopytov/sysbench.git
./autogen.sh
# Add --with-pgsql to build with PostgreSQL support
./configure
make -j
make install
sysbench /usr/local/share/sysbench/oltp_write_only.lua \
--mysql-host=skypixel-fish.mysql.database.azure.com \
--mysql-port=3306 \
--mysql-user=dbmgr@skypixel-fish \
--mysql-password=DdBZ7pFGnPQANSCh \
--mysql-db=testdb \
--db-driver=mysql \
--tables=15 \
--table-size=5000000 \
--report-interval=3 \
--threads=256 \
--time=300 \
prepare
run
prepare/run/cleanup
https://blog.csdn.net/ashic/article/details/63388358
https://blog.csdn.net/kai404/article/details/52832848
https://blog.csdn.net/reblue520/article/details/51050682
https://www.cnblogs.com/kismetv/archive/2017/09/30/7615738.html
sysbench
sysbench /usr/local/share/sysbench/oltp_write_only.lua \
--mysql-host=skypixel-fish.mysql.database.azure.com \
--mysql-port=3306 \
--mysql-user=dbmgr@skypixel-fish \
--mysql-password=DdBZ7pFGnPQANSCh \
--mysql-db=testsys \
--db-driver=mysql \
--tables=10 \
--table-size=50 \
--report-interval=3 \
--threads=256 \
--time=600 \
prepare
cleanup
oltp_read_only.lua: -- 有各種Select語(yǔ)句
CREATE TABLE `sbtest1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`k` int(11) NOT NULL DEFAULT '0',
`c` char(120) NOT NULL DEFAULT '',
`pad` char(60) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `k_1` (`k`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;
oltp_read_write.lua -- select,update,delete ,insert
CREATE TABLE `sbtest1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`k` int(11) NOT NULL DEFAULT '0',
`c` char(120) NOT NULL DEFAULT '',
`pad` char(60) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `k_1` (`k`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1
oltp_write_only.lua -->update 和insert語(yǔ)句
CREATE TABLE `sbtest1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`k` int(11) NOT NULL DEFAULT '0',
`c` char(120) NOT NULL DEFAULT '',
`pad` char(60) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `k_1` (`k`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1
set global general_log=ON;
tailf /var/lib/mysql/mysql01.log
oltp_read_only oltp_read_write
sysbench /usr/local/share/sysbench/oltp_read_only.lua \
--mysql-host=127.0.0.1 \
--mysql-port=3306 \
--mysql-user=root \
--mysql-password=Ysysljj443322! \
--mysql-db=sysbench \
--db-driver=mysql \
--tables=10 \
--table-size=5000 \
--report-interval=3 \
--threads=2 \
--time=60 \
run
threads 越大，tps,qps越大
prepare
cleanup
http://echarts.baidu.com/echarts2/doc/example/line1.html#macarons
TPS:
grep "^\[" 1.log |awk -F'(' '{print $1}'|sed -e "s/\[\ /\{'time':'/g" -e "s/\ \]//g" -e "s/:\ /':'/g" -e "s/\ /','/g" -e "s/,'$/\}/g" > 2.log
awk -F : '{print $4}' 2.log| awk -F , '{print $1","}'| awk '{for(i=1;i<=NF;i++)a[NR,i]=$i}END{for(j=1;j<=NF;j++)for(k=1;k<=NR;k++)printf k==NR?a[k,j] RS:a[k,j] FS}'
awk -F : '{print $5","}' 2.txt|wc -l
awk -F : '{print $5","}' 2.log|awk '{for(i=1;i<=NF;i++)a[NR,i]=$i}END{for(j=1;j<=NF;j++)for(k=1;k<=NR;k++)printf k==NR?a[k,j] RS:a[k,j] FS}'
QPS:
behind:
awk -F : '{print $NF ","}' behind.log |awk '{for(i=1;i<=NF;i++)a[NR,i]=$i}END{for(j=1;j<=NF;j++)for(k=1;k<=NR;k++)printf k==NR?a[k,j] RS:a[k,j] FS}'
TPS、QPS數(shù)據(jù)繪圖
option = {
title : {
text: 'MySQL壓力測(cè)試',
subtext: 'only write 55 threads '
},
tooltip : {
trigger: 'axis'
},
legend: {
data:['TPS','QPS']
},
toolbox: {
show : true,
feature : {
mark : {show: true},
dataView : {show: true, readOnly: false},
magicType : {show: true, type: ['line', 'bar']},
restore : {show: true},
saveAsImage : {show: true}
}
},
calculable : true,
xAxis : [
{
type : 'category',
boundaryGap : false,
data : ['0s','3s','6s','9s','12s','15s','18s','21s','24s','27s','30s','33s','36s','39s','42s','45s','48s','51s','54s','57s','60s','63s','66s','69s','72s','75s','78s','81s','84s','87s','90s','93s','96s','99s','102s','105s','108s','111s','114s','117s','120s','123s','126s','129s','132s','135s','138s','141s','144s','147s','150s','153s','156s','159s','162s','165s','168s','171s','174s','177s','180s','183s','186s','189s','192s','195s','198s','201s','204s','207s','210s','213s','216s','219s','222s','225s','228s','231s','234s','237s','240s','243s','246s','249s','252s','255s','258s','261s','264s','267s','270s','273s','276s','279s','282s','285s','288s','291s','294s','297s','300s']
}
],
yAxis : [
{
type : 'value',
axisLabel : {
formatter: '{value} '
}
}
],
series : [
{
name:'TPS',
type:'line',
data:[35.63,38.69,52.31,40.33,51.33,40.67,50.67,41.67,48.67,43.35,48.97,43.02,48.98,41.66,48.34,43.66,39.67,49.67,51.33,43.00,41.02,47.64,42.67,48.68,42.66,49.69,41.66,49.33,42.68,49.32,42.33,49.01,42.65,47.66,44.34,48.66,43.35,46.33,45.99,45.04,46.33,45.33,47.65,45.33,43.99,46.67,45.33,45.01,48.69,37.31,36.34,37.66,54.01,37.66,53.66,39.01,51.33,40.32,52.01,39.66,51.67,40.03,51.29,40.01,51.32,41.01,39.00,52.34,39.68,51.33,40.65,51.01,41.00,49.99,42.68,49.32,42.34,48.01,42.99,49.68,42.33,49.68,42.65,47.34,45.01,46.65,45.67,46.35,45.01,47.65,44.99,46.01,44.66,46.36,44.65,47.67,41.00,44.99,46.66,45.67],
markPoint : {
data : [
{type : 'max', name: '最大值'},
{type : 'min', name: '最小值'}
]
},
markLine : {
data : [
{type : 'average', name: '平均值'}
]
}
},
{
name:'QPS',
type:'line',
data:[270.03,254.81,274.86,277.00,273.67,275.00,275.67,272.67,268.01,274.12,273.86,273.49,269.22,269.61,273.36,277.64,267.05,281.01,276.31,274.98,267.44,272.83,271.35,273.39,274.93,276.80,270.95,269.66,279.08,276.94,272.66,274.74,273.22,273.62,277.70,276.32,272.41,274.96,270.28,270.23,278.31,274.95,272.59,276.66,268.63,278.33,274.31,273.05,276.49,259.48,185.02,271.97,274.39,273.97,276.66,274.71,265.33,272.27,274.37,274.65,272.67,266.51,272.44,274.41,276.27,275.38,263.67,285.02,262.09,283.67,267.56,271.71,274.99,273.59,275.76,269.25,281.03,277.70,275.96,273.73,266.31,277.08,275.55,274.69,273.03,268.55,284.38,269.08,272.72,277.93,270.60,275.75,273.60,275.47,271.91,278.69,271.00,270.63,274.31,275.68],
markPoint : {
data : [
{type : 'max', name: '最大值'},
{type : 'min', name: '最小值'}
]
},
markLine : {
data : [
{type : 'average', name: '平均值'}
]
}
}
]
};中從延時(shí)數(shù)據(jù)繪圖
option = {
title : {
text: 'MySQL壓力測(cè)試',
subtext: 'read and write 170 threads '
},
tooltip : {
trigger: 'axis'
},
legend: {
data:['Seconds_Behind_Master']
},
toolbox: {
show : true,
feature : {
mark : {show: true},
dataView : {show: true, readOnly: false},
magicType : {show: true, type: ['line', 'bar']},
restore : {show: true},
saveAsImage : {show: true}
}
},
calculable : true,
xAxis : [
{
type : 'category',
boundaryGap : false,
data : ['0s','3s','6s','9s','12s','15s','18s','21s','24s','27s','30s','33s','36s','39s','42s','45s','48s','51s','54s','57s','60s','63s','66s','69s','72s','75s','78s','81s','84s','87s','90s','93s','96s','99s','102s','105s','108s','111s','114s','117s','120s','123s','126s','129s','132s','135s','138s','141s','144s','147s','150s','153s','156s','159s','162s','165s','168s','171s','174s','177s','180s','183s','186s','189s','192s','195s','198s','201s','204s','207s','210s','213s','216s','219s','222s','225s','228s','231s','234s','237s','240s','243s','246s','249s','252s','255s','258s','261s','264s','267s','270s','273s','276s','279s','282s','285s','288s','291s','294s','297s','300s']
}
],
yAxis : [
{
type : 'value',
axisLabel : {
formatter: '{value} s'
}
}
],
series : [
{
name:'Seconds_Behind_Master',
type:'line',
data:[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],
markPoint : {
data : [
{type : 'max', name: '最大值'},
{type : 'min', name: '最小值'}
]
},
markLine : {
data : [
{type : 'average', name: '平均值'}
]
}
}
]
};看完上述內(nèi)容是否對(duì)您有幫助呢？如果還想對(duì)相關(guān)知識(shí)有進(jìn)一步的了解或閱讀更多相關(guān)文章，請(qǐng)關(guān)注創(chuàng)新互聯(lián)行業(yè)資訊頻道，感謝您對(duì)創(chuàng)新互聯(lián)的支持。
分享名稱(chēng)：MySQL中sysbench如何使用
鏈接URL：http://jinyejixie.com/article22/pgegjc.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供軟件開(kāi)發(fā)、App設(shè)計(jì)、網(wǎng)站改版、定制開(kāi)發(fā)、面包屑導(dǎo)航、外貿(mào)網(wǎng)站建設(shè)
聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶(hù)投稿、用戶(hù)轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)
- 網(wǎng)站排名優(yōu)化，關(guān)鍵詞優(yōu)化受什么影響？ 2021-10-11
- 網(wǎng)站關(guān)鍵詞優(yōu)化上不去的原因 2016-03-17
- 網(wǎng)站關(guān)鍵詞優(yōu)化的方法 2022-06-16
- 網(wǎng)站維護(hù)對(duì)網(wǎng)站關(guān)鍵詞優(yōu)化以為著什么 2016-11-12
- 山西太原做網(wǎng)站關(guān)鍵詞優(yōu)化應(yīng)該如何找？ 2020-12-06
- 關(guān)鍵詞優(yōu)化的正確規(guī)劃指點(diǎn) 2017-02-28
- 成都seo關(guān)鍵詞優(yōu)化之術(shù)語(yǔ)大全 2022-07-17
- 關(guān)鍵詞優(yōu)化總是優(yōu)化不上去怎么辦 2014-06-12
- seo人員如何區(qū)分關(guān)鍵詞優(yōu)化和整站優(yōu)化？ 2015-01-23
- 河南SEO優(yōu)化_網(wǎng)站建設(shè)關(guān)鍵詞優(yōu)化排名 2020-11-18
- 網(wǎng)站關(guān)鍵詞優(yōu)化多久才有效果 2016-04-25
- SEO優(yōu)化該怎么做?關(guān)鍵詞優(yōu)化有好處嗎? 2014-05-08