https:\/\/github.com\/axboe\/fio\/archive\/fio-2.16.tar.gz<\/a><\/span><\/span><\/span><\/p>\n\u9644\u5f55\u4e09\u3001\u5404\u5de5\u5177\u6d4b\u8bd5\u547d\u4ee4<\/p>\n
UnixBench .\/Run<\/span><\/span><\/span><\/p>\nCyclictest .\/cyclictest -D 10s -q<\/span><\/span><\/span><\/p>\nmbw .\/mbw -n 250 -t 0 200<\/span><\/span><\/span><\/p>\n.\/fio –name=randread –direct=1 –bs=4k –iodepth=64 –size=4G –rw=randread –gtod_reduce=1<\/span><\/span><\/span><\/p>\n.\/fio –name=randwrite –direct=1 –bs=4k –iodepth=64 –size=4G –rw=randwrite –gtod_reduce=1<\/span><\/span><\/span><\/p>\ndd if=\/dev\/zero of=test.dbf bs=8k count=200000 conv=fdatasync<\/span><\/span><\/span><\/p>\nsysbench –test=oltp –oltp-table-size=1000000 –mysql-db=dbtest –mysql-host=10.66.104.109 –mysql-user=root –mysql-password=Ruvrj9CdkL9Qsn3Y –db-driver=mysql prepare<\/span><\/span><\/span><\/p>\nsysbench –test=oltp –oltp-table-size=1000000 –oltp-test-mode=complex –oltp-read-only=off –num-threads=6 –max-time=60 –max-requests=0 –mysql-db=dbtest –mysql-host=10.66.104.109 –mysql-user=root –db-driver=mysql –mysql-password=Ruvrj9CdkL9Qsn3Y run<\/span><\/span><\/span><\/p>\nsysbench –test=oltp –oltp-table-size=1000000 –oltp-test-mode=complex –oltp-read-only=on –num-threads=6 –max-time=60 –max-requests=0 –mysql-db=dbtest –mysql-host=10.66.104.109 –mysql-user=root –db-driver=mysql –mysql-password=Ruvrj9CdkL9Qsn3Y run<\/span><\/span><\/span><\/p>\n\u590d\u6742SQL<\/span><\/span><\/span>\uff1aselect * from (select a.pid, b.pbid, a.gid, gczbid, projectstatus, companyname, projectname, bailmoney, backbailbank, backbailprovince, backbailcity, bailtype, b.comment, bailcomment, paycompanyname, backbailaccount, backbailname, bailreachtime, backbailinterestrate, backbailinterest, backbailtime, backbailtotal, bailhasreturned, returnbailtime, returnbailmoney, locktime, financereturnbaildate, CASE WHEN SUM(c.iswinner)=0 THEN 0 ELSE 1 END AS iswinner from gczb_projects as a, gczb_projects_bidders as b, gczb_packages_bidders as c where a.pid = b.pid and b.pbid = c.pbid group by a.pid, b.pbid) a left join (select pid, winningtime from `gczb_packages` group by pid) as b on b.pid= a.pid where 1 order by gczbid asc, projectname asc limit 10<\/span><\/span><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"\u516c\u53f8\u7cfb\u7edf\u76ee\u524d\u5728\u5929\u7ffc\u4e91\u4e3b\u673a\u4e2d\uff0c\u56e0\u8fd1\u671f\u4f7f\u7528\u8005\u589e\u52a0\uff0c\u7cfb\u7edf\u590d\u6742\u5ea6\u7684\u589e\u52a0\uff0c\u5bfc\u81f4\u7cfb\u7edf\u51fa\u73b0\u4e86\u4e00 … Read More »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/actom.me\/blog\/wp-json\/wp\/v2\/posts\/1237"}],"collection":[{"href":"https:\/\/actom.me\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/actom.me\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/actom.me\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/actom.me\/blog\/wp-json\/wp\/v2\/comments?post=1237"}],"version-history":[{"count":1,"href":"https:\/\/actom.me\/blog\/wp-json\/wp\/v2\/posts\/1237\/revisions"}],"predecessor-version":[{"id":1238,"href":"https:\/\/actom.me\/blog\/wp-json\/wp\/v2\/posts\/1237\/revisions\/1238"}],"wp:attachment":[{"href":"https:\/\/actom.me\/blog\/wp-json\/wp\/v2\/media?parent=1237"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/actom.me\/blog\/wp-json\/wp\/v2\/categories?post=1237"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/actom.me\/blog\/wp-json\/wp\/v2\/tags?post=1237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}