{"id":915,"date":"2020-11-27T16:05:35","date_gmt":"2020-11-27T08:05:35","guid":{"rendered":"http:\/\/prayerlaputa.com\/?p=915"},"modified":"2020-11-27T16:05:35","modified_gmt":"2020-11-27T08:05:35","slug":"%e4%bd%bf%e7%94%a8sysbench%e5%af%b9mysql%e8%bf%9b%e8%a1%8c%e5%9f%ba%e5%87%86%e6%b5%8b%e8%af%95","status":"publish","type":"post","link":"http:\/\/prayerlaputa.com\/?p=915","title":{"rendered":"\u4f7f\u7528sysbench\u5bf9mysql\u8fdb\u884c\u57fa\u51c6\u6d4b\u8bd5"},"content":{"rendered":"
\n

\u6d4b\u8bd5\u73af\u5883\u8bf4\u660e<\/h3>\n<\/div>\n

\u786c\u4ef6<\/span><\/h4>\n
    \n
  • \n

    \u817e\u8baf\u4e91\u6807\u51c6\u578bSA2<\/span><\/p>\n

      \n
    • \n

      1\u6838 2GB 1Mbps<\/span><\/p>\n<\/li>\n

    • \n

      \u7cfb\u7edf\u76d8\uff1a\u9ad8\u6027\u80fd\u4e91\u786c\u76d8(50G)<\/span><\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

      <\/p>\n

      \u8f6f\u4ef6<\/span><\/h4>\n
        \n
      • \n

        centos 7.5 64\u4f4d<\/span><\/p>\n<\/li>\n

      • \n

        mysql 5.7.31<\/span><\/p>\n<\/li>\n

      • \n

        sysbench 1.0.20<\/span><\/p>\n<\/li>\n<\/ul>\n

        \u6d4b\u8bd5\u8fc7\u7a0b <\/span><\/h3>\n

        \u4f7f\u7528sysbench\u3002<\/span><\/p>\n

        1. \u6d4b\u8bd5innodb 100w\u6761\u8bb0\u5f55\u7684\u8bfb\u5199\u6027\u80fd<\/span><\/h4>\n
        1.1 \u751f\u6210100w\u6570\u636e<\/span><\/h5>\n

        \u6b64\u5904\u5077\u61d2\u4e86\uff0c\u76f4\u63a5\u4f7f\u7528\u4e86sysbench\u9ed8\u8ba4\u7684\u811a\u672c\u521b\u5efa\u6570\u636e\u5e93\u8868\uff0c\u5982\u679c\u9700\u8981\u6d4b\u8bd5\u7279\u5b9a\u7684\u8868\uff0c\u9700\u8981\u4fee\u6539<\/span>\/usr\/share\/sysbench<\/code><\/span>\u4e0b\u7684\u811a\u672c\uff0c\u57fa\u672c\u53ea\u9700\u8981\u4fee\u6539<\/span>oltp_common.lua<\/code><\/span>\u811a\u672c\u5373\u53ef\uff0c\u8fd9\u4e2a\u9700\u8981\u82b1\u65f6\u95f4\u7ec6\u81f4\u7684\u4fee\u6539\uff0c\u8fd9\u6b21\u5c31\u4e0d\u5728\u8fd9\u65b9\u9762\u591a\u82b1\u65f6\u95f4\u4e86\u3002\u672c\u6b21\u4e3b\u8981\u76ee\u7684\u662f\u505a\u57fa\u51c6\u6d4b\u8bd5\u3001\u770b\u770bMysql\u6027\u80fd\u3002<\/span><\/p>\n

        sysbench --db-driver<\/span>=<\/span>mysql --mysql-host<\/span>=<\/span>localhost --mysql-port<\/span>=<\/span>3306<\/span> --mysql-user<\/span>=<\/span>root --mysql-password<\/span>=<\/span>1qaz@WSX --mysql-db<\/span>=<\/span>sbtest --table_size<\/span>=<\/span>1000000<\/span> --tables<\/span>=<\/span>10<\/span> --events<\/span>=<\/span>0<\/span> --time<\/span>=<\/span>300<\/span> \u00a0--threads<\/span>=<\/span>20<\/span>  oltp_read_write prepare<\/span><\/pre>\n
        1.2 \u8fdb\u884c\u8bfb\u5199\u6d4b\u8bd5<\/span><\/h5>\n
        1.2.1 \u7b2c\u4e00\u6b21\u76f4\u63a5\u6267\u884c100w\u6b21\u8bfb\u5199<\/span><\/h6>\n
        \u6267\u884c\u547d\u4ee4\uff1a <\/span><\/p>\n
        sysbench --db-driver<\/span>=<\/span>mysql --mysql-host<\/span>=<\/span>localhost --mysql-port<\/span>=<\/span>3306<\/span> --mysql-user<\/span>=<\/span>root --mysql-password<\/span>=<\/span>1qaz@WSX --mysql-db<\/span>=<\/span>sbtest --table_size<\/span>=<\/span>1000000<\/span> --tables<\/span>=<\/span>10<\/span> --events<\/span>=<\/span>0<\/span> --time<\/span>=<\/span>300<\/span> \u00a0--threads<\/span>=<\/span>20<\/span> --percentile<\/span>=<\/span>95<\/span> --report-interval<\/span>=<\/span>10<\/span> oltp_read_write run<\/span><\/pre>\n
        \u53c2\u6570\u8bf4\u660e\uff1a<\/span><\/p>\n
          \n
        • \n
          \u6307\u5b9a\u6d4b\u8bd5mysql\uff0c\u9ed8\u8ba4\u5b58\u50a8\u5f15\u64ce\u662finnodb\uff0c\u6307\u5b9amysql\u5730\u5740\u3001\u7aef\u53e3\u3001\u7528\u6237\u7b49\u4fe1\u606f<\/span><\/p>\n<\/li>\n
        • \n
          \u9009\u53d6\u6d4b\u8bd5\u7684\u6570\u636e\u5e93\u4e3asbtest\uff0c\u6bcf\u4e2a\u8868\u7684\u5927\u5c0f\u4e3a100w\u6761\u6570\u636e\uff0c\u521b\u5efa10\u5f20\u8868<\/span><\/p>\n<\/li>\n
        • \n
          \u6d4b\u8bd5\u65f6\u95f4300s, 20\u4e2a\u7ebf\u7a0b\u540c\u65f6\u6d4b\u8bd5<\/span><\/p>\n<\/li>\n
        • \n
          \u8f93\u51fa\u6d4b\u8bd5\u7ed3\u679c95\u5206\u4f4d<\/span><\/p>\n<\/li>\n
        • \n
          \u6bcf\u969410s\u8f93\u51fa\u4e00\u6b21\u5f53\u524d\u6d4b\u8bd5\u60c5\u51b5<\/span><\/p>\n<\/li>\n
        • \n
          \u9009\u53d6sysbench\u4e2d\u7684oltp_read_write.lua\uff0c\u6d4b\u8bd5\u8bfb\u5199\u60c5\u51b5<\/span><\/p>\n<\/li>\n<\/ul>\n
          \u6ce8\u610f\u6b64\u5904\u6ca1\u6709\u9884\u70ed\uff0c\u5148\u89c2\u5bdf\u4e0b\u6ca1\u6709\u9884\u70ed\u60c5\u51b5\u4e0b\u7684\u8bfb\u5199\u6027\u80fd\uff0c\u5f97\u5230\u5982\u4e0b\u6267\u884c\u7ed3\u679c\uff1a<\/span><\/p>\n
          [root@VM_0_5_centos ~]# sysbench --db-driver=mysql --mysql-host=localhost --mysql-port=3306 --mysql-user=root --mysql-password=1qaz@WSX --mysql-db=sbtest --table_size=1000000 --tables=10 --events=0 --time=300  --threads=20 --percentile=95 --report-interval=10 oltp_read_write run<\/span>\r\nsysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)<\/span>\r\n\u200b<\/span>\r\nRunning the test with following options:<\/span>\r\nNumber of threads: 20<\/span>\r\nReport intermediate results every 10 second(s)<\/span>\r\nInitializing random number generator from current time<\/span>\r\n\u200b<\/span>\r\n\u200b<\/span>\r\nInitializing worker threads...<\/span>\r\n\u200b<\/span>\r\nThreads started!<\/span>\r\n\u200b<\/span>\r\n[ 10s ] thds: 20 tps: 115.28 qps: 2327.70 (r\/w\/o: 1633.92\/461.22\/232.56) lat (ms,95%): 337.94 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 20s ] thds: 20 tps: 107.65 qps: 2154.96 (r\/w\/o: 1508.64\/431.01\/215.31) lat (ms,95%): 350.33 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 30s ] thds: 20 tps: 107.57 qps: 2155.23 (r\/w\/o: 1509.13\/430.97\/215.13) lat (ms,95%): 337.94 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 40s ] thds: 20 tps: 102.08 qps: 2027.14 (r\/w\/o: 1414.88\/408.11\/204.16) lat (ms,95%): 369.77 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 50s ] thds: 20 tps: 111.17 qps: 2239.64 (r\/w\/o: 1571.11\/446.19\/222.34) lat (ms,95%): 337.94 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 60s ] thds: 20 tps: 118.82 qps: 2376.16 (r\/w\/o: 1663.62\/474.89\/237.65) lat (ms,95%): 297.92 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 70s ] thds: 20 tps: 118.57 qps: 2369.40 (r\/w\/o: 1657.88\/474.48\/237.04) lat (ms,95%): 325.98 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 80s ] thds: 20 tps: 125.53 qps: 2512.64 (r\/w\/o: 1758.58\/502.91\/251.15) lat (ms,95%): 287.38 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 90s ] thds: 20 tps: 115.44 qps: 2298.71 (r\/w\/o: 1609.27\/458.76\/230.68) lat (ms,95%): 314.45 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 100s ] thds: 20 tps: 120.28 qps: 2412.81 (r\/w\/o: 1689.53\/482.52\/240.76) lat (ms,95%): 314.45 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 110s ] thds: 20 tps: 123.70 qps: 2460.59 (r\/w\/o: 1719.30\/494.00\/247.30) lat (ms,95%): 287.38 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 120s ] thds: 20 tps: 121.74 qps: 2455.40 (r\/w\/o: 1720.96\/490.86\/243.58) lat (ms,95%): 287.38 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 130s ] thds: 20 tps: 129.32 qps: 2580.95 (r\/w\/o: 1808.11\/514.19\/258.64) lat (ms,95%): 292.60 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 140s ] thds: 20 tps: 125.38 qps: 2508.77 (r\/w\/o: 1756.50\/501.51\/250.76) lat (ms,95%): 282.25 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 150s ] thds: 20 tps: 128.26 qps: 2564.90 (r\/w\/o: 1794.64\/513.74\/256.52) lat (ms,95%): 287.38 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 160s ] thds: 20 tps: 129.90 qps: 2596.47 (r\/w\/o: 1817.98\/518.79\/259.70) lat (ms,95%): 267.41 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 170s ] thds: 20 tps: 130.30 qps: 2597.18 (r\/w\/o: 1816.16\/520.32\/260.71) lat (ms,95%): 262.64 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 180s ] thds: 20 tps: 134.10 qps: 2685.40 (r\/w\/o: 1881.30\/535.90\/268.20) lat (ms,95%): 267.41 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 190s ] thds: 20 tps: 131.38 qps: 2636.25 (r\/w\/o: 1842.79\/530.91\/262.56) lat (ms,95%): 282.25 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 200s ] thds: 20 tps: 134.40 qps: 2687.60 (r\/w\/o: 1883.30\/535.30\/269.00) lat (ms,95%): 282.25 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 210s ] thds: 20 tps: 130.51 qps: 2610.40 (r\/w\/o: 1827.61\/521.76\/261.03) lat (ms,95%): 292.60 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 220s ] thds: 20 tps: 134.91 qps: 2687.87 (r\/w\/o: 1880.32\/537.73\/269.82) lat (ms,95%): 272.27 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 230s ] thds: 20 tps: 131.30 qps: 2633.77 (r\/w\/o: 1845.48\/525.69\/262.60) lat (ms,95%): 277.21 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 240s ] thds: 20 tps: 133.78 qps: 2676.67 (r\/w\/o: 1872.87\/536.23\/267.57) lat (ms,95%): 253.35 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 250s ] thds: 20 tps: 134.10 qps: 2681.82 (r\/w\/o: 1876.34\/537.28\/268.19) lat (ms,95%): 292.60 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 260s ] thds: 20 tps: 136.32 qps: 2711.48 (r\/w\/o: 1896.94\/541.90\/272.65) lat (ms,95%): 253.35 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 270s ] thds: 20 tps: 134.20 qps: 2692.50 (r\/w\/o: 1884.80\/539.30\/268.40) lat (ms,95%): 262.64 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 280s ] thds: 20 tps: 133.03 qps: 2664.24 (r\/w\/o: 1866.85\/531.33\/266.06) lat (ms,95%): 262.64 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 290s ] thds: 20 tps: 134.52 qps: 2687.68 (r\/w\/o: 1880.73\/537.90\/269.05) lat (ms,95%): 262.64 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 300s ] thds: 20 tps: 130.74 qps: 2615.97 (r\/w\/o: 1830.71\/523.77\/261.49) lat (ms,95%): 277.21 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\nSQL statistics:<\/span>\r\n \u00a0  queries performed:<\/span>\r\n \u00a0 \u00a0 \u00a0  read: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  527282<\/span>\r\n \u00a0 \u00a0 \u00a0  write: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 150652<\/span>\r\n \u00a0 \u00a0 \u00a0  other: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 75326<\/span>\r\n \u00a0 \u00a0 \u00a0  total: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 753260<\/span>\r\n \u00a0  transactions: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  37663  (125.47 per sec.)<\/span>\r\n \u00a0  queries: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 753260 (2509.43 per sec.)<\/span>\r\n \u00a0  ignored errors: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  0 \u00a0 \u00a0  (0.00 per sec.)<\/span>\r\n \u00a0  reconnects: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  0 \u00a0 \u00a0  (0.00 per sec.)<\/span>\r\n\u200b<\/span>\r\nGeneral statistics:<\/span>\r\n \u00a0  total time: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  300.1706s<\/span>\r\n \u00a0  total number of events: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  37663<\/span>\r\n\u200b<\/span>\r\nLatency (ms):<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 min: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  7.13<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 avg: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  159.35<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 max: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  873.88<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 95th percentile: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  292.60<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 sum: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  6001658.82<\/span>\r\n\u200b<\/span>\r\nThreads fairness:<\/span>\r\n \u00a0  events (avg\/stddev): \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1883.1500\/14.40<\/span>\r\n \u00a0  execution time (avg\/stddev): \u00a0 300.0829\/0.05<\/span><\/pre>\n
          1.2.2 \u7b2c\u4e8c\u6b21\u6267\u884c100w\u6b21\u8bfb\u5199 <\/span><\/h6>\n
          \u5728\u7b2c\u4e00\u6b21\u6267\u884c\u5b8c\u6210\u540e\uff0c\u518d\u4e00\u6b21\u6267\u884c\u76f8\u540c\u7684\u538b\u6d4b\u547d\u4ee4\uff1a<\/span><\/p>\n
          sysbench --db-driver<\/span>=<\/span>mysql --mysql-host<\/span>=<\/span>localhost --mysql-port<\/span>=<\/span>3306<\/span> --mysql-user<\/span>=<\/span>root --mysql-password<\/span>=<\/span>1qaz@WSX --mysql-db<\/span>=<\/span>sbtest --table_size<\/span>=<\/span>1000000<\/span> --tables<\/span>=<\/span>10<\/span> --events<\/span>=<\/span>0<\/span> --time<\/span>=<\/span>300<\/span> \u00a0--threads<\/span>=<\/span>20<\/span> --percentile<\/span>=<\/span>95<\/span> --report-interval<\/span>=<\/span>10<\/span> oltp_read_write run<\/span><\/pre>\n
          \u4e5f\u5c31\u662f\u8bf4\uff0c\u5c06\u7b2c\u4e00\u6b21\u6267\u884c\u5f53\u505a\u9884\u70ed\uff0c\u7136\u540e\u5f97\u5230\u4e86\u5982\u4e0b\u7ed3\u679c\uff1a<\/span><\/p>\n
          [root@VM_0_5_centos ~]# sysbench --db-driver=mysql --mysql-host=localhost --mysql-port=3306 --mysql-user=root --mysql-password=1qaz@WSX --mysql-db=sbtest --table_size=1000000 --tables=10 --events=0 --time=300  --threads=20 --percentile=95 --report-interval=10 oltp_read_write run<\/span>\r\nsysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)<\/span>\r\n\u200b<\/span>\r\nRunning the test with following options:<\/span>\r\nNumber of threads: 20<\/span>\r\nReport intermediate results every 10 second(s)<\/span>\r\nInitializing random number generator from current time<\/span>\r\n\u200b<\/span>\r\n\u200b<\/span>\r\nInitializing worker threads...<\/span>\r\n\u200b<\/span>\r\nThreads started!<\/span>\r\n\u200b<\/span>\r\n[ 10s ] thds: 20 tps: 134.18 qps: 2711.59 (r\/w\/o: 1901.91\/539.32\/270.36) lat (ms,95%): 272.27 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 20s ] thds: 20 tps: 137.73 qps: 2743.17 (r\/w\/o: 1918.90\/549.01\/275.26) lat (ms,95%): 262.64 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 30s ] thds: 20 tps: 135.00 qps: 2700.12 (r\/w\/o: 1889.21\/540.70\/270.20) lat (ms,95%): 272.27 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 40s ] thds: 20 tps: 133.61 qps: 2680.90 (r\/w\/o: 1880.57\/533.12\/267.21) lat (ms,95%): 262.64 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 50s ] thds: 20 tps: 133.36 qps: 2673.78 (r\/w\/o: 1869.10\/537.96\/266.73) lat (ms,95%): 253.35 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 60s ] thds: 20 tps: 139.24 qps: 2776.62 (r\/w\/o: 1945.18\/553.07\/278.38) lat (ms,95%): 253.35 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 70s ] thds: 20 tps: 132.31 qps: 2646.75 (r\/w\/o: 1852.27\/529.75\/264.72) lat (ms,95%): 272.27 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 80s ] thds: 20 tps: 138.52 qps: 2764.91 (r\/w\/o: 1934.31\/553.56\/277.03) lat (ms,95%): 267.41 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 90s ] thds: 20 tps: 133.20 qps: 2673.72 (r\/w\/o: 1874.85\/532.48\/266.39) lat (ms,95%): 267.41 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 100s ] thds: 20 tps: 139.13 qps: 2783.76 (r\/w\/o: 1946.06\/559.43\/278.27) lat (ms,95%): 262.64 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 110s ] thds: 20 tps: 133.60 qps: 2673.61 (r\/w\/o: 1872.01\/534.40\/267.20) lat (ms,95%): 267.41 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 120s ] thds: 20 tps: 137.21 qps: 2739.02 (r\/w\/o: 1916.55\/548.04\/274.42) lat (ms,95%): 253.35 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 130s ] thds: 20 tps: 136.59 qps: 2736.29 (r\/w\/o: 1916.22\/546.88\/273.19) lat (ms,95%): 272.27 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 140s ] thds: 20 tps: 133.31 qps: 2667.76 (r\/w\/o: 1865.01\/536.33\/266.42) lat (ms,95%): 272.27 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 150s ] thds: 20 tps: 136.29 qps: 2728.42 (r\/w\/o: 1910.27\/545.36\/272.78) lat (ms,95%): 257.95 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 160s ] thds: 20 tps: 137.75 qps: 2747.96 (r\/w\/o: 1925.34\/547.21\/275.41) lat (ms,95%): 248.83 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 170s ] thds: 20 tps: 136.25 qps: 2727.97 (r\/w\/o: 1910.08\/545.29\/272.60) lat (ms,95%): 257.95 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 180s ] thds: 20 tps: 139.96 qps: 2799.77 (r\/w\/o: 1958.39\/561.45\/279.93) lat (ms,95%): 253.35 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 190s ] thds: 20 tps: 136.37 qps: 2724.15 (r\/w\/o: 1907.31\/544.09\/272.74) lat (ms,95%): 253.35 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 200s ] thds: 20 tps: 137.35 qps: 2748.81 (r\/w\/o: 1925.74\/548.38\/274.69) lat (ms,95%): 257.95 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 210s ] thds: 20 tps: 138.32 qps: 2760.41 (r\/w\/o: 1930.89\/552.88\/276.64) lat (ms,95%): 257.95 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 220s ] thds: 20 tps: 136.57 qps: 2730.27 (r\/w\/o: 1912.63\/544.89\/272.75) lat (ms,95%): 272.27 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 230s ] thds: 20 tps: 135.90 qps: 2725.03 (r\/w\/o: 1905.42\/547.41\/272.20) lat (ms,95%): 262.64 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 240s ] thds: 20 tps: 139.06 qps: 2780.47 (r\/w\/o: 1948.78\/553.56\/278.13) lat (ms,95%): 267.41 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 250s ] thds: 20 tps: 136.23 qps: 2719.64 (r\/w\/o: 1902.58\/544.61\/272.45) lat (ms,95%): 267.41 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 260s ] thds: 20 tps: 136.39 qps: 2736.95 (r\/w\/o: 1913.82\/550.35\/272.77) lat (ms,95%): 257.95 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 270s ] thds: 20 tps: 141.91 qps: 2829.29 (r\/w\/o: 1980.91\/564.56\/283.83) lat (ms,95%): 248.83 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 280s ] thds: 20 tps: 138.60 qps: 2776.59 (r\/w\/o: 1944.46\/554.92\/277.21) lat (ms,95%): 253.35 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 290s ] thds: 20 tps: 137.72 qps: 2747.78 (r\/w\/o: 1923.26\/549.08\/275.44) lat (ms,95%): 267.41 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 300s ] thds: 20 tps: 139.27 qps: 2798.45 (r\/w\/o: 1958.44\/561.47\/278.54) lat (ms,95%): 253.35 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\nSQL statistics:<\/span>\r\n \u00a0  queries performed:<\/span>\r\n \u00a0 \u00a0 \u00a0  read: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  574434<\/span>\r\n \u00a0 \u00a0 \u00a0  write: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 164124<\/span>\r\n \u00a0 \u00a0 \u00a0  other: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 82062<\/span>\r\n \u00a0 \u00a0 \u00a0  total: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 820620<\/span>\r\n \u00a0  transactions: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  41031  (136.74 per sec.)<\/span>\r\n \u00a0  queries: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 820620 (2734.82 per sec.)<\/span>\r\n \u00a0  ignored errors: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  0 \u00a0 \u00a0  (0.00 per sec.)<\/span>\r\n \u00a0  reconnects: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  0 \u00a0 \u00a0  (0.00 per sec.)<\/span>\r\n\u200b<\/span>\r\nGeneral statistics:<\/span>\r\n \u00a0  total time: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  300.0629s<\/span>\r\n \u00a0  total number of events: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  41031<\/span>\r\n\u200b<\/span>\r\nLatency (ms):<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 min: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  6.62<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 avg: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  146.24<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 max: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  709.59<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 95th percentile: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  262.64<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 sum: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  6000331.95<\/span>\r\n\u200b<\/span>\r\nThreads fairness:<\/span>\r\n \u00a0  events (avg\/stddev): \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2051.5500\/16.35<\/span>\r\n \u00a0  execution time (avg\/stddev): \u00a0 300.0166\/0.02<\/span><\/pre>\n
          \n
          1.2.3 \u7b2c\u4e09\u6b21\u6267\u884c100w\u6b21\u8bfb\u5199 <\/span><\/h6>\n
          \u8fd8\u662f\u8fd9\u6761\u547d\u4ee4\uff0c\u518d\u6b21\u6267\u884c\u770b\u4e0b\uff1a<\/span><\/p>\n
          sysbench --db-driver<\/span>=<\/span>mysql --mysql-host<\/span>=<\/span>localhost --mysql-port<\/span>=<\/span>3306<\/span> --mysql-user<\/span>=<\/span>root --mysql-password<\/span>=<\/span>1qaz@WSX --mysql-db<\/span>=<\/span>sbtest --table_size<\/span>=<\/span>1000000<\/span> --tables<\/span>=<\/span>10<\/span> --events<\/span>=<\/span>0<\/span> --time<\/span>=<\/span>300<\/span> \u00a0--threads<\/span>=<\/span>20<\/span> --percentile<\/span>=<\/span>95<\/span> --report-interval<\/span>=<\/span>10<\/span> oltp_read_write run<\/span><\/pre>\n
          \u6700\u540e\u6267\u884c\u7ed3\u679c\u5982\u4e0b\uff1a<\/span><\/p>\n
          [root@VM_0_5_centos ~]# sysbench --db-driver=mysql --mysql-host=localhost --mysql-port=3306 --mysql-user=root --mysql-password=1qaz@WSX --mysql-db=sbtest --table_size=1000000 --tables=10 --events=0 --time=300  --threads=20 --percentile=95 --report-interval=10 oltp_read_write run<\/span>\r\nsysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)<\/span>\r\n\u200b<\/span>\r\nRunning the test with following options:<\/span>\r\nNumber of threads: 20<\/span>\r\nReport intermediate results every 10 second(s)<\/span>\r\nInitializing random number generator from current time<\/span>\r\n\u200b<\/span>\r\n\u200b<\/span>\r\nInitializing worker threads...<\/span>\r\n\u200b<\/span>\r\nThreads started!<\/span>\r\n\u200b<\/span>\r\n[ 10s ] thds: 20 tps: 137.99 qps: 2785.30 (r\/w\/o: 1953.79\/553.54\/277.97) lat (ms,95%): 253.35 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 20s ] thds: 20 tps: 139.98 qps: 2796.53 (r\/w\/o: 1955.64\/561.23\/279.66) lat (ms,95%): 257.95 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 30s ] thds: 20 tps: 135.89 qps: 2721.84 (r\/w\/o: 1905.59\/544.37\/271.88) lat (ms,95%): 257.95 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 40s ] thds: 20 tps: 143.80 qps: 2874.52 (r\/w\/o: 2013.41\/573.40\/287.70) lat (ms,95%): 257.95 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 50s ] thds: 20 tps: 141.73 qps: 2838.10 (r\/w\/o: 1986.65\/567.90\/283.55) lat (ms,95%): 277.21 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 60s ] thds: 20 tps: 142.10 qps: 2835.57 (r\/w\/o: 1984.28\/567.09\/284.20) lat (ms,95%): 248.83 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 70s ] thds: 20 tps: 141.93 qps: 2838.68 (r\/w\/o: 1987.87\/566.94\/283.87) lat (ms,95%): 267.41 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 80s ] thds: 20 tps: 142.27 qps: 2841.13 (r\/w\/o: 1987.20\/569.39\/284.54) lat (ms,95%): 244.38 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 90s ] thds: 20 tps: 144.78 qps: 2904.14 (r\/w\/o: 2034.24\/580.63\/289.27) lat (ms,95%): 231.53 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 100s ] thds: 20 tps: 141.03 qps: 2822.14 (r\/w\/o: 1977.08\/562.71\/282.35) lat (ms,95%): 257.95 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 110s ] thds: 20 tps: 138.68 qps: 2775.16 (r\/w\/o: 1941.56\/556.23\/277.37) lat (ms,95%): 257.95 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 120s ] thds: 20 tps: 140.70 qps: 2799.50 (r\/w\/o: 1957.90\/560.50\/281.10) lat (ms,95%): 257.95 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 130s ] thds: 20 tps: 142.10 qps: 2847.50 (r\/w\/o: 1994.40\/569.00\/284.10) lat (ms,95%): 257.95 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 140s ] thds: 20 tps: 142.10 qps: 2847.17 (r\/w\/o: 1994.18\/568.39\/284.60) lat (ms,95%): 267.41 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 150s ] thds: 20 tps: 141.69 qps: 2834.74 (r\/w\/o: 1983.99\/567.37\/283.38) lat (ms,95%): 240.02 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 160s ] thds: 20 tps: 142.69 qps: 2857.88 (r\/w\/o: 1999.55\/572.96\/285.38) lat (ms,95%): 257.95 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 170s ] thds: 20 tps: 148.01 qps: 2953.24 (r\/w\/o: 2067.20\/590.03\/296.01) lat (ms,95%): 244.38 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 180s ] thds: 20 tps: 142.16 qps: 2845.84 (r\/w\/o: 1993.50\/568.03\/284.31) lat (ms,95%): 257.95 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 190s ] thds: 20 tps: 141.93 qps: 2838.87 (r\/w\/o: 1987.80\/567.21\/283.86) lat (ms,95%): 262.64 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 200s ] thds: 20 tps: 137.03 qps: 2742.24 (r\/w\/o: 1919.74\/548.43\/274.06) lat (ms,95%): 267.41 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 210s ] thds: 20 tps: 141.14 qps: 2822.53 (r\/w\/o: 1975.28\/564.97\/282.28) lat (ms,95%): 253.35 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 220s ] thds: 20 tps: 143.06 qps: 2859.26 (r\/w\/o: 2001.71\/571.43\/286.12) lat (ms,95%): 257.95 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 230s ] thds: 20 tps: 145.89 qps: 2911.60 (r\/w\/o: 2036.39\/583.54\/291.67) lat (ms,95%): 248.83 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 240s ] thds: 20 tps: 142.86 qps: 2862.32 (r\/w\/o: 2003.09\/573.42\/285.81) lat (ms,95%): 244.38 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 250s ] thds: 20 tps: 142.36 qps: 2845.35 (r\/w\/o: 1992.70\/567.93\/284.71) lat (ms,95%): 248.83 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 260s ] thds: 20 tps: 140.64 qps: 2816.09 (r\/w\/o: 1971.96\/562.86\/281.28) lat (ms,95%): 267.41 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 270s ] thds: 20 tps: 143.49 qps: 2865.80 (r\/w\/o: 2004.86\/573.96\/286.98) lat (ms,95%): 282.25 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 280s ] thds: 20 tps: 145.81 qps: 2922.99 (r\/w\/o: 2047.60\/583.76\/291.63) lat (ms,95%): 253.35 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 290s ] thds: 20 tps: 142.26 qps: 2838.44 (r\/w\/o: 1985.40\/568.53\/284.51) lat (ms,95%): 253.35 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\n[ 300s ] thds: 20 tps: 137.89 qps: 2755.07 (r\/w\/o: 1928.14\/551.15\/275.78) lat (ms,95%): 253.35 err\/s: 0.00 reconn\/s: 0.00<\/span>\r\nSQL statistics:<\/span>\r\n \u00a0  queries performed:<\/span>\r\n \u00a0 \u00a0 \u00a0  read: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  595840<\/span>\r\n \u00a0 \u00a0 \u00a0  write: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 170240<\/span>\r\n \u00a0 \u00a0 \u00a0  other: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 85120<\/span>\r\n \u00a0 \u00a0 \u00a0  total: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 851200<\/span>\r\n \u00a0  transactions: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  42560  (141.79 per sec.)<\/span>\r\n \u00a0  queries: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 851200 (2835.86 per sec.)<\/span>\r\n \u00a0  ignored errors: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  0 \u00a0 \u00a0  (0.00 per sec.)<\/span>\r\n \u00a0  reconnects: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  0 \u00a0 \u00a0  (0.00 per sec.)<\/span>\r\n\u200b<\/span>\r\nGeneral statistics:<\/span>\r\n \u00a0  total time: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  300.1547s<\/span>\r\n \u00a0  total number of events: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  42560<\/span>\r\n\u200b<\/span>\r\nLatency (ms):<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 min: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  6.18<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 avg: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  141.02<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 max: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  687.11<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 95th percentile: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  257.95<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 sum: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  6001887.46<\/span>\r\n\u200b<\/span>\r\nThreads fairness:<\/span>\r\n \u00a0  events (avg\/stddev): \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2128.0000\/14.78<\/span>\r\n \u00a0  execution time (avg\/stddev): \u00a0 300.0944\/0.03<\/span><\/pre>\n
          \n
          1.3 \u6e05\u7406\u6570\u636e<\/span><\/h5>\n
          \u4f7f\u7528\u5982\u4e0b\u547d\u4ee4\u6e05\u7406\u6570\u636e<\/span><\/p>\n
          sysbench --db-driver<\/span>=<\/span>mysql --mysql-host<\/span>=<\/span>localhost --mysql-port<\/span>=<\/span>3306<\/span> --mysql-user<\/span>=<\/span>root --mysql-password<\/span>=<\/span>1qaz@WSX --mysql-db<\/span>=<\/span>sbtest --table_size<\/span>=<\/span>1000000<\/span> --tables<\/span>=<\/span>10<\/span> --events<\/span>=<\/span>0<\/span> --time<\/span>=<\/span>300<\/span> \u00a0 --threads<\/span>=<\/span>20<\/span> --percentile<\/span>=<\/span>95<\/span> oltp_read_write cleanup<\/span><\/pre>\n
          \n
          2. \u6d4b\u8bd5myisam 100w\u6761\u8bb0\u5f55\u7684\u8bfb\u5199\u6027\u80fd<\/span><\/h4>\n
          2.1 \u751f\u6210100w\u6570\u636e<\/span><\/h5>\n
          \u4f7f\u7528<\/span><\/p>\n
          sysbench --db-driver<\/span>=<\/span>mysql --mysql-host<\/span>=<\/span>localhost --mysql-port<\/span>=<\/span>3306<\/span> --mysql-user<\/span>=<\/span>root --mysql-password<\/span>=<\/span>1qaz@WSX --mysql-db<\/span>=<\/span>sbtest --table_size<\/span>=<\/span>1000000<\/span> --tables<\/span>=<\/span>10<\/span> --events<\/span>=<\/span>0<\/span> --time<\/span>=<\/span>300<\/span> \u00a0--threads<\/span>=<\/span>20<\/span>  oltp_read_write help<\/span><\/pre>\n
          \u53ef\u4ee5\u770b\u5230oltp_read_write\u811a\u672c\u6240\u652f\u6301\u7684\u53c2\u6570\uff0c\u5982\u4e0b\u6240\u793a\uff1a<\/span><\/p>\n
          [root@VM_0_5_centos ~]# sysbench --db-driver=mysql --mysql-host=localhost --mysql-port=3306 --mysql-user=root --mysql-password=1qaz@WSX --mysql-db=sbtest --table_size=1000000 --tables=10 --events=0 --time=300  --threads=20  oltp_read_write help<\/span><\/span>\r\nsysbench 1<\/span>.0.20 (using bundled LuaJIT 2<\/span>.1.0-beta2)<\/span>\r\n\u200b<\/span>\r\noltp_read_write options:<\/span>\r\n \u00a0--auto_inc<\/span>[=<\/span>on|off] \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Use AUTO_INCREMENT column as Primary Key (for MySQL), or its alternatives in<\/span> other DBMS. When disabled, use client-generated IDs [on]<\/span>\r\n \u00a0--create_secondary<\/span>[=<\/span>on|off] \u00a0 Create a secondary index in<\/span> addition to the PRIMARY KEY [on]<\/span>\r\n \u00a0--delete_inserts<\/span>=<\/span>N \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  Number of DELETE\/INSERT combinations per transaction [1]<\/span>\r\n \u00a0--distinct_ranges<\/span>=<\/span>N \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Number of SELECT DISTINCT queries per transaction [1]<\/span>\r\n \u00a0--index_updates<\/span>=<\/span>N \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Number of UPDATE index queries per transaction [1]<\/span>\r\n \u00a0--mysql_storage_engine<\/span>=<\/span>STRING Storage engine, if<\/span> MySQL is used [innodb]<\/span>\r\n \u00a0--non_index_updates<\/span>=<\/span>N \u00a0 \u00a0 \u00a0 \u00a0 Number of UPDATE non-index queries per transaction [1]<\/span>\r\n \u00a0--order_ranges<\/span>=<\/span>N \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  Number of SELECT ORDER BY queries per transaction [1]<\/span>\r\n \u00a0--pgsql_variant<\/span>=<\/span>STRING \u00a0 \u00a0 \u00a0  Use this PostgreSQL variant when running with the PostgreSQL driver. The only currently supported variant is 'redshift'<\/span>. When enabled, create_secondary is automatically disabled, and delete_inserts is set<\/span> to 0<\/span><\/span>\r\n \u00a0--point_selects<\/span>=<\/span>N \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Number of point SELECT queries per transaction [10]<\/span>\r\n \u00a0--range_selects<\/span>[=<\/span>on|off] \u00a0 \u00a0  Enable\/disable all range SELECT queries [on]<\/span>\r\n \u00a0--range_size<\/span>=<\/span>N \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  Range size for<\/span> range SELECT queries [100]<\/span>\r\n \u00a0--secondary<\/span>[=<\/span>on|off] \u00a0 \u00a0 \u00a0 \u00a0  Use a secondary index in<\/span> place of the PRIMARY KEY [off]<\/span>\r\n \u00a0--simple_ranges<\/span>=<\/span>N \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Number of simple range SELECT queries per transaction [1]<\/span>\r\n \u00a0--skip_trx<\/span>[=<\/span>on|off] \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 Don't start explicit transactions and execute all queries in the AUTOCOMMIT mode [off]<\/span><\/span>\r\n \u00a0--sum_ranges<\/span>=<\/span>N \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  Number of SELECT SUM() queries per transaction [1]<\/span>\r\n \u00a0--table_size<\/span>=<\/span>N \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  Number of rows per table [10000]<\/span>\r\n \u00a0--tables<\/span>=<\/span>N \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  Number of tables [1]<\/span><\/pre>\n
          \u6b64\u5904\u6211\u4eec\u6307\u5b9a\u4e0b\u6570\u636e\u5e93\u5b58\u50a8\u5f15\u64ce\u4e3amyisam\uff0c\u6267\u884c\uff1a<\/span><\/p>\n
          sysbench --db-driver=mysql --mysql-host=localhost --mysql-port=3306 --mysql-user=root --mysql-password=1qaz@WSX --mysql-db=sbtest --table_size=1000000 --tables=10 --events=0 --time=300  --threads=20  oltp_read_write --mysql_storage_engine=myisam prepare<\/span><\/pre>\n
          \u5373\u53ef\u521b\u5efaMyIsam\u7684\u8868\u3002<\/span><\/p>\n
          2.2 \u8fdb\u884c\u8bfb\u5199\u6d4b\u8bd5<\/span><\/h5>\n
          2.2.1 \u7b2c\u4e00\u6b21\u6267\u884c100w\u6b21\u8bfb\u5199<\/span><\/h6>\n
          \u6267\u884c\u547d\u4ee4<\/span><\/p>\n
          sysbench --db-driver<\/span>=<\/span>mysql --mysql-host<\/span>=<\/span>localhost --mysql-port<\/span>=<\/span>3306<\/span> --mysql-user<\/span>=<\/span>root --mysql-password<\/span>=<\/span>1qaz@WSX --mysql-db<\/span>=<\/span>sbtest --table_size<\/span>=<\/span>1000000<\/span> --tables<\/span>=<\/span>10<\/span> --events<\/span>=<\/span>0<\/span> --time<\/span>=<\/span>300<\/span> \u00a0--threads<\/span>=<\/span>20<\/span> --percentile<\/span>=<\/span>95<\/span> --report-interval<\/span>=<\/span>10<\/span> oltp_read_write \u00a0 --mysql_storage_engine<\/span>=<\/span>myisam run<\/span><\/pre>\n
          \u6d4b\u8bd5\u7ed3\u679c\u5982\u4e0b\uff1a<\/span><\/p>\n
          ......<\/span>\r\nSQL statistics:<\/span>\r\n \u00a0  queries performed:<\/span>\r\n \u00a0 \u00a0 \u00a0  read: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  722036<\/span>\r\n \u00a0 \u00a0 \u00a0  write: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 206294<\/span>\r\n \u00a0 \u00a0 \u00a0  other: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 103150<\/span>\r\n \u00a0 \u00a0 \u00a0  total: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1031480<\/span>\r\n \u00a0  transactions: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  51574  (171.84 per sec.)<\/span>\r\n \u00a0  queries: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 1031480 (3436.86 per sec.)<\/span>\r\n \u00a0  ignored errors: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  0 \u00a0 \u00a0  (0.00 per sec.)<\/span>\r\n \u00a0  reconnects: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  0 \u00a0 \u00a0  (0.00 per sec.)<\/span>\r\n\u200b<\/span>\r\nGeneral statistics:<\/span>\r\n \u00a0  total time: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  300.1224s<\/span>\r\n \u00a0  total number of events: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  51574<\/span>\r\n\u200b<\/span>\r\nLatency (ms):<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 min: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  2.91<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 avg: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  116.36<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 max: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2703.01<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 95th percentile: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  153.02<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 sum: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  6001171.45<\/span>\r\n\u200b<\/span>\r\nThreads fairness:<\/span>\r\n \u00a0  events (avg\/stddev): \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2578.7000\/7.62<\/span>\r\n \u00a0  execution time (avg\/stddev): \u00a0 300.0586\/0.04<\/span><\/pre>\n
          \n
          2.2.2 \u7b2c\u4e8c\u6b21\u6267\u884c100w\u6b21\u8bfb\u5199<\/span><\/h6>\n
          \u76f8\u540c\u547d\u4ee4\uff0c\u518d\u6765\u4e00\u6b21\uff1a<\/span><\/p>\n
          ......<\/span>\r\nSQL statistics:<\/span>\r\n \u00a0  queries performed:<\/span>\r\n \u00a0 \u00a0 \u00a0  read: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  697480<\/span>\r\n \u00a0 \u00a0 \u00a0  write: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 199279<\/span>\r\n \u00a0 \u00a0 \u00a0  other: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 99641<\/span>\r\n \u00a0 \u00a0 \u00a0  total: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 996400<\/span>\r\n \u00a0  transactions: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  49820  (165.95 per sec.)<\/span>\r\n \u00a0  queries: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 996400 (3319.08 per sec.)<\/span>\r\n \u00a0  ignored errors: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  0 \u00a0 \u00a0  (0.00 per sec.)<\/span>\r\n \u00a0  reconnects: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  0 \u00a0 \u00a0  (0.00 per sec.)<\/span>\r\n\u200b<\/span>\r\nGeneral statistics:<\/span>\r\n \u00a0  total time: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  300.2032s<\/span>\r\n \u00a0  total number of events: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  49820<\/span>\r\n\u200b<\/span>\r\nLatency (ms):<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 min: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  2.86<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 avg: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  120.45<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 max: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 3435.92<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 95th percentile: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  176.73<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 sum: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  6000916.19<\/span>\r\n\u200b<\/span>\r\nThreads fairness:<\/span>\r\n \u00a0  events (avg\/stddev): \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2491.0000\/9.31<\/span>\r\n \u00a0  execution time (avg\/stddev): \u00a0 300.0458\/0.06<\/span><\/pre>\n
          \n
          \n
          2.2.3 \u7b2c\u4e09\u6b21\u6267\u884c100w\u6b21\u8bfb\u5199 <\/span><\/h6>\n
          \n
          \u00b7\u00b7\u00b7\u00b7\u00b7\u00b7<\/span>\r\nSQL statistics:<\/span>\r\n \u00a0  queries performed:<\/span>\r\n \u00a0 \u00a0 \u00a0  read: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  680372<\/span>\r\n \u00a0 \u00a0 \u00a0  write: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 194389<\/span>\r\n \u00a0 \u00a0 \u00a0  other: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 97199<\/span>\r\n \u00a0 \u00a0 \u00a0  total: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 971960<\/span>\r\n \u00a0  transactions: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  48598  (161.84 per sec.)<\/span>\r\n \u00a0  queries: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 971960 (3236.88 per sec.)<\/span>\r\n \u00a0  ignored errors: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  0 \u00a0 \u00a0  (0.00 per sec.)<\/span>\r\n \u00a0  reconnects: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  0 \u00a0 \u00a0  (0.00 per sec.)<\/span>\r\n\u200b<\/span>\r\nGeneral statistics:<\/span>\r\n \u00a0  total time: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  300.2761s<\/span>\r\n \u00a0  total number of events: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  48598<\/span>\r\n\u200b<\/span>\r\nLatency (ms):<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 min: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  2.88<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 avg: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  123.52<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 max: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2916.81<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 95th percentile: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  189.93<\/span>\r\n \u00a0 \u00a0 \u00a0 \u00a0 sum: \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0  6002904.07<\/span>\r\n\u200b<\/span>\r\nThreads fairness:<\/span>\r\n \u00a0  events (avg\/stddev): \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2429.9000\/10.74<\/span>\r\n \u00a0  execution time (avg\/stddev): \u00a0 300.1452\/0.07<\/span><\/pre>\n
          \n
          2.3 \u6e05\u7406\u6570\u636e<\/span><\/h5>\n
          sysbench --db-driver<\/span>=<\/span>mysql --mysql-host<\/span>=<\/span>localhost --mysql-port<\/span>=<\/span>3306<\/span> --mysql-user<\/span>=<\/span>root --mysql-password<\/span>=<\/span>1qaz@WSX --mysql-db<\/span>=<\/span>sbtest --table_size<\/span>=<\/span>1000000<\/span> --tables<\/span>=<\/span>10<\/span> --events<\/span>=<\/span>0<\/span> --time<\/span>=<\/span>300<\/span> \u00a0--threads<\/span>=<\/span>20<\/span>  oltp_read_write cleanup<\/span><\/pre>\n
          \n
          \u6d4b\u8bd5\u603b\u7ed3<\/span><\/h2>\n
          \n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
          <\/th>\n\u538b\u6d4b\u6307\u6807<\/span><\/span><\/th>\nInnoDB<\/span><\/span><\/th>\nMyISAM<\/span><\/span><\/th>\n<\/tr>\n<\/thead>\n
          \u7b2c\u4e00\u6b21<\/span><\/span><\/td>\n\u8bfb\u3001\u5199\u6b21\u6570<\/span><\/span><\/td>\n\u8bfb\uff1a527282<\/span> \u5199\uff1a150652<\/span> \u5176\u4ed6\uff1a75326<\/span> \u4e8b\u52a1\uff1a37663<\/span> \u603b\u8ba1\uff1a753260<\/span><\/span><\/td>\n\u8bfb\uff1a722036<\/span> \u5199\uff1a206294<\/span> \u5176\u4ed6\uff1a103150<\/span> \u603b\u8ba1\uff1a1031480<\/span><\/span><\/td>\n<\/tr>\n
          <\/td>\n\u8017\u65f6<\/span><\/span><\/td>\n\u6700\u5c0f\uff1a7.13ms<\/span> \u5e73\u5747\uff1a159.35ms<\/span> \u6700\u5927\uff1a873.88ms<\/span> 95\u5206\u4f4d\u6570\uff1a292.60ms<\/span><\/span><\/td>\n\u6700\u5c0f\uff1a2.91ms<\/span> \u5e73\u5747\uff1a116.36ms<\/span> \u6700\u5927\uff1a2703.01ms<\/span> 95\u5206\u4f4d\u6570\uff1a153.02ms<\/span><\/span><\/td>\n<\/tr>\n
          <\/td>\n\u541e\u5410\u91cf<\/span><\/span><\/td>\n1883.1500<\/span><\/span><\/td>\n2578.7000<\/span><\/span><\/td>\n<\/tr>\n
          \u7b2c\u4e8c\u6b21<\/span><\/span><\/td>\n\u8bfb\u3001\u5199\u6b21\u6570<\/span><\/span><\/td>\n\u8bfb\uff1a574434<\/span> \u5199\uff1a164124<\/span> \u5176\u4ed6\uff1a82062<\/span> \u4e8b\u52a1\uff1a41031<\/span> \u603b\u8ba1\uff1a820620<\/span><\/span><\/td>\n\u8bfb\uff1a697480<\/span> \u5199\uff1a199279<\/span> \u5176\u4ed6\uff1a99641<\/span> \u603b\u8ba1\uff1a996400<\/span><\/span><\/td>\n<\/tr>\n
          <\/td>\n\u8017\u65f6<\/span><\/span><\/td>\n\u6700\u5c0f\uff1a6.62ms<\/span> \u5e73\u5747\uff1a146.24ms<\/span> \u6700\u5927\uff1a709.59ms<\/span> 95\u5206\u4f4d\u6570\uff1a262.64ms<\/span><\/span><\/td>\n\u6700\u5c0f\uff1a2.86ms<\/span> \u5e73\u5747\uff1a120.45ms<\/span> \u6700\u5927\uff1a3435.92ms<\/span> 95\u5206\u4f4d\u6570\uff1a176.73ms<\/span><\/span><\/td>\n<\/tr>\n
          <\/td>\n\u541e\u5410\u91cf<\/span><\/span><\/td>\n2051.5500<\/span><\/span><\/td>\n2491.0000<\/span><\/span><\/td>\n<\/tr>\n
          \u7b2c\u4e09\u6b21<\/span><\/span><\/td>\n\u8bfb\u3001\u5199\u6b21\u6570<\/span><\/span><\/td>\n\u8bfb\uff1a595840<\/span> \u5199\uff1a170240<\/span> \u5176\u4ed6\uff1a85120<\/span> \u4e8b\u52a1\uff1a42560<\/span> \u603b\u8ba1\uff1a851200<\/span><\/span><\/td>\n\u8bfb\uff1a680372<\/span> \u5199\uff1a194389<\/span> \u5176\u4ed6\uff1a97199<\/span> \u603b\u8ba1\uff1a971960<\/span><\/span><\/td>\n<\/tr>\n
          <\/td>\n\u8017\u65f6<\/span><\/span><\/td>\n\u6700\u5c0f\uff1a6.18ms<\/span> \u5e73\u5747\uff1a141.02ms<\/span> \u6700\u5927\uff1a687.11ms<\/span> 95\u5206\u4f4d\u6570\uff1a257.95ms<\/span><\/span><\/td>\n\u6700\u5c0f\uff1a2.88ms<\/span> \u5e73\u5747\uff1a123.52ms<\/span> \u6700\u5927\uff1a2916.81ms<\/span> 95\u5206\u4f4d\u6570\uff1a189.93ms<\/span><\/span><\/td>\n<\/tr>\n
          <\/td>\n\u541e\u5410\u91cf<\/span><\/span><\/td>\n2128.0000<\/span><\/span><\/td>\n2429.9000<\/span><\/span><\/td>\n<\/tr>\n
          <\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/figure>\n
          \u5206\u6790<\/span><\/h3>\n
          \u7eb5\u5411\u5bf9\u6bd4<\/span><\/h4>\n
          \u7ecf\u8fc7\u9884\u70ed\u4e4b\u540e\uff0c\u53ef\u4ee5\u770b\u5230InnoDB\u7684\u6027\u80fd\u8d8a\u6765\u8d8a\u597d\uff0c\u6bcf\u79d2\u80fd\u5904\u74062000\u591a\u8bf7\u6c42\u3002\u4e0d\u6392\u9664\u9884\u70ed\u5145\u5206\u540e\u80fd\u53cd\u8d85MyISAM\u7684\u53ef\u80fd\u6027\uff0c\u4e0d\u8fc7\u8fd9\u4e2a\u6211\u5c31\u6ca1\u7ee7\u7eed\u591a\u6d4b\u8bd5\u4e86\u3002<\/span><\/p>\n
          MyISAM\u6bcf\u79d2\u80fd\u5904\u74062500\u5de6\u53f3\u3002<\/span><\/p>\n
          \u6a2a\u5411\u5bf9\u6bd4<\/span><\/h4>\n
          \u4ece\u76ee\u524d\u505a\u7684\u6d4b\u8bd5\u6765\u770b\uff0cInnoDB\u5728\u8bfb\u5199\u6027\u80fd\u4e0a\u8fd8\u662f\u4e0d\u53caMyISAM\uff0c\u4e0d\u6392\u9664\u9884\u70ed\u5145\u5206\u540e\u80fd\u53cd\u8d85MyISAM\u7684\u53ef\u80fd\u6027\uff0c\u4e0d\u8fc7\u8fd9\u4e2a\u6211\u5c31\u6ca1\u7ee7\u7eed\u591a\u6d4b\u8bd5\u4e86\u3002<\/span><\/p>\n
          \u5176\u4ed6<\/span><\/h2>\n
          \u56fe\u5f62\u5316<\/span><\/h3>\n
          \u53ef\u4ee5\u5c06sysbench\u538b\u6d4b\u7ed3\u679c\u8f93\u51fa\u65e5\u5fd7\u3001\u7136\u540e\u7ed8\u5236\u6210\u56fe\u7247\uff0c\u8fd9\u6837\u770b\u7740\u66f4\u9ad8\u5927\u4e0a\u3001\u66f4\u52a0\u76f4\u89c2\u3002\u53ef\u4ee5\u53c2\u8003\u8fd9\u7bc7\u6587\u7ae0\uff1a<\/span>https:\/\/yq.aliyun.com\/articles\/498680<\/a><\/span><\/p>\n
          \n
          \u9047\u5230\u7684\u95ee\u9898<\/span><\/h2>\n
            \n
          1. \n
            \u672c\u6765\u60f3\u4f7f\u7528sysbench\u7684\u9884\u70ed\u529f\u80fd\uff0c\u4f7f\u7528\u5982\u4e0b\u547d\u4ee4<\/span><\/p>\n<\/li>\n<\/ol>\n
            sysbench --db-driver=mysql --mysql-host=localhost --mysql-port=3306 --mysql-user=root --mysql-password=1qaz@WSX --mysql-db=sbtest --table_size=1000000 --tables=10 --events=0 --time=300  --threads=20 --percentile=95 --report-interval=10 oltp_read_write prewarm<\/span><\/pre>\n
            \u4f46\u6709\u62a5\u5982\u4e0b\u9519\u8bef\uff0c\u65f6\u95f4\u6709\u9650\uff0c\u6ca1\u4ed4\u7ec6\u6392\u67e5\uff1a<\/span><\/p>\n
            [root@VM_0_5_centos ~]# sysbench --db-driver=mysql --mysql-host=localhost --mysql-port=3306 --mysql-user=root --mysql-password=1qaz@WSX --mysql-db=sbtest --table_size=1000000 --tables=10 --events=0 --time=300  --threads=20 --percentile=95 --report-interval=10 oltp_read_write prewarm<\/span>\r\nsysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2)<\/span>\r\n\u200b<\/span>\r\nInitializing worker threads...<\/span>\r\n\u200b<\/span>\r\nPrewarming table sbtest6<\/span>\r\nPrewarming table sbtest7<\/span>\r\nPrewarming table sbtest9<\/span>\r\nPrewarming table sbtest8<\/span>\r\nPrewarming table sbtest1<\/span>\r\nPrewarming table sbtest5<\/span>\r\nPrewarming table sbtest3<\/span>\r\nPrewarming table sbtest10<\/span>\r\nPrewarming table sbtest2<\/span>\r\nPrewarming table sbtest4<\/span>\r\nFATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'SELECT AVG(id) FROM (SELECT * FROM sbtest2 FORCE KEY (PRIMARY) LIMIT 1000000) t'<\/span>\r\nFATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'SELECT AVG(id) FROM (SELECT * FROM sbtest3 FORCE KEY (PRIMARY) LIMIT 1000000) t'<\/span>\r\nFATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'SELECT AVG(id) FROM (SELECT * FROM sbtest4 FORCE KEY (PRIMARY) LIMIT 1000000) t'<\/span>\r\nFATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'SELECT AVG(id) FROM (SELECT * FROM sbtest5 FORCE KEY (PRIMARY) LIMIT 1000000) t'<\/span>\r\nFATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'SELECT AVG(id) FROM (SELECT * FROM sbtest6 FORCE KEY (PRIMARY) LIMIT 1000000) t'<\/span>\r\nFATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'SELECT AVG(id) FROM (SELECT * FROM sbtest7 FORCE KEY (PRIMARY) LIMIT 1000000) t'<\/span>\r\nFATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'SELECT AVG(id) FROM (SELECT * FROM sbtest8 FORCE KEY (PRIMARY) LIMIT 1000000) t'<\/span>\r\nFATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'SELECT AVG(id) FROM (SELECT * FROM sbtest9 FORCE KEY (PRIMARY) LIMIT 1000000) t'<\/span>\r\nFATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'SELECT AVG(id) FROM (SELECT * FROM sbtest10 FORCE KEY (PRIMARY) LIMIT 1000000) t'<\/span>\r\nFATAL: mysql_drv_query() returned error 2013 (Lost connection to MySQL server during query) for query 'SELECT AVG(id) FROM (SELECT * FROM sbtest1 FORCE KEY (PRIMARY) LIMIT 1000000) t'<\/span>\r\nFATAL: `sysbench.cmdline.call_command' function failed: \/usr\/share\/sysbench\/oltp_common.lua:111: SQL error, errno = 2013, state = 'HY000': Lost connection to MySQL server during query<\/span><\/pre>\n","protected":false},"excerpt":{"rendered":"
            \u6d4b\u8bd5\u73af\u5883\u8bf4\u660e \u786c\u4ef6 \u817e\u8baf\u4e91\u6807\u51c6\u578bSA2 1\u6838 2GB 1Mbps \u7cfb\u7edf\u76d8\uff1a\u9ad8\u6027\u80fd\u4e91\u786c\u76d8(50G)<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[63],"tags":[64,112],"_links":{"self":[{"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/posts\/915"}],"collection":[{"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=915"}],"version-history":[{"count":1,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/posts\/915\/revisions"}],"predecessor-version":[{"id":916,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=\/wp\/v2\/posts\/915\/revisions\/916"}],"wp:attachment":[{"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=915"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=915"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/prayerlaputa.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=915"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}