已经安装好sysbench
查看安装情况
scutech@infokist:~$ dpkg -l|grep sysbench ii sysbench 1.0.20-1 amd64 Scriptable database and system performance benchmark $ sysbench --help ...... pgsql options: --pgsql-host=STRING PostgreSQL server host [localhost] --pgsql-port=N PostgreSQL server port [5432] --pgsql-user=STRING PostgreSQL user [sbtest] --pgsql-password=STRING PostgreSQL password [] --pgsql-db=STRING PostgreSQL database name [sbtest] ....
造数据
造数据
scutech@infokist:~$ sysbench --db-driver=pgsql --pgsql-host=192.168.17.40 --pgsql-user=scutech --pgsql-password=dingjia \ > --pgsql-db=postgres --oltp-table-size=10000 --rand-init=on --threads=10 --time=120 --events=0 \ > --report-interval=10 --percentile=99 /usr/share/sysbench/tests/include/oltp_legacy/oltp.lua prepare sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2) Creating table 'sbtest1'... Inserting 10000 records into 'sbtest1' Creating secondary indexes on 'sbtest1'...
清除数据
sysbench --db-driver=pgsql --pgsql-host=192.168.17.40 --pgsql-user=scutech --pgsql-password=dingjia \ --pgsql-db=postgres --oltp-table-size=10000 --rand-init=on --threads=10 --time=120 --events=0 \ --report-interval=10 --percentile=99 /usr/share/sysbench/tests/include/oltp_legacy/oltp.lua cleanup
检查表
psql -U scutech -h 192.168.17.40 -d postgres postgres=# select * FROM pg_tables where schemaname='public'; schemaname | tablename | tableowner | tablespace | hasindexes | hasrules | hastriggers | rowsecurity ------------+-----------+------------+------------+------------+----------+-------------+------------- public | sbtest1 | scutech | | t | f | f | f (1 row) postgres=# postgres=# select count(*) from sbtest1; count ------- 10000 (1 row)
测试
scutech@infokist:~$ sysbench --db-driver=pgsql --pgsql-host=192.168.17.40 --pgsql-port=5432 --pgsql-user=scutech --pgsql-password=dingjia --pgsql-db=mydb --oltp-table-size=10000 --threads=10 --time=120 --events=0 --report-interval=10 --percentile=99 /usr/share/sysbench/tests/include/oltp_legacy/oltp.lua run sysbench 1.0.20 (using bundled LuaJIT 2.1.0-beta2) Running the test with following options: Number of threads: 10 Report intermediate results every 10 second(s) Initializing random number generator from current time Initializing worker threads... Threads started! [ 10s ] thds: 10 tps: 300.40 qps: 6099.34 (r/w/o: 4278.15/1203.70/617.49) lat (ms,99%): 64.47 err/s: 4.40 reconn/s: 0.00 [ 20s ] thds: 10 tps: 256.33 qps: 5200.16 (r/w/o: 3646.09/1028.81/525.26) lat (ms,99%): 70.55 err/s: 4.00 reconn/s: 0.00 [ 30s ] thds: 10 tps: 245.79 qps: 4950.20 (r/w/o: 3467.29/980.74/502.17) lat (ms,99%): 669.89 err/s: 2.20 reconn/s: 0.00 [ 40s ] thds: 10 tps: 328.60 qps: 6646.79 (r/w/o: 4658.09/1315.00/673.70) lat (ms,99%): 57.87 err/s: 4.10 reconn/s: 0.00 [ 50s ] thds: 10 tps: 327.60 qps: 6634.91 (r/w/o: 4651.11/1312.30/671.50) lat (ms,99%): 57.87 err/s: 4.60 reconn/s: 0.00 [ 60s ] thds: 10 tps: 268.20 qps: 5438.79 (r/w/o: 3814.29/1074.10/550.40) lat (ms,99%): 116.80 err/s: 4.10 reconn/s: 0.00 [ 70s ] thds: 10 tps: 296.52 qps: 6004.58 (r/w/o: 4207.86/1190.07/606.64) lat (ms,99%): 61.08 err/s: 4.10 reconn/s: 0.00 [ 80s ] thds: 10 tps: 323.58 qps: 6563.00 (r/w/o: 4601.42/1297.02/664.56) lat (ms,99%): 59.99 err/s: 5.20 reconn/s: 0.00 [ 90s ] thds: 10 tps: 330.20 qps: 6679.35 (r/w/o: 4681.27/1321.39/676.70) lat (ms,99%): 57.87 err/s: 4.20 reconn/s: 0.00 [ 100s ] thds: 10 tps: 273.20 qps: 5515.64 (r/w/o: 3865.03/1091.11/559.50) lat (ms,99%): 64.47 err/s: 3.00 reconn/s: 0.00 [ 110s ] thds: 10 tps: 244.12 qps: 4950.41 (r/w/o: 3471.22/978.76/500.43) lat (ms,99%): 80.03 err/s: 3.60 reconn/s: 0.00 [ 120s ] thds: 10 tps: 234.88 qps: 4772.88 (r/w/o: 3347.70/942.52/482.66) lat (ms,99%): 87.56 err/s: 4.30 reconn/s: 0.00 SQL statistics: queries performed: read: 486976 write: 137398 other: 70325 total: 694699 transactions: 34306 (285.77 per sec.) queries: 694699 (5786.92 per sec.) ignored errors: 478 (3.98 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.0410s total number of events: 34306 Latency (ms): min: 18.69 avg: 34.98 max: 3026.66 99th percentile: 63.32 sum: 1200039.52 Threads fairness: events (avg/stddev): 3430.6000/22.74 execution time (avg/stddev): 120.0040/0.01 scutech@infokist:~$
