[Email protected] ~]# Unzip Tpcc-mysql.zip
[Email protected] ~]# CD TPCC-MYSQL/SRC
[[email protected] src]# make
[Email protected] src]# CD.
[email protected] tpcc-mysql]# LL
[Email protected] tpcc-mysql]# mysql-uroot-pabcd.1234
mysql> CREATE DATABASE tpcc1000;
Query OK, 1 row Affected (0.00 sec)
mysql> show databases;
Mysql> Grant all on tpcc1000.* to ' TPCC ' @ ' percent ' identified by ' TPCC ';
Query OK, 0 rows affected (0.01 sec)
mysql> flush Privileges;
Query OK, 0 rows Affected (0.00 sec)
Mysql> select User,host,password from Mysql.user;
[Email protected] tpcc-mysql]# Mysql-uroot-p tpcc1000 < Create_table.sql
[[email protected] tpcc-mysql]#./tpcc_load-h 192.168.40.34-d tpcc1000-u tpcc-p "TPCC"-W 10
[Email protected] tpcc-mysql]# Mysql-uroot-p tpcc1000 < Add_fkey_idx.sql
[Email protected] tpcc-mysql]#./tpcc_start-h 192.168.40.34-p 3306-d tpcc1000-u tpcc-p "TPCC"-W 10-c 5-l 120
Tpcc-mysql Installation Record