|
|
|
数据库有138.6MB，每天IP在一万左右。
这是我服务器上运行sysbench的基准测试结果
sysbench --mysql-host=127.0.0.1 --mysql-port=3306 --mysql-user=root --mysql-password=******* --db-driver=mysql --mysql-db=tester /usr/share/sysbench/oltp_read_write.lua --threads=16 --time=300 --report-interval=10 --rand-type=uniform run
- Running the test with following options:Number of threads: 16Report intermediate results every 10 second(s)Initializing random number generator from current timeInitializing worker threads...Threads started![ 10s ] thds: 16 tps: 424.68 qps: 8523.91 (r/w/o: 5967.93/1705.02/850.96) lat (ms,95%): 63.32 err/s: 0.00 reconn/s: 0.00[ 20s ] thds: 16 tps: 486.12 qps: 9714.14 (r/w/o: 6802.71/1939.19/972.24) lat (ms,95%): 53.85 err/s: 0.00 reconn/s: 0.00[ 30s ] thds: 16 tps: 489.99 qps: 9802.81 (r/w/o: 6860.17/1962.76/979.88) lat (ms,95%): 51.94 err/s: 0.00 reconn/s: 0.00[ 40s ] thds: 16 tps: 463.25 qps: 9262.09 (r/w/o: 6485.30/1850.20/926.60) lat (ms,95%): 59.99 err/s: 0.00 reconn/s: 0.00[ 50s ] thds: 16 tps: 498.09 qps: 9963.95 (r/w/o: 6973.00/1994.77/996.19) lat (ms,95%): 56.84 err/s: 0.00 reconn/s: 0.00[ 60s ] thds: 16 tps: 513.21 qps: 10260.97 (r/w/o: 7184.02/2050.53/1026.42) lat (ms,95%): 51.94 err/s: 0.00 reconn/s: 0.00[ 70s ] thds: 16 tps: 487.40 qps: 9757.41 (r/w/o: 6827.70/1954.90/974.80) lat (ms,95%): 54.83 err/s: 0.00 reconn/s: 0.00[ 80s ] thds: 16 tps: 486.20 qps: 9723.49 (r/w/o: 6806.69/1944.40/972.40) lat (ms,95%): 54.83 err/s: 0.00 reconn/s: 0.00[ 90s ] thds: 16 tps: 490.20 qps: 9799.90 (r/w/o: 6861.10/1958.40/980.40) lat (ms,95%): 52.89 err/s: 0.00 reconn/s: 0.00[ 100s ] thds: 16 tps: 476.20 qps: 9523.73 (r/w/o: 6667.12/1904.21/952.40) lat (ms,95%): 53.85 err/s: 0.00 reconn/s: 0.00[ 110s ] thds: 16 tps: 476.40 qps: 9528.19 (r/w/o: 6668.79/1906.60/952.80) lat (ms,95%): 52.89 err/s: 0.00 reconn/s: 0.00[ 120s ] thds: 16 tps: 479.50 qps: 9591.53 (r/w/o: 6714.32/1918.21/959.00) lat (ms,95%): 51.94 err/s: 0.00 reconn/s: 0.00[ 130s ] thds: 16 tps: 452.90 qps: 9050.57 (r/w/o: 6335.78/1808.99/905.80) lat (ms,95%): 55.82 err/s: 0.00 reconn/s: 0.00[ 140s ] thds: 16 tps: 497.79 qps: 9954.25 (r/w/o: 6966.72/1991.95/995.57) lat (ms,95%): 50.11 err/s: 0.00 reconn/s: 0.00[ 150s ] thds: 16 tps: 468.91 qps: 9377.60 (r/w/o: 6564.44/1875.44/937.72) lat (ms,95%): 55.82 err/s: 0.00 reconn/s: 0.00[ 160s ] thds: 16 tps: 500.80 qps: 10022.50 (r/w/o: 7017.60/2003.20/1001.70) lat (ms,95%): 51.94 err/s: 0.00 reconn/s: 0.00[ 170s ] thds: 16 tps: 502.89 qps: 10064.04 (r/w/o: 7042.49/2015.77/1005.78) lat (ms,95%): 51.94 err/s: 0.00 reconn/s: 0.00[ 180s ] thds: 16 tps: 466.17 qps: 9313.34 (r/w/o: 6519.34/1861.87/932.13) lat (ms,95%): 55.82 err/s: 0.00 reconn/s: 0.00[ 190s ] thds: 16 tps: 445.04 qps: 8902.41 (r/w/o: 6231.37/1780.96/890.08) lat (ms,95%): 58.92 err/s: 0.00 reconn/s: 0.00[ 200s ] thds: 16 tps: 477.40 qps: 9553.84 (r/w/o: 6689.13/1909.71/955.00) lat (ms,95%): 53.85 err/s: 0.00 reconn/s: 0.00[ 210s ] thds: 16 tps: 472.20 qps: 9440.07 (r/w/o: 6609.78/1885.89/944.40) lat (ms,95%): 59.99 err/s: 0.00 reconn/s: 0.00[ 220s ] thds: 16 tps: 489.76 qps: 9793.17 (r/w/o: 6854.42/1959.23/979.52) lat (ms,95%): 50.11 err/s: 0.00 reconn/s: 0.00[ 230s ] thds: 16 tps: 509.34 qps: 10184.57 (r/w/o: 7128.21/2037.67/1018.69) lat (ms,95%): 51.94 err/s: 0.00 reconn/s: 0.00[ 240s ] thds: 16 tps: 511.10 qps: 10225.00 (r/w/o: 7158.60/2044.20/1022.20) lat (ms,95%): 50.11 err/s: 0.00 reconn/s: 0.00[ 250s ] thds: 16 tps: 483.50 qps: 9666.71 (r/w/o: 6766.31/1933.40/967.00) lat (ms,95%): 52.89 err/s: 0.00 reconn/s: 0.00[ 260s ] thds: 16 tps: 519.80 qps: 10398.89 (r/w/o: 7277.79/2081.50/1039.60) lat (ms,95%): 49.21 err/s: 0.00 reconn/s: 0.00[ 270s ] thds: 16 tps: 464.40 qps: 9280.75 (r/w/o: 6497.93/1854.01/928.80) lat (ms,95%): 56.84 err/s: 0.00 reconn/s: 0.00[ 280s ] thds: 16 tps: 484.19 qps: 9685.49 (r/w/o: 6779.96/1937.16/968.38) lat (ms,95%): 52.89 err/s: 0.00 reconn/s: 0.00[ 290s ] thds: 16 tps: 464.61 qps: 9292.12 (r/w/o: 6504.38/1858.62/929.11) lat (ms,95%): 56.84 err/s: 0.00 reconn/s: 0.00[ 300s ] thds: 16 tps: 464.80 qps: 9305.17 (r/w/o: 6513.68/1861.79/929.70) lat (ms,95%): 56.84 err/s: 0.00 reconn/s: 0.00SQL statistics: queries performed: read: 2022818 write: 577948 other: 288974 total: 2889740 transactions: 144487 (481.57 per sec.) queries: 2889740 (9631.36 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.)General statistics: total time: 300.0333s total number of events: 144487Latency (ms): min: 5.51 avg: 33.22 max: 240.93 95th percentile: 54.83 sum: 4799864.43Threads fairness: events (avg/stddev): 9030.4375/39.43 execution time (avg/stddev): 299.9915/0.01
|
|
发表于 2023-6-28 08:52:33
