####################################### 8.0 ####################################### scl enable devtoolset-9 bash export PATH=$PATH:/home/umshastr/work/binaries/ga/mysql-8.0.25/bin - build tpcc - https:/github.com/Percona-Lab/tpcc-mysql rm -rf 104121/ bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/104121 --log-error-verbosity=3 bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/104121 --core-file --log-error=$PWD/104121/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv=/tmp/ 2>&1 & CREATE USER 'ushastry'@'localhost' IDENTIFIED WITH mysql_native_password BY 'mysql123'; GRANT ALL ON *.* TO 'ushastry'@'localhost'; mysql -uroot -p -h 127.0.0.1 -e "CREATE DATABASE tpcc10;" mysql -uroot -p -h 127.0.0.1 tpcc10 < create_table.sql mysql -uroot -p -h 127.0.0.1 tpcc10 < add_fkey_idx.sql ./tpcc_load -h 127.0.0.1 -uushastry -pmysql123 -w 1 -d tpcc10 ./tpcc_load -h 127.0.0.1 -uushastry -pmysql123 -w 1 -d tpcc10 ************************************* *** TPCC-mysql Data Loader *** ************************************* option h with value '127.0.0.1' option u with value 'ushastry' option p with value 'mysql123' option w with value '1' option d with value 'tpcc10' [server]: 127.0.0.1 [port]: 3306 [DBname]: tpcc10 [user]: ushastry [pass]: mysql123 [warehouse]: 1 TPCC Data Load Started... Loading Item .................................................. 5000 .................................................. 10000 .................................................. 15000 .................................................. 20000 .................................................. 25000 .................................................. 30000 .................................................. 35000 .................................................. 40000 .................................................. 45000 .................................................. 50000 .................................................. 55000 .................................................. 60000 .................................................. 65000 .................................................. 70000 .................................................. 75000 .................................................. 80000 .................................................. 85000 .................................................. 90000 .................................................. 95000 .................................................. 100000 Item Done. Loading Warehouse Loading Stock Wid=1 .................................................. 5000 .................................................. 10000 .................................................. 15000 .................................................. 20000 .................................................. 25000 .................................................. 30000 .................................................. 35000 .................................................. 40000 .................................................. 45000 .................................................. 50000 .................................................. 55000 .................................................. 60000 .................................................. 65000 .................................................. 70000 .................................................. 75000 .................................................. 80000 .................................................. 85000 .................................................. 90000 .................................................. 95000 .................................................. 100000 Stock Done. Loading District Loading Customer for DID=1, WID=1 .......... 1000 .......... 2000 .......... 3000 Customer Done. Loading Customer for DID=2, WID=1 .......... 1000 .......... 2000 .......... 3000 Customer Done. Loading Customer for DID=3, WID=1 .......... 1000 .......... 2000 .......... 3000 Customer Done. Loading Customer for DID=4, WID=1 .......... 1000 .......... 2000 .......... 3000 Customer Done. Loading Customer for DID=5, WID=1 .......... 1000 .......... 2000 .......... 3000 Customer Done. Loading Customer for DID=6, WID=1 .......... 1000 .......... 2000 .......... 3000 Customer Done. Loading Customer for DID=7, WID=1 .......... 1000 .......... 2000 .......... 3000 Customer Done. Loading Customer for DID=8, WID=1 .......... 1000 .......... 2000 .......... 3000 Customer Done. Loading Customer for DID=9, WID=1 .......... 1000 .......... 2000 .......... 3000 Customer Done. Loading Customer for DID=10, WID=1 .......... 1000 .......... 2000 .......... 3000 Customer Done. Loading Orders for D=1, W= 1 .......... 1000 .......... 2000 .......... 3000 Orders Done. Loading Orders for D=2, W= 1 .......... 1000 .......... 2000 .......... 3000 Orders Done. Loading Orders for D=3, W= 1 .......... 1000 .......... 2000 .......... 3000 Orders Done. Loading Orders for D=4, W= 1 .......... 1000 .......... 2000 .......... 3000 Orders Done. Loading Orders for D=5, W= 1 .......... 1000 .......... 2000 .......... 3000 Orders Done. Loading Orders for D=6, W= 1 .......... 1000 .......... 2000 .......... 3000 Orders Done. Loading Orders for D=7, W= 1 .......... 1000 .......... 2000 .......... 3000 Orders Done. Loading Orders for D=8, W= 1 .......... 1000 .......... 2000 .......... 3000 Orders Done. Loading Orders for D=9, W= 1 .......... 1000 .......... 2000 .......... 3000 Orders Done. Loading Orders for D=10, W= 1 .......... 1000 .......... 2000 .......... 3000 Orders Done. ...DATA LOADING COMPLETED SUCCESSFULLY. - ./tpcc_start -h 127.0.0.1 -uushastry -pmysql123 -w 1 -d tpcc10 -c10 -r1 -l1200 & --- *************************************** *** ###easy### TPC-C Load Generator *** *************************************** option h with value '127.0.0.1' option u with value 'ushastry' option p with value 'mysql123' option w with value '1' option d with value 'tpcc10' option c with value '10' option r with value '1' option l with value '1200' [server]: 127.0.0.1 [port]: 3306 [DBname]: tpcc10 [user]: ushastry [pass]: mysql123 [warehouse]: 1 [connection]: 10 [rampup]: 1 (sec.) [measure]: 1200 (sec.) RAMP-UP TIME.(1 sec.) MEASURING START. 10, trx: 734, 95%: 32.884, 99%: 52.251, max_rt: 130.056, 735|175.787, 73|2.793, 73|162.268, 74|27.027 20, trx: 731, 95%: 33.985, 99%: 50.862, max_rt: 68.250, 731|171.647, 73|1.432, 73|195.215, 73|30.995 30, trx: 750, 95%: 31.440, 99%: 41.982, max_rt: 57.103, 752|161.010, 75|2.090, 75|179.401, 75|23.529 40, trx: 743, 95%: 29.069, 99%: 39.119, max_rt: 46.198, 743|173.785, 75|2.477, 75|149.356, 75|25.946 50, trx: 744, 95%: 29.693, 99%: 42.146, max_rt: 66.449, 744|155.616, 74|1.878, 74|165.940, 74|26.594 60, trx: 741, 95%: 32.067, 99%: 41.507, max_rt: 51.275, 741|154.198, 74|1.516, 74|185.754, 74|23.511 70, trx: 777, 95%: 30.724, 99%: 37.671, max_rt: 63.907, 774|156.229, 78|1.400, 78|146.806, 78|25.910 80, trx: 674, 95%: 34.374, 99%: 46.956, max_rt: 69.557, 676|221.296, 67|1.406, 67|193.548, 67|24.603 90, trx: 582, 95%: 38.607, 99%: 57.763, max_rt: 229.442, 584|369.590, 59|2.586, 58|393.437, 59|24.993 100, trx: 623, 95%: 36.890, 99%: 49.689, max_rt: 56.478, 622|200.945, 61|1.375, 63|189.816, 62|23.880 -- CLI select a.processlist_info,b.info from performance_schema.threads a , information_schema.processlist b where a.processlist_id=b.id\G *************************** 1. row *************************** processlist_info: NULL info: UPDATE warehouse SET w_ytd = w_ytd + 3971 WHERE w_id = 1 *************************** 2. row *************************** processlist_info: NULL info: UPDATE warehouse SET w_ytd = w_ytd + 4050 WHERE w_id = 1 *************************** 3. row *************************** processlist_info: select a.processlist_info,b.info from performance_schema.threads a , information_schema.processlist b where a.processlist_id=b.id info: select a.processlist_info,b.info from performance_schema.threads a , information_schema.processlist b where a.processlist_id=b.id *************************** 4. row *************************** processlist_info: commit info: commit *************************** 5. row *************************** processlist_info: NULL info: UPDATE warehouse SET w_ytd = w_ytd + 4697 WHERE w_id = 1 *************************** 6. row *************************** processlist_info: NULL info: NULL *************************** 7. row *************************** processlist_info: NULL info: UPDATE warehouse SET w_ytd = w_ytd + 2646 WHERE w_id = 1 *************************** 8. row *************************** processlist_info: NULL info: UPDATE warehouse SET w_ytd = w_ytd + 871 WHERE w_id = 1 *************************** 9. row *************************** processlist_info: NULL info: NULL *************************** 10. row *************************** processlist_info: commit info: commit *************************** 11. row *************************** processlist_info: NULL info: UPDATE warehouse SET w_ytd = w_ytd + 4860 WHERE w_id = 1 *************************** 12. row *************************** processlist_info: NULL info: UPDATE warehouse SET w_ytd = w_ytd + 3668 WHERE w_id = 1 12 rows in set (0.01 sec) - mysql> select a.processlist_info,b.info from performance_schema.threads a , information_schema.processlist b where a.processlist_id=b.id\G *************************** 1. row *************************** processlist_info: commit info: commit *************************** 2. row *************************** processlist_info: commit info: commit *************************** 3. row *************************** processlist_info: select a.processlist_info,b.info from performance_schema.threads a , information_schema.processlist b where a.processlist_id=b.id info: select a.processlist_info,b.info from performance_schema.threads a , information_schema.processlist b where a.processlist_id=b.id *************************** 4. row *************************** processlist_info: NULL info: UPDATE warehouse SET w_ytd = w_ytd + 2505 WHERE w_id = 1 *************************** 5. row *************************** processlist_info: NULL info: UPDATE warehouse SET w_ytd = w_ytd + 2271 WHERE w_id = 1 *************************** 6. row *************************** processlist_info: NULL info: UPDATE warehouse SET w_ytd = w_ytd + 3271 WHERE w_id = 1 *************************** 7. row *************************** processlist_info: commit info: commit *************************** 8. row *************************** processlist_info: NULL info: UPDATE warehouse SET w_ytd = w_ytd + 2107 WHERE w_id = 1 *************************** 9. row *************************** processlist_info: NULL info: NULL *************************** 10. row *************************** processlist_info: NULL info: UPDATE warehouse SET w_ytd = w_ytd + 2676 WHERE w_id = 1 *************************** 11. row *************************** processlist_info: NULL info: UPDATE warehouse SET w_ytd = w_ytd + 4683 WHERE w_id = 1 *************************** 12. row *************************** processlist_info: NULL info: UPDATE warehouse SET w_ytd = w_ytd + 2008 WHERE w_id = 1 12 rows in set (0.01 sec) ####################################### 5.7 ####################################### rm -rf 104121/ bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/104121 --log-error-verbosity=3 bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/104121 --core-file --log-error=$PWD/104121/log.err --log-error-verbosity=3 --secure-file-priv="" --performance-schema=ON 2>&1 & - bin/mysql -uroot Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 18 Server version: 5.7.34 MySQL Community Server (GPL) Copyright (c) 2000, 2021, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select a.processlist_info,b.info from performance_schema.threads a , information_schema.processlist b where a.processlist_id=b.id\G *************************** 1. row *************************** processlist_info: commit info: commit *************************** 2. row *************************** processlist_info: NULL info: UPDATE warehouse SET w_ytd = w_ytd + ? WHERE w_id = ? *************************** 3. row *************************** processlist_info: commit info: commit *************************** 4. row *************************** processlist_info: NULL info: NULL *************************** 5. row *************************** processlist_info: commit info: commit *************************** 6. row *************************** processlist_info: NULL info: UPDATE district SET d_ytd = d_ytd + ? WHERE d_w_id = ? AND d_id = ? *************************** 7. row *************************** processlist_info: commit info: commit *************************** 8. row *************************** processlist_info: commit info: commit *************************** 9. row *************************** processlist_info: commit info: commit *************************** 10. row *************************** processlist_info: NULL info: NULL *************************** 11. row *************************** processlist_info: select a.processlist_info,b.info from performance_schema.threads a , information_schema.processlist b where a.processlist_id=b.id info: select a.processlist_info,b.info from performance_schema.threads a , information_schema.processlist b where a.processlist_id=b.id 11 rows in set (0.01 sec) mysql> select a.processlist_info,b.info from performance_schema.threads a , information_schema.processlist b where a.processlist_id=b.id\G *************************** 1. row *************************** processlist_info: commit info: commit *************************** 2. row *************************** processlist_info: NULL info: INSERT INTO order_line (ol_o_id, ol_d_id, ol_w_id, ol_number, ol_i_id, ol_supply_w_id, ol_quantity, ol_amount, ol_dist_info) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) *************************** 3. row *************************** processlist_info: NULL info: SELECT d_street_1, d_street_2, d_city, d_state, d_zip, d_name FROM district WHERE d_w_id = ? AND d_id = ? *************************** 4. row *************************** processlist_info: NULL info: UPDATE stock SET s_quantity = ? WHERE s_i_id = ? AND s_w_id = ? *************************** 5. row *************************** processlist_info: NULL info: UPDATE stock SET s_quantity = ? WHERE s_i_id = ? AND s_w_id = ? *************************** 6. row *************************** processlist_info: commit info: commit *************************** 7. row *************************** processlist_info: NULL info: UPDATE warehouse SET w_ytd = w_ytd + ? WHERE w_id = ? *************************** 8. row *************************** processlist_info: NULL info: UPDATE warehouse SET w_ytd = w_ytd + ? WHERE w_id = ? *************************** 9. row *************************** processlist_info: commit info: commit *************************** 10. row *************************** processlist_info: NULL info: UPDATE warehouse SET w_ytd = w_ytd + ? WHERE w_id = ? *************************** 11. row *************************** processlist_info: select a.processlist_info,b.info from performance_schema.threads a , information_schema.processlist b where a.processlist_id=b.id info: select a.processlist_info,b.info from performance_schema.threads a , information_schema.processlist b where a.processlist_id=b.id 11 rows in set (0.00 sec)