OceanBase TPC-C测试和执行计划查看

最新推荐文章于 2024-03-12 03:28:01 发布
最新推荐文章于 2024-03-12 03:28:01 发布
阅读量1.9k 收藏 1
点赞数 1
文章标签： c语言 mysql 数据库 dba
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_46668148/article/details/122805353
版权

1. 环境需求

  • 单副本集群一套（1个zone，三台机器）
  • BenchmarkSQL

2. 准备BenchmarkSQL

注意：需要java环境，不低于1.8.0 .
下载地址 https://github.com/obpilot/benchmarksql-5.0
jdbc下载地址：https://help.aliyun.com/document_detail/212815.html
创建测试用户和数据库：

MySQL [oceanbase]> create database tpcc;
Query OK, 1 row affected (0.102 sec)

MySQL [oceanbase]> create user tpcc identified by 'ABcd12@#';
Query OK, 0 rows affected (0.095 sec)

MySQL [oceanbase]> grant all on *.* to tpcc;
Query OK, 0 rows affected (0.095 sec)

修改配置文件props.ob (在run目录下)

db=oracle
driver=com.alipay.oceanbase.obproxy.mysql.jdbc.Driver
conn=jdbc:oceanbase://192.168.1.115:2883/tpcc?useUnicode=true&characterEncoding=utf-8
user=tpcc@mytest#obcluster
password=ABcd12@#

warehouses=10	# 仓库数
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=15		# 测试持续15分钟
//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
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

3. 准备数据

sql文件在benchmarksql-5.0-master/run/sql.oceanbase中，看了一些建表语句，使用了varchar2类型，ob为mysql模式，需要修改：

cp tableCreates.sql tableCreates_1zone.sql
sed -i 's/varchar2/varchar/g' tableCreates_1zone.sql

# 建表
./runSQL.sh props.ob sql.oceanbase/tableCreates_1zone.sql

#加载数据
./runLoader.sh props.ob

在这里插入图片描述
如果有报事务超时的，需要调整事务超时参数：

MySQL [oceanbase]> show variables like '%timeout%';
+---------------------+------------------+
| Variable_name       | Value            |
+---------------------+------------------+
| connect_timeout     | 10               |
| interactive_timeout | 28800            |
| lock_wait_timeout   | 31536000         |
| net_read_timeout    | 30               |
| net_write_timeout   | 60               |
| ob_pl_block_timeout | 3216672000000000 |
| ob_query_timeout    | 10000000         |
| ob_trx_idle_timeout | 120000000        |
| ob_trx_lock_timeout | -1               |
| ob_trx_timeout      | 100000000        |
| wait_timeout        | 28800            |
+---------------------+------------------+
11 rows in set (0.021 sec)

MySQL [oceanbase]> set global ob_trx_timeout=10000000000;
Query OK, 0 rows affected (0.056 sec)

MySQL [oceanbase]> set global ob_query_timeout=100000000;
Query OK, 0 rows affected (0.039 sec)

从OCP上下性能监控：
在这里插入图片描述

在这里插入图片描述
可以看到此时的QPS，响应时间等有明显升高。
数据加载完成之后，创建索引。
在这里插入图片描述

./runSQL.sh props.ob sql.oceanbase/indexCreates.sql
# ------------------------------------------------------------
# Loading SQL file sql.oceanbase/indexCreates.sql
# ------------------------------------------------------------
create index bmsql_customer_idx1
on  bmsql_customer (c_w_id, c_d_id, c_last, c_first) local;
create  index bmsql_oorder_idx1
on  bmsql_oorder (o_w_id, o_d_id, o_carrier_id, o_id) local;

做一次合并：
在这里插入图片描述

4. 测试

./runBenchmark.sh props.ob

在这里插入图片描述

等待结果输出：
在这里插入图片描述
测试的详细信息在my_result_2022-02-07_121917/data/result.csv文件中，按需查看。

5. 查看执行计划

找执行过的sql：
执行过的SQL在/home/admin/logs/obproxy/log/obproxy_digest.log中有记录

grep obcluster:eeotest:tpcc obproxy_digest.log | grep SELECT

查看基础执行计划：

explain SELECT c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_since, c_credit, c_credit_lim, c_discount, c_balance FROM bmsql_customer WHERE c_w_id = 7 AND c_d_id = 2 AND c_id = 856;

在这里插入图片描述
查看更为详细的执行计划：

MySQL [tpcc]> explain extended SELECT c_first, c_middle, c_last, c_street_1, c_street_2, c_city, c_state, c_zip, c_phone, c_since, c_credit, c_credit_lim, c_discount, c_balance FROM bmsql_customer WHERE c_w_id = 7 AND c_d_id = 2 AND c_id = 856;
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Query Plan                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ============================================
|ID|OPERATOR |NAME          |EST. ROWS|COST|
--------------------------------------------
|0 |TABLE GET|bmsql_customer|1        |54  |
============================================

Outputs & filters:
-------------------------------------
  0 - output([bmsql_customer.c_first(0x7f84190ded70)], [bmsql_customer.c_middle(0x7f84190df430)], [bmsql_customer.c_last(0x7f84190df950)], [bmsql_customer.c_street_1(0x7f84190dfe70)], [bmsql_customer.c_street_2(0x7f84190e0390)], [bmsql_customer.c_city(0x7f84190e08b0)], [bmsql_customer.c_state(0x7f84190e0dd0)], [bmsql_customer.c_zip(0x7f84190e1470)], [bmsql_customer.c_phone(0x7f84190e1990)], [bmsql_customer.c_since(0x7f84190e1eb0)], [bmsql_customer.c_credit(0x7f84190e23d0)], [bmsql_customer.c_credit_lim(0x7f84190e28f0)], [bmsql_customer.c_discount(0x7f84190e2e10)], [bmsql_customer.c_balance(0x7f84190e34b0)]), filter(nil),
      access([bmsql_customer.c_first(0x7f84190ded70)], [bmsql_customer.c_middle(0x7f84190df430)], [bmsql_customer.c_last(0x7f84190df950)], [bmsql_customer.c_street_1(0x7f84190dfe70)], [bmsql_customer.c_street_2(0x7f84190e0390)], [bmsql_customer.c_city(0x7f84190e08b0)], [bmsql_customer.c_state(0x7f84190e0dd0)], [bmsql_customer.c_zip(0x7f84190e1470)], [bmsql_customer.c_phone(0x7f84190e1990)], [bmsql_customer.c_since(0x7f84190e1eb0)], [bmsql_customer.c_credit(0x7f84190e23d0)], [bmsql_customer.c_credit_lim(0x7f84190e28f0)], [bmsql_customer.c_discount(0x7f84190e2e10)], [bmsql_customer.c_balance(0x7f84190e34b0)]), partitions(p0),
      is_index_back=false,
      range_key([bmsql_customer.c_w_id(0x7f8418ee98e0)], [bmsql_customer.c_d_id(0x7f84190dda70)], [bmsql_customer.c_id(0x7f84190de850)]), range[7,2,856 ; 7,2,856],
      range_cond([bmsql_customer.c_w_id(0x7f8418ee98e0) = 7(0x7f8418ee9260)], [bmsql_customer.c_d_id(0x7f84190dda70) = 2(0x7f84190dd3f0)], [bmsql_customer.c_id(0x7f84190de850) = 856(0x7f84190de1d0)])

Used Hint:
-------------------------------------
  /*+
  */

Outline Data:
-------------------------------------
  /*+
      BEGIN_OUTLINE_DATA
      FULL(@"SEL$1" "tpcc.bmsql_customer"@"SEL$1")
      END_OUTLINE_DATA
  */

Plan Type:
-------------------------------------
LOCAL

Optimization Info:
-------------------------------------

bmsql_customer:table_rows:300000, physical_range_rows:1, logical_range_rows:1, index_back_rows:0, output_rows:1, est_method:local_storage, optimization_method=rule_based, heuristic_rule=unique_index_without_indexback

Parameters
-------------------------------------
 |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.005 sec)

从TABLE GET ， is_index_back=false可以看出走了索引，没有回表查，索引覆盖了，unique_index_without_indexback。
再找一条SQL查看执行计划：
在这里插入图片描述
在这里插入图片描述
可以看到上面两条SQL的OPERATOR都是TABLE GET，表示都是走主键定位，可以说就是最优了。

6. 创建outline

outline有两种语法：
注意：连接ob时命令行要指定-c，否则会忽略hint

/* 使用 SQL_TEXT 创建 Outline */
CREATE [OR REPLACE] OUTLINE outline_name ON stmt [ TO target_stmt ]

/* 使用 SQL_ID 创建 Outline */
CREATE OUTLINE outline_name ON sql_id USING HINT  hint;

如果使用SQL_ID 来创建，需要查询SQL_ID.

# 以 SELECT d_tax, d_next_o_id FROM bmsql_district WHERE d_w_id = 9 AND d_id = 3; 为例子。
use oceanbase
MySQL [oceanbase]> select * from gv$sql where SQL_TEXT like 'SELECT d_tax, d_next_o_id FROM bmsql_district WHERE d_w_id =%'\G
*************************** 1. row ***************************
               CON_ID: 1001
               SVR_IP: 10.1.38.112
             SVR_PORT: 2882
              PLAN_ID: 7334
               SQL_ID: 8D9BE1431EDD25A3120C78D89F3CDADC
                 TYPE: 1
             SQL_TEXT: SELECT d_tax, d_next_o_id FROM bmsql_district WHERE d_w_id = ? AND d_id = ?
      PLAN_HASH_VALUE: 10891013227342761743
      FIRST_LOAD_TIME: 2022-02-07 17:49:03.682029
     LAST_ACTIVE_TIME: 2022-02-07 17:49:03.682528
         AVG_EXE_USEC: 3387
     SLOWEST_EXE_TIME: 2022-02-07 17:49:03.682528
     SLOWEST_EXE_USEC: 3387
           SLOW_COUNT: 0
            HIT_COUNT: 0
            PLAN_SIZE: 48848
           EXECUTIONS: 1
           DISK_READS: 0
        DIRECT_WRITES: 0
          BUFFER_GETS: 0
APPLICATION_WAIT_TIME: 0
CONCURRENCY_WAIT_TIME: 0
    USER_IO_WAIT_TIME: 0
       ROWS_PROCESSED: 1
         ELAPSED_TIME: 3387
             CPU_TIME: 3295
1 row in set (0.088 sec)

# 创建outline
CREATE OUTLINE bmsql_district_ol1 on '8D9BE1431EDD25A3120C78D89F3CDADC' using hint  /*+ parallel(4)*/ ;

# 查看outline是否生效
MySQL [tpcc]>  SELECT * FROM oceanbase.gv$outline WHERE OUTLINE_NAME = 'bmsql_district_ol1';
+-----------+------------------+------------------+---------------+--------------------+-------------------+----------+----------------+-------------+
| tenant_id | database_id      | outline_id       | database_name | outline_name       | visible_signature | sql_text | outline_target | outline_sql |
+-----------+------------------+------------------+---------------+--------------------+-------------------+----------+----------------+-------------+
|      1001 | 1100611139404829 | 1100611139404779 | tpcc          | bmsql_district_ol1 |                   |          |                |             |
+-----------+------------------+------------------+---------------+--------------------+-------------------+----------+----------------+-------------+
1 row in set (0.005 sec)

# 发现并没有生效。
# 使用SQL语句创建outline
MySQL [tpcc]> create outline bmsql_district_ol2 on SELECT/*+ parallel(4) */ d_tax, d_next_o_id FROM bmsql_district WHERE d_w_id = 9 AND d_id = 3;
Query OK, 0 rows affected (0.046 sec)

MySQL [tpcc]>  SELECT * FROM oceanbase.gv$outline WHERE OUTLINE_NAME = 'bmsql_district_ol1';
+-----------+------------------+------------------+---------------+--------------------+-------------------+----------+----------------+-------------+
| tenant_id | database_id      | outline_id       | database_name | outline_name       | visible_signature | sql_text | outline_target | outline_sql |
+-----------+------------------+------------------+---------------+--------------------+-------------------+----------+----------------+-------------+
|      1001 | 1100611139404829 | 1100611139404779 | tpcc          | bmsql_district_ol1 |                   |          |                |             |
+-----------+------------------+------------------+---------------+--------------------+-------------------+----------+----------------+-------------+
1 row in set (0.014 sec)

MySQL [tpcc]>  SELECT * FROM oceanbase.gv$outline WHERE OUTLINE_NAME = 'bmsql_district_ol2';
+-----------+------------------+------------------+---------------+--------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------+----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tenant_id | database_id      | outline_id       | database_name | outline_name       | visible_signature                                                           | sql_text                                                                                      | outline_target | outline_sql                                                                                                                                                                   |
+-----------+------------------+------------------+---------------+--------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------+----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|      1001 | 1100611139404829 | 1100611139404780 | tpcc          | bmsql_district_ol2 | SELECT d_tax, d_next_o_id FROM bmsql_district WHERE d_w_id = ? AND d_id = ? | SELECT/*+ parallel(4) */ d_tax, d_next_o_id FROM bmsql_district WHERE d_w_id = 9 AND d_id = 3 |                | SELECT /*+ BEGIN_OUTLINE_DATA FULL(@"SEL$1" "tpcc.bmsql_district"@"SEL$1") PARALLEL(4) END_OUTLINE_DATA*/d_tax, d_next_o_id FROM bmsql_district WHERE d_w_id = 9 AND d_id = 3 |
+-----------+------------------+------------------+---------------+--------------------+-----------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------+----------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.045 sec)

# 手动指定hint，查看执行计划
MySQL [tpcc]> explain extended SELECT/*+ parallel(4) */ d_tax, d_next_o_id FROM bmsql_district WHERE d_w_id = 9 AND d_id = 3;
+-----------------------------------------------------------------------------------------------------------------------+
| Query Plan                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |
+-----------------------------------------------------------------------------------------------------------------------+
| ======================================================
|ID|OPERATOR           |NAME          |EST. ROWS|COST|
------------------------------------------------------
|0 |PX COORDINATOR     |              |1        |53  |
|1 | EXCHANGE OUT DISTR|:EX10000      |1        |53  |
|2 |  PX BLOCK ITERATOR|              |1        |53  |
|3 |   TABLE GET       |bmsql_district|1        |53  |
======================================================

Outputs & filters:
-------------------------------------
  0 - output([bmsql_district.d_tax(0x7faecea8aab0)], [bmsql_district.d_next_o_id(0x7faecea8afd0)]), filter(nil)
  1 - output([bmsql_district.d_tax(0x7faecea8aab0)], [bmsql_district.d_next_o_id(0x7faecea8afd0)]), filter(nil), dop=4
  2 - output([bmsql_district.d_tax(0x7faecea8aab0)], [bmsql_district.d_next_o_id(0x7faecea8afd0)]), filter(nil)
  3 - output([bmsql_district.d_tax(0x7faecea8aab0)], [bmsql_district.d_next_o_id(0x7faecea8afd0)]), filter(nil),
      access([bmsql_district.d_tax(0x7faecea8aab0)], [bmsql_district.d_next_o_id(0x7faecea8afd0)]), partitions(p0),
      is_index_back=false,
      range_key([bmsql_district.d_w_id(0x7faecea6e9e0)], [bmsql_district.d_id(0x7faecea8a590)]), range[9,3 ; 9,3],
      range_cond([bmsql_district.d_w_id(0x7faecea6e9e0) = 9(0x7faecea6e360)], [bmsql_district.d_id(0x7faecea8a590) = 3(0x7faecea89f10)])

Used Hint:
-------------------------------------
  /*+
      PARALLEL(4)
  */

Outline Data:
-------------------------------------
  /*+
      BEGIN_OUTLINE_DATA
      FULL(@"SEL$1" "tpcc.bmsql_district"@"SEL$1")
      PARALLEL(4)
      END_OUTLINE_DATA
  */

Plan Type:
-------------------------------------
DISTRIBUTED

Optimization Info:
-------------------------------------




bmsql_district:table_rows:100, physical_range_rows:1, logical_range_rows:1, index_back_rows:0, output_rows:1, est_method:local_storage, optimization_method=rule_based, heuristic_rule=unique_index_without_indexback

Parameters
-------------------------------------
 |
+-----------------------------------------------------------------------------------------------------------------------+
1 row in set (0.004 sec)

可能是outline并没有在执行计划中展示：
通过查询gv$plan_cache_plan_stat可以看到outline_id不为-1，表示执行计划已经绑定。

MySQL [tpcc]> select * from oceanbase.gv$plan_cache_plan_stat where query_sql like 'SELECT * FROM bmsql_district2 WHERE d_w_id = 9 AND d_id = 3%'\G
*************************** 1. row ***************************
            tenant_id: 1001
               svr_ip: 10.1.38.113
             svr_port: 2882
              plan_id: 6060
               sql_id: 969DD3AAE35A71E46B81C29AE226E692
                 type: 3
    is_bind_sensitive: 0
        is_bind_aware: 0
                db_id: 18446744073709551615
            statement: SELECT * FROM bmsql_district2 WHERE d_w_id = ? AND d_id = ?
            query_sql: SELECT * FROM bmsql_district2 WHERE d_w_id = 9 AND d_id = 3
       special_params:
          param_infos: {1,0,0,0,5},{1,0,0,0,5}
             sys_vars: 45,4194304,2,4,1,0,0,32,3,1,0,1,1,0,10485760,1,1,0,1,BINARY,BINARY,AL32UTF8,AL32UTF8,BYTE,FALSE,1,100,64,200,0,13,NULL,1,1,1
            plan_hash: 4355160801114405601
      first_load_time: 2022-02-07 20:29:27.145922
       schema_version: 1644236952315912
       merged_version: 25
     last_active_time: 2022-02-07 20:29:27.157579
         avg_exe_usec: 23869
     slowest_exe_time: 2022-02-07 20:29:27.157579
     slowest_exe_usec: 23869
           slow_count: 0
            hit_count: 0
            plan_size: 81616
           executions: 1
           disk_reads: 0
        direct_writes: 0
          buffer_gets: 5
application_wait_time: 0
concurrency_wait_time: 2008
    user_io_wait_time: 0
       rows_processed: 1
         elapsed_time: 23869
             cpu_time: 20313
         large_querys: 0
 delayed_large_querys: 0
    delayed_px_querys: 0
      outline_version: 1644236952309632
           outline_id: 1100611139404785
         outline_data: /*+ BEGIN_OUTLINE_DATA FULL(@"SEL$1" "tpcc.bmsql_district2"@"SEL$1") PARALLEL(4) END_OUTLINE_DATA*/
         acs_sel_info:
           table_scan: 0
            evolution: 0
       evo_executions: 0
         evo_cpu_time: 0
        timeout_count: 0
           ps_stmt_id: -1
               sessid: 0
          temp_tables:
           is_use_jit: 0
          object_type: SQL_PLAN
           hints_info:  PARALLEL(4)
     hints_all_worked: 1
         pl_schema_id: NULL
is_batched_multi_stmt: 0
1 row in set (0.029 sec)

select * from oceanbase.gv$outline ;
+-----------+------------------+------------------+---------------+--------------------+------------------------------------------------------------+------------------------------------------------------------------------------+----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tenant_id | database_id      | outline_id       | database_name | outline_name       | visible_signature                                          | sql_text                                                                     | outline_target | outline_sql                                                                                                                                                  |
+-----------+------------------+------------------+---------------+--------------------+------------------------------------------------------------+------------------------------------------------------------------------------+----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
|      1001 | 1100611139404829 | 1100611139404783 | tpcc          | bmsql_district_ol1 | SELECT * FROM bmsql_district WHERE d_w_id = ? AND d_id = ? | SELECT/*+ parallel(4) */ * FROM bmsql_district WHERE d_w_id = 9 AND d_id = 3 |                | SELECT /*+ BEGIN_OUTLINE_DATA FULL(@"SEL$1" "tpcc.bmsql_district"@"SEL$1") PARALLEL(4) END_OUTLINE_DATA*/* FROM bmsql_district WHERE d_w_id = 9 AND d_id = 3 |
|      1001 | 1100611139404829 | 1100611139404784 | tpcc          | outline2           |                                                            |                                                                              |                |                                                                                                                                                              |
|      1001 | 1100611139404829 | 1100611139404785 | tpcc          | outline3           |                                                            |                                                                              |                |                                                                                                                                                              |
+-----------+------------------+------------------+---------------+--------------------+------------------------------------------------------------+------------------------------------------------------------------------------+----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
3 rows in set (0.026 sec)
ReadVersion
关注
  • 1
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
tpcc-mysql使用手册_tpcc使用说明
weixin_39586915的博客
01-30 703
tpcc使用说明说明：文章内容起源于网络并结合自己的实验而得；但参考的文章地址当时没记录下来，如果发现有侵权问题，请留言。一、介绍压力测试是指在MySQL上线前，需要进行大量的压力测试，从而达到交付的标准。压力测试不仅可以测试MySQL服务的稳定性，还可以测试出MySQL和系统的瓶颈。TPCC测试：Transaction Processing Performance Council，要熟练使用TP...
学习使用TPC-C测试
qq_41774929的博客
06-02 2361
一、前言TPC－C是在线事务处理(OLTP)的基准程序，用于衡量数据库系统OLTP性能的指标。本次TPC－C将会使用到BenchmarkSQL工具OLTP:On-Line Transaction Processing 联机事务处理,也称为面向交易的处理系统，其基本特征是顾客的原始数据可以立即传送到计算中心进行处理，并在很短的时间内给出处理结果。这样做的最大特点是可以即时地处理输入的数据，及时地回答。所以也称为实时系统。BenchmarkSQL工具介绍该工具为开源软件，采用范围更广泛；基于JAVA语言开发，跨
Oceanbase使用BenchmarkSQL 进行tpcc测试及执行计划查询
最新发布
ChunkWen的博客
03-12 680
操作系统：redhat7.9内核版本：3.10.0-1160.el7.x86_64Ocaenbase集群版本：社区版单副本集群，3.1.0，租户为mysql模式Benchmarksql要求jdk8版本及以上的java环境创建tablegroup的语句，表组名不能使用双引号，需要删除双引号；删除创建sequence的语句。查看执行计划的一般步骤（可选）查询oceanbase.gv$sql_audit 视图获取top sql，获取tenant_idsvr_ipsvr_portsql_id。
[MySQL]-压力测试之TPCC-MySQL
liangsena的博客
11-30 2756
对数据库学习来说，压力测试也是十分必要的一环，本文章主要介绍了TPCC-MySQL这个工具的使用。
蚂蚁金服OceanBase挑战TPCC|TPC-C基准测试之数据库事务引擎挑战
阿里云云栖号
10-09 1201
蚂蚁金服自研数据库 OceanBase 登顶 TPC-C 引起业内广泛关注，为了更清楚的展示其中的技术细节，我们特意邀请 OceanBase 核心研发人员对本次测试进行技术解读，共包括五篇： 1）TPC-C基准测试介绍 2）OceanBase如何做TPC-C测试 3）TPC-C基准测试之SQL优化 4）TPC-C基准测试之数据库事务引擎的挑战 5）TPC-C基准测试之存储优化 OceanBas...
db2数据库的TPC-C测试脚本
05-10
DB2的TPC-C测试脚本是用于执行TPC-C交易的一系列程序，这些交易包括新订单、支付、订单状态、配送和库存水平更新等。这些交易模拟了真实世界中的业务场景，例如购物、支付和库存管理，从而评估数据库在高并发、复杂...
TPC-DS tools压测工具源码下载TPC-DS_Tools_v3.2.0.zip
06-22
5. **性能测试**：DSGen生成的数据集可以配合其他工具（如Apache Hive、Impala或Spark SQL）执行TPC-DS的查询集，这些查询涵盖了各种复杂的SQL操作，以全面评估系统的查询性能、并发处理能力和稳定性。 6. **结果...
基于OceanBase的tpcc测试
01-25
OceanBase数据库TPCC测试 OceanBase数据库TPCC测试是基于OceanBase数据库的... OceanBase数据库的TPCC测试可以通过Ant来安装和执行。在安装过程中，需要下载和解压缩Ant安装包，设置环境变量，并检查是否安装成功。
spark-tpc-ds-performance-test：使用TPC-DS基准测试Spark SQL性能
02-03
Jupyter Notebook作为交互式计算环境，为数据分析和代码调试提供了便利，使得我们可以直观地查看查询结果和执行时间。 在“spark-tpc-ds-performance-test-master”压缩包中，可能包含以下内容： 1. **配置文件**...
解析大数据基准测试——TPC-HorTPC-DS
03-03
本文中，谭磊讲解了大数据测试基准应该具有的要素，并以此为基础对比了现有的大数据测试基准，然后重点讨论TPC-DS测试基准。随着开源Hapdoop、Map/Reduce、Spark、HDFS、HBASE等技术的商用化，大数据管理技术得到了...
实践练习六（必选）：OceanBase TPC-C 测试和查看 执行计划
你的世界是你创造的结果
02-18 1774
实践练习六（必选）：OceanBase TPC-C 测试和查看 执行计划 练习目的 本次练习目的掌握 OceanBase 的执行计划查看方法，包括 explain 命令和查看实际执行计划。 练习条件 有 服务器，内存资源至少 12G*1 台，部署有 OceanBase 集群（单副本或三副本都可以）。 练习内容 请记录并分享下列内容： （必选）使用 BenmarkSQL 运行 TPC-C ，并发数不用很高，5~10 并发即可（根据机器资源）。 （必选）分析 TPC-C TOP SQL，并查看 3条 S
5.TPC-C测试工具——创建事务过程
badman250的专栏
09-25 6634
5.TPC-C测试工具——创建事务过程   所谓存储过程(Stored Procedure)，就是一组用于完成特定数据库功能的SQL 语句集，该SQL语句集经过编译后存储在数据库系统中。在使用时候，用户通过指定已经定义的存储过程名字并给出相应的存储过程参数来调用并执行它，从而完成一个或一系列的数据库操作。            TPC-C主要是包含5个事务，在此创建5个事务过程，如下。 1
国产数据库 OceanBase 二次刷榜 TPC-C，7 亿 tpmC！
CSDN资讯
05-21 3091
作者 | 马超责编 | 伍杏玲出品 | CSDN（ID：CSDNnews）5月20日，世界上权威数据库评测机构——国际事务处理性能委员会（TPC），发布最新评测榜单，蚂蚁金服自研的分布式...
OceanBase 二次 TPC-C 测试性能提升 10 倍
llawliet0001的专栏
06-08 455
导读 时隔半年，蚂蚁金服的自研数据库 OceanBase 又去做了 TPC-C 测试。TPC 去年10月2日和今年5月20日公布的测试结果显示，OceanBase都是榜单第一。性能方面，去年OceanBase 的测试结果是6088万 tpmC，今年则是7.07亿 tpmC；TPC-C benchmark 价格也从￥6.25/tpmC 降低到￥3.98/tpmC。不过，一些数据库公司，如Oracle并未参与这两次测试。 测试结果 OceanBase 是一个支持海量数据的高性能分布式数据库系统，
Tpcc-MySQL对mysql数据库进行性能测试报告、分析及使用gnuplot生成图表展示
reblue520的专栏
03-31 654
TPC-C是专门针对联机交易处理系统（OLTP系统）的规范，一般情况下我们也把这类系统称为业务处理系统。 tpcc-mysql是percona基于TPC-C(下面简写成TPCC)衍生出来的产品，专用于MySQL基准测试。其源码放在launchpad上，用bazaar管理，项目地址：https://code.launchpad.net/~percona-dev/perconato...
如何有效进行测试执行进度计划
伤心的辣条
02-14 1399
例如：假如项目产品发布的时间是确定的，或者根据市场或客户的需求是受到限制的，那么在有限的时间内，需要在有限的测试人力资源和其他的测试资源与测试质量之间进行来平衡，即测试执行进度计划的制订，需要我们在有限的测试时间内，利用现有的测试资源，达到既定的测试质量。针对测试执行而进行的计划，即测试执行进度计划，是进行测试执行进度控制的基础。除了上面提到的过程成熟度、测试的时间、测试的规模、测试的资源、产品的质量和测试的文档等因素之外，作为测试经理，在进行测试执行进度计划制订过程中，还需要考虑一些其他的因素或者风险。
分享：软件全面升级，10款数据库TPC-C测评哪家强
OceanBase分布式数据库的博客
03-24 3785
本文来自OceanBase社区分享，仅限交流探讨。原作者风华流沙，武汉东方赛思数据部总负责人。
oceanbase mysql 测试_蚂蚁金服OceanBase挑战TPCC | 测试流程解析
weixin_36108036的博客
02-05 485
原标题：蚂蚁金服OceanBase挑战TPCC | 测试流程解析蚂蚁金服自研数据库 OceanBase 登顶 TPC-C 引起业内广泛关注，为了更清楚的展示其中的技术细节，我们特意邀请 OceanBase 核心研发人员对本次测试进行技术解读，共包括五篇：2)OceanBase如何做TPC-C测试3)TPC-C基准测试之SQL优化4)TPC-C基准测试之数据库事务引擎的挑战5)TPC-C基准测试之存...
1.TPC-C测试工具一——TPC-C简介
热门推荐
badman250的专栏
09-24 1万+
1.TPC-C测试工具一——TPC-C简介 1.  TPC-C简介 TPCC值被广泛用于衡量C/S环境下,由服务器和客户端构筑的整体系统的性能,它由事物处理性能委员会（TPC，Transaction Processing Corp）制定,TPC为非赢利性国际组织。     TPCC值可以反映出系统的性能价格比。TPCC测试系统每分钟处理的任务数,单位为tpm,(transactions

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值