MySql Database 性能测试工具：tpcc-mysql
# cd /usr/local/src# yum install -y git
# git clone https://github.com/Percona-Lab/tpcc-mysql.git
Initialized empty Git repository in /usr/local/src/tpcc-mysql/.git/
remote: Counting objects: 392, done.
Receiving objects: 100% (392/392), 202.87 KiB | 70 KiB/s, done.
remote: Total 392 (delta 0), reused 0 (delta 0), pack-reused 392
Resolving deltas: 100% (216/216), done.
# cd tpcc-mysql/src
# make
# cd ..
# ll
total 280
-rw-r--r-- 1 root root 1621 Mar 12 01:47 add_fkey_idx.sql
-rw-r--r-- 1 root root 317 Mar 12 01:47 count.sql
-rw-r--r-- 1 root root 3105 Mar 12 01:47 create_table.sql
-rw-r--r-- 1 root root 194 Mar 12 01:47 Dockerfile
-rw-r--r-- 1 root root 763 Mar 12 01:47 drop_cons.sql
-rw-r--r-- 1 root root 1079 Mar 12 01:47 load_multi_schema.sh
-rw-r--r-- 1 root root 573 Mar 12 01:47 load.sh
-rw-r--r-- 1 root root 2302 Mar 12 01:47 README.md
drwxr-xr-x 2 root root 4096 Mar 12 01:47 schema2
drwxr-xr-x 5 root root 4096 Mar 12 01:47 scripts
drwxr-xr-x 2 root root 4096 Mar 12 01:47 src
-rwxr-xr-x 1 root root68304 Mar 12 01:47 tpcc_load
-rwxr-xr-x 1 root root 171350 Mar 12 01:47 tpcc_start
# mysql -uroot -pabcd.1234
mysql> create database tpcc1000;
Query OK, 1 row affected (0.05 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| tpcc1000 |
+--------------------+
4 rows in set (0.00 sec)
mysql> grant all on tpcc1000.* to 'tpcc'@'%' identified by 'tpcc';
Query OK, 0 rows affected (0.04 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> select user,host,password from mysql.user;
+------+-----------+-------------------------------------------+
| user | host | password |
+------+-----------+-------------------------------------------+
| root | localhost | *8E329B15E3C0FF9DDF7597B748CCE9473593BF60 |
| root | 127.0.0.1 | *8E329B15E3C0FF9DDF7597B748CCE9473593BF60 |
| root | ::1 | *8E329B15E3C0FF9DDF7597B748CCE9473593BF60 |
| tpcc | % | *D2B995B159B5840C27690FC435C6ACEE7B9E1348 |
+------+-----------+-------------------------------------------+
4 rows in set (0.00 sec)
# mysql -uroot -p tpcc1000 < create_table.sql
# ./tpcc_load -h 192.168.1.201 -d tpcc1000 -u tpcc -p "tpcc" -w 10
Loading Orders for D=1, W= 10
.......... 1000
.......... 2000
.......... 3000
Orders Done.
......
Loading Orders for D=10, W= 10
.......... 1000
.......... 2000
.......... 3000
Orders Done.
...DATA LOADING COMPLETED SUCCESSFULLY.
# mysql -uroot -p tpcc1000 < add_fkey_idx.sql
#./tpcc_start -h 192.168.1.201 -P 3306 -d tpcc1000 -u tpcc -p "tpcc" -w 10 -c 5 -l 120
***************************************
*** ###easy### TPC-C Load Generator ***
***************************************
option h with value '192.168.1.201'
option P with value '3306'
option d with value 'tpcc1000'
option u with value 'tpcc'
option p with value 'tpcc'
option w with value '10'
option c with value '5'
option l with value '120'
: 192.168.1.201
: 3306
: tpcc1000
: tpcc
: tpcc
: 10
: 5
: 10 (sec.)
: 120 (sec.)
RAMP-UP TIME.(10 sec.)
MEASURING START.
10, trx: 12, 95%: 3165.301, 99%: 3207.267, max_rt: 3206.893, 13|1010.971, 2|416.537, 1|4364.939, 2|8494.064
20, trx: 19, 95%: 3196.723, 99%: 3493.940, max_rt: 3494.238, 21|1268.676, 2|62.891, 2|4298.500, 1|6421.528
30, trx: 18, 95%: 1977.211, 99%: 2383.986, max_rt: 2384.258, 14|1624.832, 1|24.328, 2|3244.716, 3|7988.705
40, trx: 20, 95%: 1891.528, 99%: 2076.076, max_rt: 2076.318, 23|1178.977, 3|1383.674, 2|2348.884, 0|0.000
50, trx: 17, 95%: 2460.843, 99%: 2480.813, max_rt: 2480.890, 16|1366.876, 1|225.186, 1|3128.689, 3|9977.782
60, trx: 15, 95%: 1744.666, 99%: 1957.190, max_rt: 1957.151, 14|1129.822, 2|395.175, 2|3647.191, 2|12215.742
70, trx: 19, 95%: 2366.921, 99%: 4109.378, max_rt: 4109.376, 19|1547.989, 1|264.096, 2|5346.821, 1|8192.001
80, trx: 16, 95%: 2156.519, 99%: 2945.878, max_rt: 2946.298, 16|1784.607, 2|223.824, 1|3092.542, 3|9156.268
90, trx: 19, 95%: 2271.818, 99%: 2957.364, max_rt: 2957.742, 18|818.307, 2|630.973, 2|4997.217, 0|0.000
100, trx: 13, 95%: 2308.839, 99%: 3074.715, max_rt: 3074.606, 15|1268.598, 1|736.042, 1|5498.861, 2|10595.128
110, trx: 13, 95%: 2747.416, 99%: 3357.571, max_rt: 3357.443, 9|2315.481, 1|521.829, 2|6028.633, 1|9532.556
120, trx: 15, 95%: 2482.298, 99%: 3226.525, max_rt: 3226.206, 16|1343.299, 2|81.345, 2|6154.702, 2|9403.878
STOPPING THREADS.....
sc:0 lt:196rt:0fl:0 avg_rt: 1537.2 (5)
sc:0 lt:194rt:0fl:0 avg_rt: 522.2 (5)
sc:0 lt:20rt:0fl:0 avg_rt: 309.9 (5)
sc:0 lt:20rt:0fl:0 avg_rt: 3981.5 (80)
sc:0 lt:20rt:0fl:0 avg_rt: 8190.4 (20)
in 120 sec.
sc:0lt:196rt:0fl:0
sc:0lt:194rt:0fl:0
sc:0lt:20rt:0fl:0
sc:0lt:20rt:0fl:0
sc:0lt:20rt:0fl:0
(all must be )
Payment: 43.11% (>=43.0%)
Order-Status: 4.44% (>= 4.0%)
Delivery: 4.44% (>= 4.0%)
Stock-Level: 4.44% (>= 4.0%)
New-Order: 0.00% *
Payment: 0.00% *
Order-Status: 0.00% *
Delivery: 0.00% *
Stock-Level: 0.00% *
98.000 TpmC
页:
[1]