{"id":20199,"date":"2021-12-11T11:36:11","date_gmt":"2021-12-11T03:36:11","guid":{"rendered":"https:\/\/aqzt.com\/20199.html"},"modified":"2021-12-11T11:36:11","modified_gmt":"2021-12-11T03:36:11","slug":"sysbench%e6%80%a7%e8%83%bd%e5%8e%8b%e6%b5%8b%e4%bb%a5%e5%8f%8amysql%e6%80%a7%e8%83%bd%e5%8e%8b%e6%b5%8b","status":"publish","type":"post","link":"https:\/\/aqzt.com\/20199.html","title":{"rendered":"sysbench\u6027\u80fd\u538b\u6d4b\u4ee5\u53camysql\u6027\u80fd\u538b\u6d4b"},"content":{"rendered":"<p>\u00a0 \u00a0 sysbench<br \/>\n\u6027\u80fd\u538b\u6d4b\u4ee5\u53ca<br \/>\nmysql<br \/>\n\u6027\u80fd\u538b\u6d4b<\/p>\n<\/p>\n<p>\u4e00\u3001Sysbench<br \/>\n\u662f\u4e00\u4e2a\u6a21\u5757\u5316\u7684\u3001\u8de8\u5e73\u53f0\u3001\u591a\u7ebf\u7a0b\u57fa\u51c6\u6d4b\u8bd5\u5de5\u5177\uff0c\u4e3b\u8981\u7528\u4e8e\u5404\u79cd\u4e0d\u540c\u7cfb\u7edf\u7684\u53c2\u6570\u4e0b\u7684\u6570\u636e\u5e93\u8d1f\u8f7d\u60c5\u51b5\u3002<\/p>\n<p>\u00a0<\/p>\n<table>\n<thead>\n<tr>\n<th><\/th>\n<th><\/th>\n<th><\/th>\n<th><\/th>\n<th><\/th>\n<th><\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u4e3b\u8981\u6d4b\u8bd5\u65b9\u5f0f<\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>cpu\u6027\u80fd<\/td>\n<td>\u78c1\u76d8io\u6027\u80fd<\/td>\n<td>\u8c03\u5ea6\u7a0b\u5e8f\u6027\u80fd<\/td>\n<td>\u5185\u5b58\u5206\u914d\u53ca\u4f20\u8f93\u901f\u5ea6<\/td>\n<td>posix\u7ebf\u7a0b\u6027\u80fd<\/td>\n<td>\u6570\u636e\u5e93\u6027\u80fd\uff08OLTP\u57fa\u51c6\u6d4b\u8bd5\uff09<\/td>\n<\/tr>\n<tr>\n<td>\u627e\u8303\u56f4\u5185\u6700\u5927\u7d20\u6570{\u65f6\u95f4\u8d8a\u77ed\u8d8a\u597d}<\/td>\n<td>\u4e0d\u540c\u573a\u666f\u4e0biops{\u8d8a\u5927\u8d8a\u597d}<\/td>\n<td>\u7ebf\u7a0b\u5e76\u53d1\u6267\u884c\uff0c\u5faa\u73af\u54cd\u5e94\u4fe1\u53f7\u91cf\u82b1\u8d39\u7684\u65f6\u95f4{\u8d8a\u5c11\u8d8a\u597d}<\/td>\n<td>\u4ee5\u4e0d\u540c\u5757\u5927\u5c0f\u4f20\u8f93\u4e00\u5b9a\u7684\u6570\u91cf\u7684\u6570\u636e\u541e\u5410\u91cf\u5927\u5c0f{\u8d8a\u5927\u8d8a\u597d}<\/td>\n<td>\u5e76\u53d1\u7ebf\u7a0b\u540c\u65f6\u7533\u8bf7\u4e92\u65a5\u9501\u5faa\u73af\u4e00\u5b9a\u6b21\u6570\u82b1\u8d39\u7684\u65f6\u95f4{\u8d8a\u5c11\u8d8a\u597d}<\/td>\n<td>qps\u3001tps\u8d8a\u9ad8\u8d8a\u597d<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><div class=\"codecolorer-container text solarized-dark language-bash\" style=\"overflow:auto;white-space:nowrap;width:800px;\"><table cellspacing=\"0\" cellpadding=\"0\"><tbody><tr><td class=\"line-numbers\"><div>1<br \/><\/div><\/td><td><div class=\"text codecolorer\">1<\/div><\/td><\/tr><\/tbody><\/table><\/div>\n<\/p>\n<p>\u76ee\u524dsysbench<br \/>\n\u4e3b\u8981\u652f\u6301<br \/>\nMYSQL,pgsql,oracle\u00a0<br \/>\n\u8fd9<br \/>\n3<br \/>\n\u79cd\u6570\u636e\u5e93<\/p>\n<p>\u00a0<\/p>\n<p>\u4e8c\u3001<br \/>\n\u5b89\u88c5\u6d4b\u8bd5\u73af\u5883\uff1acentos6.8 \u00a0\u00a0mysql5.7.19<\/p>\n<p>\u4e09\u3001<br \/>\n\u5b89\u88c5sysbench-0.5<\/p>\n<p>\u6e90\u7801\u5730\u5740<a href=\"https:\/\/github.com\/BoobooWei\/sysbench\/archive\/master.zip\">https:\/\/github.com\/BoobooWei\/sysbench\/archive\/master.zip<\/a><\/p>\n<p>\u4e0b\u8f7d\u5230\u7535\u8111\u684c\u9762\uff0c\u7136\u540exshell<br \/>\n\u8fde\u63a5\u670d\u52a1\u5668\uff0c\u4e0b\u8f7d\u4e0a\u4f20\u8f6f\u4ef6\u5de5\u5177<\/p>\n<p>#cd \/usr\/local\/src\/<\/p>\n<p>#yum install lrzsz -y<\/p>\n<p>#rz \u00a0\u00a0\u00a0\u00a0\u00a0#<br \/>\n\u9009\u4e2d\u4e0b\u8f7d\u7684\u8f6f\u4ef6\u8fdb\u884c\u4e0a\u4f20<\/p>\n<p>#unzip sysbench-master.zip<\/p>\n<p>#cd sysbench-master<\/p>\n<p>#yum install -y automake libtool -y<\/p>\n<p>#.\/autogen.sh<\/p>\n<p>\u62a5\u9519\uff1aautom4te: \/usr\/bin\/m4 failed with exit status: 63<\/p>\n<p>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0aclocal: autom4te failed with exit status: 63<\/p>\n<p>\u663e\u793a\u7248\u672c\u592a\u4f4e\u4e86<\/p>\n<p>#<br \/>\n\u67e5\u770b\u7248\u672c\u4fe1\u606f \uff1a<br \/>\nyum info autoconf<\/p>\n<p>#<br \/>\n\u67e5\u770b\u8def\u5f84\uff1a<br \/>\nwhich autoconf<\/p>\n<p>#<br \/>\n\u79fb\u9664\u4f4e\u7248\u672c\u7684\uff1a<br \/>\nrpm -qf \/usr\/bin\/autoconf \u00a0rpm -e &#8211;nodeps autoconf-2.63<\/p>\n<p>#cd \/usr\/local\/src<\/p>\n<p>#<br \/>\n\u4e0b\u8f7d\u65b0\u7248\u672c\u8f6f\u4ef6\uff1a<br \/>\nwget\u00a0<a href=\"http:\/\/ftp.gnu.org\/gnu\/autoconf\/autoconf-2.69.tar.gz\">http:\/\/ftp.gnu.org\/gnu\/autoconf\/autoconf-2.69.tar.gz<\/a><\/p>\n<p>#tar -xzf autoconf-2.69.tar.gz<\/p>\n<p>#cd autoconf-2.69<\/p>\n<p>#.\/configure<\/p>\n<p>#make &amp;&amp; make install<\/p>\n<p>#<br \/>\n\u68c0\u67e5\u7248\u672c\u662f\u5426\u6b63\u786e \u00a0\u00a0<br \/>\nautoconf -V \u00a0\u00a0#<br \/>\n\u663e\u793a\u8def\u5f84\u8fd8\u662f\u9519\u7684<\/p>\n<p>#<br \/>\n\u5982\u679c\u62a5\u9519\u91cd\u65b0\u5b89\u88c5\u5982\u679c\u6ca1\u6709\u8df3\u8fc7 \u00a0<br \/>\nmake uninstall \u00a0\u00a0make clean<\/p>\n<p>#.\/configure &#8211;prefix=\/usr<\/p>\n<p>#make &amp;&amp; make install<\/p>\n<p>#autoconf -V \u00a0\u00a0<br \/>\n\u663e\u793a\u6b63\u5e38<\/p>\n<p>#cd \/usr\/local\/src\/sysbench-master<\/p>\n<p>#.\/autogen.sh \u00a0<br \/>\n\u663e\u793a\u6b63\u5e38<\/p>\n<p>#.\/configure \u00a0\u00a0\u00a0<\/p>\n<p>\u62a5\u9519\uff1acannot find MySQL libraries. If you want to compile with MySQL support,<br \/>\n\u7f3a\u5c11<br \/>\nmysql<br \/>\n\u4f9d\u8d56<\/p>\n<p># yum install mysql-devel -y<\/p>\n<p>#.\/configure \u00a0\u00a0\u00a0\u00a0\u00a0<br \/>\n\u663e\u793a\u6b63\u5e38<\/p>\n<p>#make &amp;&amp; make install<\/p>\n<p>\u56db\u3001<br \/>\n\u5b89\u88c5mysql5.7.19<\/p>\n<p>#wget <a href=\"https:\/\/dev.mysql.com\/get\/mysql57-community-release-el6-9.noarch.rpm\">https:\/\/dev.mysql.com\/get\/mysql57-community-release-el6-9.noarch.rpm<\/a><\/p>\n<p>#rpm -Uvh mysql57-community-release-el6-9.noarch.rpm<\/p>\n<p>#yum install mysql-community-server<\/p>\n<p>#service mysqld start<\/p>\n<p>#grep &#x27;temporary password&#x27; \/var\/log\/mysqld.log<\/p>\n<p>#mysql -uroot -p<\/p>\n<p>#<br \/>\n\u8f93\u5165\u8fc7\u6ee4\u51fa\u6765\u7684\u5bc6\u7801<\/p>\n<p>#set global validate_password_policy=0; \u00a0\u00a0\u00a0\u00a0\u00a0#<br \/>\n\u8bbe\u7f6e\u5bc6\u7801\u590d\u6742\u5ea6<\/p>\n<p>#set global validate_password_length=6; \u00a0\u00a0\u00a0\u00a0\u00a0#<br \/>\n\u8bbe\u7f6e\u5bc6\u7801\u957f\u5ea6<\/p>\n<p>#ALTER USER &#x27;root&#x27;@&#x27;localhost&#x27; IDENTIFIED BY &#x27;abc123&#x27;; \u00a0\u00a0#<br \/>\n\u66f4\u6539\u5bc6\u7801<\/p>\n<p>#create database sbtest;<\/p>\n<p>#quit<\/p>\n<p>\u00a0<\/p>\n<p>\u4e94\u3001\u6d4b\u8bd5<\/p>\n<p>Mysql<br \/>\n\u6570\u636e\u5e93\u6d4b\u8bd5<\/p>\n<p>sysbench 0.5<br \/>\n\u901a\u8fc7\u4e00\u7cfb\u5217<br \/>\nLUA<br \/>\n\u811a\u672c\u6765\u66ff\u6362\u4e4b\u524d\u7684<br \/>\noltp<br \/>\n\uff0c\u6765\u6a21\u62df\u66f4\u63a5\u8fd1\u771f\u5b9e\u7684\u57fa\u51c6\u6d4b\u8bd5\u73af\u5883\u3002\u8fd9\u4e9b\u6d4b\u8bd5\u811a\u672c\u5305\u542b\uff1a<br \/>\ninsert.lua<br \/>\n\u3001<br \/>\noltp.lua<br \/>\n\u3001<br \/>\nparallel_prepare.lua<br \/>\n\u3001<br \/>\nselect_random_points.lua<br \/>\n\u3001<br \/>\nupdate_index.lua<br \/>\n\u3001<br \/>\ndelete.luaoltp_simple.lua<br \/>\n\u3001<br \/>\nselect.lua<br \/>\n\u3001<br \/>\nselect_random_ranges.lua<br \/>\n\u3001<br \/>\nupdate_non_index.lua<br \/>\n\uff0c\u811a\u672c\u4f7f\u7528\u65b9\u5f0f\u57fa\u672c\u7c7b\u4f3c\u3002<\/p>\n<p>\u00a0<\/p>\n<p>sysbench 0.5<br \/>\n\u9ed8\u8ba4\u4f7f\u7528<br \/>\nsbtest<br \/>\n\u5e93\uff0c\u4f46\u662f\u9700\u8981\u81ea\u5df1\u624b\u5de5\u5148\u521b\u5efa\u597d\uff0c\u4e5f\u53ef\u4ee5\u4f7f\u7528<br \/>\n&#8211;mysql-db<br \/>\n\u6307\u5b9a\uff0c\u5176\u4ed6\u975e\u9ed8\u8ba4\u9879\u6307\u5b9a\u9009\u9879\uff1a<\/p>\n<p>\u00a0<\/p>\n<p>&#8211;mysql-host<\/p>\n<p>\u00a0<\/p>\n<p>&#8211;mysql-port<\/p>\n<p>\u00a0<\/p>\n<p>&#8211;mysql-socket<\/p>\n<p>\u00a0<\/p>\n<p>&#8211;mysql-user<\/p>\n<p>\u00a0<\/p>\n<p>&#8211;mysql-password<\/p>\n<p>\u00a0<\/p>\n<p>&#8211;mysql-db<\/p>\n<p>\u00a0<\/p>\n<p>&#8211;mysql-ssl<\/p>\n<p>\u00a0<\/p>\n<p>prepare<\/p>\n<p>\u00a0<\/p>\n<p>\u751f\u6210\u8868\u5e76\u63d2\u5165\u6570\u636e\uff0c\u53ef\u4f7f\u7528parallel_prepare.lua<br \/>\n\u811a\u672c\u6765\u5e76\u884c\u51c6\u5907\u6570\u636e\u3002<\/p>\n<p>\u00a0<\/p>\n<ul>\n<li><\/li>\n<\/ul>\n<p>\u2013<br \/>\ndb-driver\u00a0<br \/>\n\u670d\u52a1\u5668\u7c7b\u578b<br \/>\nmysql | drizzle,<br \/>\n\u9ed8\u8ba4\u4e3a<br \/>\nmysql<\/p>\n<p>\u00a0<\/p>\n<ul>\n<li><\/li>\n<\/ul>\n<p>\u2013<br \/>\nmysql-table-engine\u00a0<br \/>\n\u8868\u5b58\u6570\u5f15\u64ce<\/p>\n<p>\u00a0<\/p>\n<ul>\n<li><\/li>\n<\/ul>\n<p>\u2013<br \/>\nmyisam-max-rows MyISAM<br \/>\n\u8868<br \/>\nMAX_ROWS<br \/>\n\u9009\u9879<br \/>\n(<br \/>\n\u7528\u4e8e\u5927\u8868<br \/>\n)<\/p>\n<p>\u00a0<\/p>\n<p>\u2013<br \/>\n-oltp-table-count\u00a0<br \/>\n\u751f\u6210\u8868\u6570\u91cf<br \/>\n[sbtest1<br \/>\n\u3001<br \/>\nsbtest2&#8230;]<\/p>\n<p>\u00a0<\/p>\n<ul>\n<li><\/li>\n<\/ul>\n<p>\u2013<br \/>\noltp-table-size\u00a0<br \/>\n\u751f\u6210\u8868\u7684\u884c\u6570<\/p>\n<p>\u00a0<\/p>\n<ul>\n<li><\/li>\n<\/ul>\n<p>\u2013<br \/>\noltp-secondary ID<br \/>\n\u5217\u751f\u6210\u4e8c\u7ea7\u7d22\u5f15\u800c\u4e0d\u662f\u4e3b\u952e<\/p>\n<p>\u00a0<\/p>\n<p>\u2013<br \/>\n-oltp-auto-inc<br \/>\n\u8bbe\u7f6e<br \/>\nID<br \/>\n\u5217\u662f\u5426\u81ea\u589e\u00a0<br \/>\non | off<br \/>\n\uff0c\u9ed8\u8ba4\u4e3a<br \/>\non &#8211;oltp-read-only=on<\/p>\n<p>\u00a0<\/p>\n<p>&#8211;test=sysbench-0.5\/sysbench\/tests<br \/>\n\u76ee\u5f55\u4e0b\u6d4b\u8bd5\u811a\u672c<\/p>\n<p>\u00a0<\/p>\n<p>sysbench \\<\/p>\n<p>&#8211;test=\/root\/sysbench-master\/sysbench\/tests\/db\/oltp.lua \u00a0\\<\/p>\n<p>&#8211;mysql-host=localhost \u00a0\\<\/p>\n<p>&#8211;mysql-port=3306 \u00a0\\<\/p>\n<p>&#8211;mysql-user=root \u00a0\\<\/p>\n<p>&#8211;mysql-password=abc123 \\<\/p>\n<p>&#8211;oltp-table-size=100000 \\<\/p>\n<p>&#8211;num-threads=8 \\<\/p>\n<p>&#8211;max-time=10 \\<\/p>\n<p>&#8211;mysql-db=sbtest \\<\/p>\n<p>&#8211;max-requests=0 \\<\/p>\n<p>&#8211;oltp-test-mode=complex \\<\/p>\n<p>&#8211;report-interval=1 \\<\/p>\n<p>&#8211;mysql-table-engine=innodb \u00a0\\<\/p>\n<p>[prepare|run|cleanup]<br \/>\n\u51c6\u5907<br \/>\n\/<br \/>\n\u6d4b\u8bd5<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 \u00a0 sysbench \u6027\u80fd\u538b\u6d4b\u4ee5\u53ca mysql \u6027\u80fd\u538b\u6d4b \u4e00\u3001Sysbench \u662f\u4e00\u4e2a\u6a21\u5757\u5316\u7684\u3001\u8de8\u5e73\u53f0\u3001\u591a\u7ebf\u7a0b\u57fa\u51c6\u6d4b\u8bd5\u5de5\u5177\uff0c\u4e3b\u8981\u7528\u4e8e\u5404\u79cd\u4e0d\u540c\u7cfb\u7edf\u7684\u53c2\u6570\u4e0b\u7684\u6570\u636e\u5e93\u8d1f\u8f7d\u60c5\u51b5\u3002 \u00a0 \u4e3b\u8981\u6d4b\u8bd5\u65b9\u5f0f cpu\u6027\u80fd \u78c1\u76d8io\u6027\u80fd \u8c03\u5ea6\u7a0b\u5e8f\u6027\u80fd \u5185\u5b58\u5206\u914d\u53ca\u4f20\u8f93\u901f\u5ea6 posix\u7ebf\u7a0b\u6027\u80fd \u6570\u636e\u5e93\u6027\u80fd\uff08OLTP\u57fa\u51c6\u6d4b\u8bd5\uff09 \u627e\u8303\u56f4\u5185\u6700\u5927\u7d20\u6570{\u65f6\u95f4\u8d8a\u77ed\u8d8a\u597d} \u4e0d\u540c\u573a\u666f\u4e0biops{\u8d8a\u5927\u8d8a\u597d} \u7ebf\u7a0b\u5e76\u53d1\u6267\u884c\uff0c\u5faa\u73af\u54cd\u5e94\u4fe1\u53f7\u91cf\u82b1\u8d39\u7684\u65f6\u95f4{\u8d8a\u5c11\u8d8a\u597d} \u4ee5\u4e0d\u540c\u5757\u5927\u5c0f\u4f20\u8f93\u4e00\u5b9a\u7684\u6570\u91cf\u7684\u6570\u636e\u541e\u5410\u91cf\u5927\u5c0f{\u8d8a\u5927\u8d8a\u597d} \u5e76\u53d1\u7ebf\u7a0b\u540c\u65f6\u7533\u8bf7\u4e92\u65a5\u9501\u5faa\u73af\u4e00\u5b9a\u6b21\u6570\u82b1\u8d39\u7684<\/p>\n","protected":false},"author":1,"featured_media":6522,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[5],"tags":[292,132,187,390,26,103,25,21,10,500,20],"collection":[],"_links":{"self":[{"href":"https:\/\/aqzt.com\/wp-json\/wp\/v2\/posts\/20199"}],"collection":[{"href":"https:\/\/aqzt.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aqzt.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aqzt.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aqzt.com\/wp-json\/wp\/v2\/comments?post=20199"}],"version-history":[{"count":0,"href":"https:\/\/aqzt.com\/wp-json\/wp\/v2\/posts\/20199\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aqzt.com\/wp-json\/wp\/v2\/media\/6522"}],"wp:attachment":[{"href":"https:\/\/aqzt.com\/wp-json\/wp\/v2\/media?parent=20199"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aqzt.com\/wp-json\/wp\/v2\/categories?post=20199"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aqzt.com\/wp-json\/wp\/v2\/tags?post=20199"},{"taxonomy":"collection","embeddable":true,"href":"https:\/\/aqzt.com\/wp-json\/wp\/v2\/collection?post=20199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}