在3台 32c128g 2 essd磁盘的基础上测试的
参考 https://www.oceanbase.com/docs/community-observer-cn-10000000000450308
obd test tpch mytest --tenant=tpch_mysql -s 100 --remote-tbl-dir=/tmp/tpch100
Get local repositories and plugins ok
Open ssh connection ok
Cluster status check ok
Connect observer(server1(172.30.63.8):2881) ok
Generate Data (Scale Factor: 100) ok
Send tbl to remote (server1(172.30.63.8)) ok
Optimize for stage test ok
Format DDL ok
Create table ok
Load data ok
Merge ok
Format SQL ok
Warmup ok
[2022-11-14 16:08:27]: start /root/oceanbase-all-in-one/conf/tmp/db1.sql
[2022-11-14 16:08:30]: end /root/oceanbase-all-in-one/conf/tmp/db1.sql, cost 2.4s
[2022-11-14 16:08:30]: start /root/oceanbase-all-in-one/conf/tmp/db2.sql
[2022-11-14 16:08:30]: end /root/oceanbase-all-in-one/conf/tmp/db2.sql, cost 0.2s
[2022-11-14 16:08:30]: start /root/oceanbase-all-in-one/conf/tmp/db3.sql
[2022-11-14 16:08:31]: end /root/oceanbase-all-in-one/conf/tmp/db3.sql, cost 0.7s
[2022-11-14 16:08:31]: start /root/oceanbase-all-in-one/conf/tmp/db4.sql
[2022-11-14 16:08:31]: end /root/oceanbase-all-in-one/conf/tmp/db4.sql, cost 0.5s
[2022-11-14 16:08:31]: start /root/oceanbase-all-in-one/conf/tmp/db5.sql
[2022-11-14 16:08:32]: end /root/oceanbase-all-in-one/conf/tmp/db5.sql, cost 1.0s
[2022-11-14 16:08:32]: start /root/oceanbase-all-in-one/conf/tmp/db6.sql
[2022-11-14 16:08:32]: end /root/oceanbase-all-in-one/conf/tmp/db6.sql, cost 0.2s
[2022-11-14 16:08:32]: start /root/oceanbase-all-in-one/conf/tmp/db7.sql
[2022-11-14 16:08:34]: end /root/oceanbase-all-in-one/conf/tmp/db7.sql, cost 1.5s
[2022-11-14 16:08:34]: start /root/oceanbase-all-in-one/conf/tmp/db8.sql
[2022-11-14 16:08:34]: end /root/oceanbase-all-in-one/conf/tmp/db8.sql, cost 0.7s
[2022-11-14 16:08:34]: start /root/oceanbase-all-in-one/conf/tmp/db9.sql
[2022-11-14 16:08:41]: end /root/oceanbase-all-in-one/conf/tmp/db9.sql, cost 6.2s
[2022-11-14 16:08:41]: start /root/oceanbase-all-in-one/conf/tmp/db10.sql
[2022-11-14 16:08:42]: end /root/oceanbase-all-in-one/conf/tmp/db10.sql, cost 1.3s
[2022-11-14 16:08:42]: start /root/oceanbase-all-in-one/conf/tmp/db11.sql
[2022-11-14 16:08:42]: end /root/oceanbase-all-in-one/conf/tmp/db11.sql, cost 0.2s
[2022-11-14 16:08:42]: start /root/oceanbase-all-in-one/conf/tmp/db12.sql
[2022-11-14 16:08:44]: end /root/oceanbase-all-in-one/conf/tmp/db12.sql, cost 1.5s
[2022-11-14 16:08:44]: start /root/oceanbase-all-in-one/conf/tmp/db13.sql
[2022-11-14 16:08:46]: end /root/oceanbase-all-in-one/conf/tmp/db13.sql, cost 2.5s
[2022-11-14 16:08:46]: start /root/oceanbase-all-in-one/conf/tmp/db14.sql
[2022-11-14 16:08:47]: end /root/oceanbase-all-in-one/conf/tmp/db14.sql, cost 0.4s
[2022-11-14 16:08:47]: start /root/oceanbase-all-in-one/conf/tmp/db15.sql
[2022-11-14 16:08:47]: end /root/oceanbase-all-in-one/conf/tmp/db15.sql, cost 0.8s
[2022-11-14 16:08:47]: start /root/oceanbase-all-in-one/conf/tmp/db16.sql
[2022-11-14 16:08:48]: end /root/oceanbase-all-in-one/conf/tmp/db16.sql, cost 0.7s
[2022-11-14 16:08:48]: start /root/oceanbase-all-in-one/conf/tmp/db17.sql
[2022-11-14 16:08:49]: end /root/oceanbase-all-in-one/conf/tmp/db17.sql, cost 0.6s
[2022-11-14 16:08:49]: start /root/oceanbase-all-in-one/conf/tmp/db18.sql
[2022-11-14 16:08:50]: end /root/oceanbase-all-in-one/conf/tmp/db18.sql, cost 0.9s
[2022-11-14 16:08:50]: start /root/oceanbase-all-in-one/conf/tmp/db19.sql
[2022-11-14 16:08:50]: end /root/oceanbase-all-in-one/conf/tmp/db19.sql, cost 0.8s
[2022-11-14 16:08:50]: start /root/oceanbase-all-in-one/conf/tmp/db20.sql
[2022-11-14 16:08:52]: end /root/oceanbase-all-in-one/conf/tmp/db20.sql, cost 1.3s
[2022-11-14 16:08:52]: start /root/oceanbase-all-in-one/conf/tmp/db21.sql
[2022-11-14 16:08:54]: end /root/oceanbase-all-in-one/conf/tmp/db21.sql, cost 2.3s
[2022-11-14 16:08:54]: start /root/oceanbase-all-in-one/conf/tmp/db22.sql
[2022-11-14 16:08:55]: end /root/oceanbase-all-in-one/conf/tmp/db22.sql, cost 1.2s
Total Cost: 28.0s