mysql benchmarksql 壓測
磁碟配置 RAID10,8塊盤SEAGATE 12 Gbps SAS 900G 15000轉 指令碼： 看下props.mysql指令碼配置： [root@pro-pnh-310-db-tidb-mp-45 run]# cat props.mysql db=mysql driver=com.mysql.jdbc.Driver conn=jdbc:mysql://10.34.255.45:3400/tpcc?useSSL=false&useServerPrepStmts=true&useConfigs=maxPerformance&rewriteBatchedStatements=true user=test1 password=123456 warehouses=200 loadWorkers=10 terminals=100 //To run specified transactions per terminal- runMins must equal zero runTxnsPerTerminal=0 //To run for specified minutes- runTxnsPerTerminal must equal zero runMins=5 //Number of total transactions per minute limitTxnsPerMin=0 //Set to true to run in 4.x compatible mode. Set to false to use the //entire configured database evenly. terminalWarehouseFixed=true //The following five values must add up to 100 //The default percentages of 45, 43, 4, 4 & 4 match the TPC-C spec newOrderWeight=45 paymentWeight=43 orderStatusWeight=4 deliveryWeight=4 stockLevelWeight=4 // Directory name to create for collecting detailed result data. // Comment this out to suppress. resultDirectory=my_result_%tY-%tm-%td_%tH%tM%tS //osCollectorScript=./misc/os_collector_linux.py //osCollectorInterval=1 //osCollectorSSHAddr=user@dbhost //osCollectorDevices=net_eth0 blk_sda ./runSQL.sh props.mysql ./sql.common/tableCreates.sql ./runDatabaseBuild.sh props.mysql ./runSQL.sh props.mysql ./sql.common/indexCreates.sql ./runBenchmark.sh props.mysql [mysql@pro-pnh-310-db-tidb-mp-45 ~]$ ls -lhS /data/mp_mysql/tpcc/ total 20G -rw-r-----. 1 mysql mysql 7.9G Nov 15 18:21 bmsql_stock.ibd -rw-r-----. 1 mysql mysql 6.1G Nov 15 18:21 bmsql_order_line.ibd -rw-r-----. 1 mysql mysql 4.4G Nov 15 18:21 bmsql_customer.ibd -rw-r-----. 1 mysql mysql 636M Nov 15 18:21 bmsql_oorder.ibd -rw-r-----. 1 mysql mysql 608M Nov 15 18:21 bmsql_history.ibd -rw-r-----. 1 mysql mysql 88M Nov 15 18:21 bmsql_new_order.ibd -rw-r-----. 1 mysql mysql 16M Nov 15 18:13 bmsql_item.ibd -rw-r-----. 1 mysql mysql 352K Nov 15 18:21 bmsql_district.ibd -rw-r-----. 1 mysql mysql 144K Nov 15 18:21 bmsql_warehouse.ibd -rw-r-----. 1 mysql mysql 112K Nov 15 17:39 bmsql_config.ibd
查詢很快的，等待寫 mysql> show processlist; +-------+-----------------+--------------------+------+---------+--------+----------------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+-----------------+--------------------+------+---------+--------+----------------------------+------------------------------------------------------------------------------------------------------+ | 5 | event_scheduler | localhost | NULL | Daemon | 461549 | Waiting on empty queue | NULL | | 95484 | root | localhost | NULL | Query | 0 | init | show processlist | | 95649 | test1 | 10.34.255.45:40772 | tpcc | Sleep | 107 | | NULL | | 95650 | test1 | 10.34.255.45:40774 | tpcc | Query | 0 | waiting for handler commit | commit | | 95651 | test1 | 10.34.255.45:40776 | tpcc | Execute | 0 | updating | UPDATE bmsql_stock SET s_quantity = 35, s_ytd = s_ytd + 2, s_order_cnt = s_order_cnt + 1 | | 95652 | test1 | 10.34.255.45:40778 | tpcc | Query | 0 | waiting for handler commit | commit | | 95653 | test1 | 10.34.255.45:40780 | tpcc | Query | 0 | waiting for handler commit | commit | | 95654 | test1 | 10.34.255.45:40782 | tpcc | Query | 0 | waiting for handler commit | commit | | 95655 | test1 | 10.34.255.45:40784 | tpcc | Query | 0 | waiting for handler commit | commit | | 95656 | test1 | 10.34.255.45:40786 | tpcc | Query | 0 | waiting for handler commit | commit | | 95657 | test1 | 10.34.255.45:40788 | tpcc | Query | 0 | waiting for handler commit | commit | | 95658 | test1 | 10.34.255.45:40790 | tpcc | Query | 0 | waiting for handler commit | commit | | 95659 | test1 | 10.34.255.45:40792 | tpcc | Query | 0 | waiting for handler commit | commit | | 95660 | test1 | 10.34.255.45:40794 | tpcc | Execute | 0 | Sending to client | INSERT INTO bmsql_history ( h_c_id, h_c_d_id, h_c_w_id, h_d_id, h_w_id, h_date, h_amount, h_d | | 95661 | test1 | 10.34.255.45:40796 | tpcc | Execute | 0 | executing | SELECT count(*) AS low_stock FROM ( SELECT s_w_id, s_i_id, s_quantity FROM bmsql_stock | | 95662 | test1 | 10.34.255.45:40798 | tpcc | Query | 0 | waiting for handler commit | commit | | 95663 | test1 | 10.34.255.45:40800 | tpcc | Execute | 0 | Opening tables | INSERT INTO bmsql_order_line ( ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, | | 95664 | test1 | 10.34.255.45:40802 | tpcc | Query | 0 | waiting for handler commit | commit | | 95665 | test1 | 10.34.255.45:40804 | tpcc | Query | 0 | waiting for handler commit | commit | | 95666 | test1 | 10.34.255.45:40806 | tpcc | Execute | 0 | System lock | UPDATE bmsql_stock SET s_quantity = 50, s_ytd = s_ytd + 1, s_order_cnt = s_order_cnt + 1 | | 95667 | test1 | 10.34.255.45:40808 | tpcc | Query | 0 | waiting for handler commit | commit | | 95668 | test1 | 10.34.255.45:40810 | tpcc | Sleep | 0 | | NULL | | 95669 | test1 | 10.34.255.45:40812 | tpcc | Query | 0 | waiting for handler commit | commit | | 95670 | test1 | 10.34.255.45:40814 | tpcc | Query | 0 | waiting for handler commit | commit | | 95671 | test1 | 10.34.255.45:40816 | tpcc | Query | 0 | waiting for handler commit | commit | | 95672 | test1 | 10.34.255.45:40818 | tpcc | Query | 0 | waiting for handler commit | commit | | 95673 | test1 | 10.34.255.45:40820 | tpcc | Execute | 0 | updating | UPDATE bmsql_customer SET c_balance = c_balance + 75469.88, c_delivery_cnt = c_delivery_ | | 95674 | test1 | 10.34.255.45:40822 | tpcc | Query | 0 | waiting for handler commit | commit | | 95675 | test1 | 10.34.255.45:40824 | tpcc | Query | 0 | waiting for handler commit | commit | | 95676 | test1 | 10.34.255.45:40826 | tpcc | Query | 0 | waiting for handler commit | commit | | 95677 | test1 | 10.34.255.45:40828 | tpcc | Execute | 0 | executing | SELECT count(*) AS low_stock FROM ( SELECT s_w_id, s_i_id, s_quantity FROM bmsql_stock | | 95678 | test1 | 10.34.255.45:40830 | tpcc | Query | 0 | waiting for handler commit | commit | | 95679 | test1 | 10.34.255.45:40832 | tpcc | Query | 0 | waiting for handler commit | commit | | 95680 | test1 | 10.34.255.45:40834 | tpcc | Query | 0 | waiting for handler commit | commit | | 95681 | test1 | 10.34.255.45:40836 | tpcc | Query | 0 | waiting for handler commit | commit | | 95682 | test1 | 10.34.255.45:40838 | tpcc | Execute | 0 | Opening tables | SELECT c_id FROM bmsql_customer WHERE c_w_id = 158 AND c_d_id = 8 AND c_last = 'ABLEESEEING' | | 95683 | test1 | 10.34.255.45:40840 | tpcc | Query | 0 | waiting for handler commit | commit | | 95684 | test1 | 10.34.255.45:40842 | tpcc | Execute | 0 | executing | SELECT o_id, o_entry_d, o_carrier_id FROM bmsql_oorder WHERE o_w_id = 199 AND o_d_id = 6 AND | | 95685 | test1 | 10.34.255.45:40844 | tpcc | Execute | 0 | executing | SELECT count(*) AS low_stock FROM ( SELECT s_w_id, s_i_id, s_quantity FROM bmsql_stock | | 95686 | test1 | 10.34.255.45:40846 | tpcc | Query | 0 | waiting for handler commit | commit | | 95687 | test1 | 10.34.255.45:40848 | tpcc | Execute | 0 | executing | SELECT count(*) AS low_stock FROM ( SELECT s_w_id, s_i_id, s_quantity FROM bmsql_stock | | 95688 | test1 | 10.34.255.45:40850 | tpcc | Query | 0 | waiting for handler commit | commit | | 95689 | test1 | 10.34.255.45:40852 | tpcc | Query | 0 | waiting for handler commit | commit | | 95690 | test1 | 10.34.255.45:40854 | tpcc | Execute | 0 | Sending to client | UPDATE bmsql_stock SET s_quantity = 76, s_ytd = s_ytd + 9, s_order_cnt = s_order_cnt + 1 | | 95691 | test1 | 10.34.255.45:40856 | tpcc | Execute | 0 | updating | UPDATE bmsql_warehouse SET w_ytd = w_ytd + 3157.24 WHERE w_id = 108 | | 95692 | test1 | 10.34.255.45:40858 | tpcc | Query | 0 | waiting for handler commit | commit | | 95693 | test1 | 10.34.255.45:40860 | tpcc | Execute | 0 | Sending to client | DELETE FROM bmsql_new_order WHERE (no_w_id,no_d_id,no_o_id) IN ((41,1,2467),(41,2,2467),(41,3,24 | | 95694 | test1 | 10.34.255.45:40862 | tpcc | Execute | 0 | Sending to client | INSERT INTO bmsql_oorder ( o_id, o_d_id, o_w_id, o_c_id, o_entry_d, o_ol_cnt, o_all_local) VA | | 95695 | test1 | 10.34.255.45:40864 | tpcc | Query | 0 | waiting for handler commit | commit | | 95696 | test1 | 10.34.255.45:40866 | tpcc | Execute | 0 | Sending to client | SELECT no_o_id FROM bmsql_new_order WHERE no_w_id = 31 AND no_d_id = 9 ORDER BY no_o_id | | 95697 | test1 | 10.34.255.45:40868 | tpcc | Query | 0 | waiting for handler commit | commit | | 95698 | test1 | 10.34.255.45:40870 | tpcc | Query | 0 | waiting for handler commit | commit | | 95699 | test1 | 10.34.255.45:40872 | tpcc | Query | 0 | waiting for handler commit | commit | | 95700 | test1 | 10.34.255.45:40874 | tpcc | Query | 0 | waiting for handler commit | commit | | 95701 | test1 | 10.34.255.45:40876 | tpcc | Execute | 0 | System lock | UPDATE bmsql_oorder SET o_carrier_id = 7 WHERE (o_w_id,o_d_id,o_id) IN ((50,1,2310),(50,2,23 | | 95702 | test1 | 10.34.255.45:40878 | tpcc | Execute | 0 | executing | SELECT s_i_id, s_w_id, s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, | | 95703 | test1 | 10.34.255.45:40880 | tpcc | Query | 0 | waiting for handler commit | commit | | 95704 | test1 | 10.34.255.45:40882 | tpcc | Query | 0 | waiting for handler commit | commit | | 95705 | test1 | 10.34.255.45:40884 | tpcc | Execute | 0 | executing | SELECT count(*) AS low_stock FROM ( SELECT s_w_id, s_i_id, s_quantity FROM bmsql_stock | | 95706 | test1 | 10.34.255.45:40886 | tpcc | Query | 0 | waiting for handler commit | commit | | 95707 | test1 | 10.34.255.45:40888 | tpcc | Query | 0 | waiting for handler commit | commit | | 95708 | test1 | 10.34.255.45:40890 | tpcc | Query | 0 | waiting for handler commit | commit | | 95709 | test1 | 10.34.255.45:40892 | tpcc | Query | 0 | waiting for handler commit | commit | | 95710 | test1 | 10.34.255.45:40894 | tpcc | Execute | 0 | updating | UPDATE bmsql_stock SET s_quantity = 14, s_ytd = s_ytd + 8, s_order_cnt = s_order_cnt + 1 | | 95711 | test1 | 10.34.255.45:40896 | tpcc | Execute | 0 | updating | UPDATE bmsql_warehouse SET w_ytd = w_ytd + 2351.75 WHERE w_id = 117 | | 95712 | test1 | 10.34.255.45:40898 | tpcc | Execute | 0 | executing | SELECT count(*) AS low_stock FROM ( SELECT s_w_id, s_i_id, s_quantity FROM bmsql_stock | | 95713 | test1 | 10.34.255.45:40900 | tpcc | Query | 0 | waiting for handler commit | commit | | 95714 | test1 | 10.34.255.45:40902 | tpcc | Execute | 0 | executing | SELECT count(*) AS low_stock FROM ( SELECT s_w_id, s_i_id, s_quantity FROM bmsql_stock | | 95715 | test1 | 10.34.255.45:40904 | tpcc | Execute | 0 | statistics | SELECT s_i_id, s_w_id, s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, | | 95716 | test1 | 10.34.255.45:40906 | tpcc | Execute | 0 | Sending to client | SELECT d_tax, d_next_o_id FROM bmsql_district WHERE d_w_id = 105 AND d_id = 7 FOR UPDATE | | 95717 | test1 | 10.34.255.45:40908 | tpcc | Query | 0 | waiting for handler commit | commit | | 95718 | test1 | 10.34.255.45:40910 | tpcc | Query | 0 | waiting for handler commit | commit | | 95719 | test1 | 10.34.255.45:40912 | tpcc | Query | 0 | waiting for handler commit | commit | | 95720 | test1 | 10.34.255.45:40914 | tpcc | Query | 0 | waiting for handler commit | commit | | 95721 | test1 | 10.34.255.45:40916 | tpcc | Query | 0 | waiting for handler commit | commit | | 95722 | test1 | 10.34.255.45:40918 | tpcc | Query | 0 | waiting for handler commit | commit | | 95723 | test1 | 10.34.255.45:40920 | tpcc | Query | 0 | waiting for handler commit | commit | | 95724 | test1 | 10.34.255.45:40922 | tpcc | Query | 0 | waiting for handler commit | commit | | 95725 | test1 | 10.34.255.45:40924 | tpcc | Query | 0 | waiting for handler commit | commit | | 95726 | test1 | 10.34.255.45:40926 | tpcc | Query | 0 | waiting for handler commit | commit | | 95727 | test1 | 10.34.255.45:40928 | tpcc | Execute | 0 | updating | UPDATE bmsql_district SET d_next_o_id = d_next_o_id + 1 WHERE d_w_id = 5 AND d_id = 10 | | 95728 | test1 | 10.34.255.45:40930 | tpcc | Query | 0 | waiting for handler commit | commit | | 95729 | test1 | 10.34.255.45:40932 | tpcc | Query | 0 | waiting for handler commit | commit | | 95730 | test1 | 10.34.255.45:40934 | tpcc | Execute | 0 | System lock | UPDATE bmsql_stock SET s_quantity = 47, s_ytd = s_ytd + 2, s_order_cnt = s_order_cnt + 1 | | 95731 | test1 | 10.34.255.45:40936 | tpcc | Query | 0 | waiting for handler commit | commit | | 95732 | test1 | 10.34.255.45:40938 | tpcc | Query | 0 | waiting for handler commit | commit | | 95733 | test1 | 10.34.255.45:40940 | tpcc | Query | 0 | waiting for handler commit | commit | | 95734 | test1 | 10.34.255.45:40942 | tpcc | Query | 0 | waiting for handler commit | commit | | 95735 | test1 | 10.34.255.45:40944 | tpcc | Execute | 0 | updating | UPDATE bmsql_district SET d_ytd = d_ytd + 1675.83 WHERE d_w_id = 175 AND d_id = 2 | | 95736 | test1 | 10.34.255.45:40946 | tpcc | Query | 0 | waiting for handler commit | commit | | 95737 | test1 | 10.34.255.45:40948 | tpcc | Query | 0 | waiting for handler commit | commit | | 95738 | test1 | 10.34.255.45:40950 | tpcc | Execute | 0 | System lock | UPDATE bmsql_customer SET c_balance = c_balance - 4178.68, c_ytd_payment = c_ytd_payment | | 95739 | test1 | 10.34.255.45:40952 | tpcc | Query | 0 | waiting for handler commit | commit | | 95740 | test1 | 10.34.255.45:40954 | tpcc | Query | 0 | waiting for handler commit | commit | | 95741 | test1 | 10.34.255.45:40956 | tpcc | Execute | 0 | starting | NULL | | 95742 | test1 | 10.34.255.45:40958 | tpcc | Execute | 0 | statistics | SELECT c_discount, c_last, c_credit, w_tax FROM bmsql_customer JOIN bmsql_warehouse ON (w_id | | 95743 | test1 | 10.34.255.45:40960 | tpcc | Execute | 0 | Sending to client | UPDATE bmsql_district SET d_next_o_id = d_next_o_id + 1 WHERE d_w_id = 147 AND d_id = 5 | | 95744 | test1 | 10.34.255.45:40962 | tpcc | Query | 0 | waiting for handler commit | commit | | 95745 | test1 | 10.34.255.45:40964 | tpcc | Prepare | 0 | starting | INSERT INTO bmsql_order_line ( ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, | | 95746 | test1 | 10.34.255.45:40966 | tpcc | Prepare | 0 | Sending to client | INSERT INTO bmsql_order_line ( ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, | | 95747 | test1 | 10.34.255.45:40968 | tpcc | Execute | 0 | Sending to client | SELECT i_id, i_price, i_name, i_data FROM bmsql_item WHERE i_id in (53377,43203,87525,46965,8626 | | 95748 | test1 | 10.34.255.45:40970 | tpcc | Execute | 0 | updating | UPDATE bmsql_oorder SET o_carrier_id = 10 WHERE (o_w_id,o_d_id,o_id) IN ((74,1,2449),(74,2,2 | | 95749 | test1 | 10.34.255.45:40972 | tpcc | Execute | 0 | Sending to client | UPDATE bmsql_stock SET s_quantity = 28, s_ytd = s_ytd + 4, s_order_cnt = s_order_cnt + 1 | +-------+-----------------+--------------------+------+---------+--------+----------------------------+------------------------------------------------------------------------------------------------------ 其中iostat 的結果，磁碟利用率滿了。 avg-cpu: %user %nice %system %iowait %steal %idle 47.80 0.00 9.98 2.62 0.00 39.60 Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await r_await w_await svctm %util sda 2.33 0.00 0.33 7862.00 10.67 204567.83 52.04 4.74 0.60 518.00 0.58 0.12 92.33 scd0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 avg-cpu: %user %nice %system %iowait %steal %idle 50.43 0.00 10.79 2.22 0.00 36.57 Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await r_await w_await svctm %util sda 0.00 0.00 0.00 8776.67 0.00 232725.50 53.03 5.49 0.63 0.00 0.63 0.12 105.20 scd0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 avg-cpu: %user %nice %system %iowait %steal %idle 60.30 0.00 12.32 2.27 0.00 25.11 Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await r_await w_await svctm %util sda 0.00 0.00 0.00 6919.00 0.00 189233.33 54.70 4.45 0.64 0.00 0.64 0.12 82.60 scd0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 avg-cpu: %user %nice %system %iowait %steal %idle 51.99 0.00 11.34 2.14 0.00 34.53 Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await r_await w_await svctm %util sda 0.00 2.67 0.00 8276.00 0.00 216384.33 52.29 4.98 0.60 0.00 0.60 0.12 97.30 scd0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 avg-cpu: %user %nice %system %iowait %steal %idle 45.08 0.00 9.83 2.27 0.00 42.82 Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await r_await w_await svctm %util sda 0.00 0.00 0.00 6585.00 0.00 173794.33 52.78 4.34 0.66 0.00 0.66 0.13 84.97 scd0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 avg-cpu: %user %nice %system %iowait %steal %idle 56.97 0.00 11.60 2.15 0.00 29.29 Device: rrqm/s wrqm/s r/s w/s rkB/s wkB/s avgrq-sz avgqu-sz await r_await w_await svctm %util sda 0.00 0.00 0.00 8301.33 0.00 220068.00 53.02 4.90 0.59 0.00 0.59 0.11 93.97 scd0 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 資源使用情況：記憶體100G，cpu用掉17核 top - 18:20:07 up 14 days, 23:32, 4 users, load average: 34.27, 21.35, 11.10 Tasks: 409 total, 1 running, 408 sleeping, 0 stopped, 0 zombie %Cpu(s): 45.5 us, 8.0 sy, 0.0 ni, 42.6 id, 2.3 wa, 0.0 hi, 1.7 si, 0.0 st KiB Mem : 19779680+total, 568124 free, 10877010+used, 88458576 buff/cache KiB Swap: 16773116 total, 16355748 free, 417368 used. 88068680 avail Mem PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 150801 mysql 20 0 106.0g 97.8g 12700 S 1797 51.9 2321:35 /opt/mysql8/bin/mysqld --defaults-file=/etc/mp_mysql_3400.cnf --basedir=/opt/mysql8 --datadir=/data/mp_mysql --plugin-dir=/opt/mysql8/lib/plugin --log-error=/log/mp_mysql/alert_mp_mysql.log --open-files-limit=65535 --pid-file=pro-pnh-310-db-t+ 94758 root 20 0 42.2g 4.3g 13368 S 398.0 2.3 19:05.51 java -cp .:../lib/mysql/*:../lib/*:../dist/* -Dprop=props.mysql -DrunID=2 jTPCC 93185 mysql 20 0 107992 864 732 S 7.0 0.0 0:04.11 iostat -x 3 126 root 20 0 0 0 0 S 0.3 0.0 0:01.24 [ksoftirqd/23] 151 root 20 0 0 0 0 S 0.3 0.0 2:09.07 [ksoftirqd/28] 225 root 20 0 0 0 0 S 0.3 0.0 233:14.95 [kswapd0] 226 root 20 0 0 0 0 S 0.3 0.0 48:03.34 [kswapd1] 1019 root 20 0 13216 100 36 S 0.3 0.0 20:10.55 /sbin/rngd -f
壓測的結果
[root@pro-pnh-310-db-tidb-mp-45 run]# ./runBenchmark.sh props.mysql 18:16:13,055 [main] INFO jTPCC : Term-00, 18:16:13,057 [main] INFO jTPCC : Term-00, +-------------------------------------------------------------+ 18:16:13,057 [main] INFO jTPCC : Term-00, BenchmarkSQL v5.0 18:16:13,057 [main] INFO jTPCC : Term-00, +-------------------------------------------------------------+ 18:16:13,057 [main] INFO jTPCC : Term-00, (c) 2003, Raul Barbosa 18:16:13,057 [main] INFO jTPCC : Term-00, (c) 2004-2016, Denis Lussier 18:16:13,059 [main] INFO jTPCC : Term-00, (c) 2016, Jan Wieck 18:16:13,059 [main] INFO jTPCC : Term-00, +-------------------------------------------------------------+ 18:16:13,059 [main] INFO jTPCC : Term-00, 18:16:13,060 [main] INFO jTPCC : Term-00, db=mysql 18:16:13,060 [main] INFO jTPCC : Term-00, driver=com.mysql.jdbc.Driver 18:16:13,060 [main] INFO jTPCC : Term-00, conn=jdbc:mysql://10.34.255.45:3400/tpcc?useSSL=false&useServerPrepStmts=true&useConfigs=maxPerformance&rewriteBatchedStatements=true 18:16:13,060 [main] INFO jTPCC : Term-00, user=test1 18:16:13,060 [main] INFO jTPCC : Term-00, 18:16:13,060 [main] INFO jTPCC : Term-00, warehouses=200 18:16:13,061 [main] INFO jTPCC : Term-00, terminals=100 18:16:13,062 [main] INFO jTPCC : Term-00, runMins=5 18:16:13,062 [main] INFO jTPCC : Term-00, limitTxnsPerMin=0 18:16:13,063 [main] INFO jTPCC : Term-00, terminalWarehouseFixed=true 18:16:13,063 [main] INFO jTPCC : Term-00, 18:16:13,063 [main] INFO jTPCC : Term-00, newOrderWeight=45 18:16:13,063 [main] INFO jTPCC : Term-00, paymentWeight=43 18:16:13,063 [main] INFO jTPCC : Term-00, orderStatusWeight=4 18:16:13,063 [main] INFO jTPCC : Term-00, deliveryWeight=4 18:16:13,063 [main] INFO jTPCC : Term-00, stockLevelWeight=4 18:16:13,063 [main] INFO jTPCC : Term-00, 18:16:13,063 [main] INFO jTPCC : Term-00, resultDirectory=my_result_%tY-%tm-%td_%tH%tM%tS 18:16:13,063 [main] INFO jTPCC : Term-00, osCollectorScript=null 18:16:13,064 [main] INFO jTPCC : Term-00, Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary. 18:16:13,077 [main] INFO jTPCC : Term-00, copied props.mysql to my_result_2022-11-15_181613/run.properties 18:16:13,077 [main] INFO jTPCC : Term-00, created my_result_2022-11-15_181613/data/runInfo.csv for runID 2 18:16:13,078 [main] INFO jTPCC : Term-00, writing per transaction results to my_result_2022-11-15_181613/data/result.csv 18:16:13,078 [main] INFO jTPCC : Term-00, 18:16:13,318 [main] INFO jTPCC : Term-00, C value for C_LAST during load: 93 Term-18:21:14,786 [Thread-1] INFO jTPCC : Term-00, nt tpmTOTAL: 9254412 Memory Usage: 206MB / 1570MB 18:21:14,786 [Thread-1] INFO jTPCC : Term-00, 18:21:14,786 [Thread-1] INFO jTPCC : Term-00, Measured tpmC (NewOrders) = 125783.87 18:21:14,786 [Thread-1] INFO jTPCC : Term-00, Measured tpmTOTAL = 279600.23 18:21:14,786 [Thread-1] INFO jTPCC : Term-00, Session Start = 2022-11-15 18:16:14 18:21:14,786 [Thread-1] INFO jTPCC : Term-00, Session End = 2022-11-15 18:21:14 18:21:14,786 [Thread-1] INFO jTPCC : Term-00, Transaction Count = 1398126 18:21:14,787 [Thread-1] INFO jTPCC : executeTime[Payment]=10928016 18:21:14,787 [Thread-1] INFO jTPCC : executeTime[Order-Status]=202815 18:21:14,787 [Thread-1] INFO jTPCC : executeTime[Delivery]=2334128 18:21:14,787 [Thread-1] INFO jTPCC : executeTime[Stock-Level]=1931423 18:21:14,787 [Thread-1] INFO jTPCC : executeTime[New-Order]=14597786
壓測表的資料量
mysql> select count(*) from bmsql_item; +----------+ | count(*) | +----------+ | 100000 | +----------+ 1 row in set (0.01 sec) mysql> select count(*) from bmsql_oorder -> ; +----------+ | count(*) | +----------+ | 6622740 | +----------+ 1 row in set (0.25 sec) mysql> select count(*) from bmsql_new_order; +----------+ | count(*) | +----------+ | 1870310 | +----------+ 1 row in set (0.09 sec) mysql> select count(*) from bmsql_warehouse; +----------+ | count(*) | +----------+ | 200 | +----------+ 1 row in set (0.01 sec) mysql> select count(*) from bmsql_stock; +----------+ | count(*) | +----------+ | 20000000 | +----------+ 1 row in set (2.98 sec) mysql> select count(*) from bmsql_order_line; +----------+ | count(*) | +----------+ | 66213118 | +----------+ 1 row in set (2.95 sec) mysql> select count(*) from bmsql_history; +----------+ | count(*) | +----------+ | 6602168 | +----------+ 1 row in set (0.29 sec)
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/30393770/viewspace-2923521/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- benchmarksql 5.0壓測MySQLMySql
- MySQL的壓測MySql
- MYSQL壓縮表測試MySql
- tpcc-mysql 壓測報告MySql
- MySQL 寫入壓測幾種方式MySql
- PostgreSQL BenchmarkSQL使用SQL
- Mysql效能壓測、Binlog恢復資料MySql
- 【TEST】Oracle19c使用benchmarksql進行效能測試OracleSQL
- 使用 locust 對 mysql 語句進行壓測MySql
- MySQL壓測工具mysqlslap的介紹與使用MySql
- MySQL 效能壓測工具，從入門到自定義測試項MySql
- MySQL 5.7和8.0 MHA架構下sysbench壓測MySql架構
- PostgreSQL DBA(87) - benchmarksql簡介SQL
- MySQL 效能壓測工具-sysbench，從入門到自定義測試項MySql
- GaussDB T 1.0.2單機環境TPC-C之BenchmarkSQL效能測試SQL
- Benchmarksql的props配置檔案解析SQL
- 每秒 50 萬行——MySQL 寫入壓測併發實踐MySql
- locust壓測
- ClickHouse壓測
- 壓測流程
- Taurus.MVC 效能壓力測試（ap 壓測 和 linux 下wrk 壓測）：.NET 版本MVCLinux
- mysql之 sysbench1.0.3 安裝與系統壓力測試MySql
- MySQL原理簡介—3.生產環境的部署壓測MySql
- Taurus.MVC 效能壓力測試（ap 壓測 和 linux 下wrk 壓測）：.NET Core 版本MVCLinux
- GaussDB T 1.0.2分散式叢集TPC-C之BenchmarkSQL效能測試分散式SQL
- 全鏈路壓測演進之迭代式壓測
- apache ab壓力測試工具-批次壓測指令碼Apache指令碼
- 壓力測試
- kafka壓測工具Kafka
- 談談壓測
- 壓測工具 wrk
- mysqlslap效能壓測MySql
- mysqlslap 效能壓測MySql
- Oracle的壓測Oracle
- 全鏈路壓測(1)：認識全鏈路壓測
- MySQL 5.6的表壓縮MySql
- mysql壓縮解決方案MySql
- 使用sysbench壓力測試MySQL（一）(r11筆記第3天)MySql筆記