tpcc-mysql 中tpcc-load初始化数据执行结果

最新推荐文章于 2025-05-26 16:11:19 发布

原创

最新推荐文章于 2025-05-26 16:11:19 发布 · 2.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql

这篇博客记录了在测试环境中使用tpcc-mysql工具进行TPC-C性能测试的数据初始化过程。在尝试使用未提供密码的root用户失败后，通过输入正确的密码成功加载了10个warehouses的数据，包括Item、Warehouse、Stock、District及Orders等表的数据加载细节。数据加载完成并显示成功。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

今天在测试环境中，使用tpcc-mysql工具进行性能测试，对其中的测试结果进行了记录。

其中tpcc_load是用于初始化数据，执行脚本后，返回结果如下：

[mysql@Confluence ~]$ cd /data/setup/tpcc-mysql/
[mysql@Confluence tpcc-mysql]$ ls
add_fkey_idx.sql create_table.sql load.sh schema2 src tpcc_start
count.sql drop_cons.sql README scripts tpcc_load
[mysql@Confluence tpcc-mysql]$ ./tpcc_load 172.32.1.203 tpcc root "" 10
*************************************
*** ###easy### TPC-C Data Loader ***
*************************************
<Parameters>
[server]: 172.32.1.203
[port]: 3306
[DBname]: tpcc
[user]: root
[pass]:
[warehouse]: 10

1045, 28000, Access denied for user 'root'@'Confluence' (using password: NO)
[mysql@Confluence tpcc-mysql]$ ./tpcc_load 172.32.1.203 tpcc root "123456" 10
*************************************
*** ###easy### TPC-C Data Loader ***
*************************************
<Parameters>
[server]: 172.32.1.203
[port]: 3306
[DBname]: tpcc
[user]: root
[pass]: 123456
[warehouse]: 10
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 Stock Wid=2
.................................................. 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 Stock Wid=3
.................................................. 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 Stock Wid=4
.................................................. 5000
.................................................. 10000
.................................................. 15000
.................................................. 20000
.................................................. 25000
.................................................. 30000
.................................................. 35000
.................................................. 40000
.................................................. 45000
.................................................. 50000
.................................................. 55000
.................................................. 60000
.................................................. 65000
.................................................. 70000
.................................................. 75000
.................................................. 80000
.................................................. 85000
.