查看 OceanBase 执行计划

最新推荐文章于 2024-02-22 10:27:33 发布
最新推荐文章于 2024-02-22 10:27:33 发布
阅读量1.7k 收藏
点赞数
分类专栏： OceanBase 文章标签： mysql java 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/xk_xx/article/details/122777784
版权

一、环境准备

1.下载benchmarksql

wget -c https://jaist.dl.sourceforge.net/project/benchmarksql/benchmarksql-5.0.zip
unzip benchmarksql-5.0.zip

2.编辑配置文件

[admin@10 run]$ cd /home/admin/benchmarksql-5.0/run
[admin@10 run]$ vi props.ob
db=oracle
driver=com.alipay.oceanbase.obproxy.mysql.jdbc.Driver
//driver=com.alipay.oceanbase.jdbc.Driver
conn=jdbc:oceanbase://127.0.0.1:2883/obtest?useUnicode=true&characterEncoding=utf-8
user=root@sys#obdemo
password=123456
warehouses=2
loadWorkers=1
terminals=5
//To run specified transactions per terminal- runMins must equal zero
runTxnsPerTerminal=0
//To run for specified minutes- runTxnsPerTerminal must equal zero
runMins=5
//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
[root@localhost run]# pwd
/home/admin/benchmarksql-5.0/run

3.执行建表脚本

[admin@10 run]$ ./runSQL.sh props.ob sql.common/tableCreates.sql
# ------------------------------------------------------------
# Loading SQL file sql.common/tableCreates.sql
# ------------------------------------------------------------

4.导入数据

[admin@10 run]$ ./runLoader.sh props.ob
Starting BenchmarkSQL LoadData
driver=com.alipay.oceanbase.obproxy.mysql.jdbc.Driver
conn=jdbc:oceanbase://127.0.0.1:2883/obtest?useUnicode=true&characterEncoding=utf-8
user=root@sys#obdemo
password=***********
warehouses=2
loadWorkers=1
fileLocation (not defined)
csvNullValue (not defined - using default 'NULL')
Worker 000: Loading ITEM
Worker 000: Loading ITEM done
Worker 000: Loading Warehouse      1
Worker 000: Loading Warehouse      1 done
Worker 000: Loading Warehouse      2
Worker 000: Loading Warehouse      2 done
MySQL [obtest]> show databases;
+--------------------+
| Database           |
+--------------------+
| oceanbase          |
| information_schema |
| mysql              |
| SYS                |
| LBACSYS            |
| ORAAUDITOR         |
| test               |
| obtest             |
+--------------------+
8 rows in set (0.004 sec)
MySQL [obtest]> use obtest;
Database changed
MySQL [obtest]> show tables;
+------------------+
| Tables_in_obtest |
+------------------+
| bmsql_config     |
| bmsql_customer   |
| bmsql_district   |
| bmsql_history    |
| bmsql_item       |
| bmsql_new_order  |
| bmsql_oorder     |
| bmsql_order_line |
| bmsql_stock      |
| bmsql_warehouse  |
| customer         |
| district         |
| history          |
| item             |
| new_orders       |
| order_line       |
| orders           |
| stock            |
| warehouse        |
+------------------+
19 rows in set (0.002 sec)
MySQL [obtest]> select count(*) from bmsql_item;
+----------+
| count(*) |
+----------+
|   100000 |
+----------+
1 row in set (0.210 sec)

5.执行测试脚本

[admin@10 run]$ ./runBenchmark.sh props.ob
18:26:13,935 [main] INFO   jTPCC : Term-00,
18:26:13,938 [main] INFO   jTPCC : Term-00, +-------------------------------------------------------------+
18:26:13,938 [main] INFO   jTPCC : Term-00,      BenchmarkSQL v5.0
18:26:13,939 [main] INFO   jTPCC : Term-00, +-------------------------------------------------------------+
18:26:13,939 [main] INFO   jTPCC : Term-00,  (c) 2003, Raul Barbosa
18:26:13,940 [main] INFO   jTPCC : Term-00,  (c) 2004-2016, Denis Lussier
18:26:13,945 [main] INFO   jTPCC : Term-00,  (c) 2016, Jan Wieck
18:26:13,945 [main] INFO   jTPCC : Term-00, +-------------------------------------------------------------+
18:26:13,945 [main] INFO   jTPCC : Term-00,
18:26:13,945 [main] INFO   jTPCC : Term-00, db=oracle
18:26:13,945 [main] INFO   jTPCC : Term-00, driver=com.alipay.oceanbase.obproxy.mysql.jdbc.Driver
18:26:13,945 [main] INFO   jTPCC : Term-00, conn=jdbc:oceanbase://10.0.2.15:2883/obtest?useUnicode=true&characterEncoding=utf-8
18:26:13,945 [main] INFO   jTPCC : Term-00, user=root@sys#obdemo
18:26:13,945 [main] INFO   jTPCC : Term-00,
18:26:13,945 [main] INFO   jTPCC : Term-00, warehouses=2
18:26:13,945 [main] INFO   jTPCC : Term-00, terminals=5
18:26:13,947 [main] INFO   jTPCC : Term-00, runMins=5
18:26:13,947 [main] INFO   jTPCC : Term-00, limitTxnsPerMin=0
18:26:13,947 [main] INFO   jTPCC : Term-00, terminalWarehouseFixed=true
18:26:13,947 [main] INFO   jTPCC : Term-00,
18:26:13,947 [main] INFO   jTPCC : Term-00, newOrderWeight=45
18:26:13,947 [main] INFO   jTPCC : Term-00, paymentWeight=43
18:26:13,948 [main] INFO   jTPCC : Term-00, orderStatusWeight=4
18:26:13,948 [main] INFO   jTPCC : Term-00, deliveryWeight=4
18:26:13,948 [main] INFO   jTPCC : Term-00, stockLevelWeight=4
18:26:13,948 [main] INFO   jTPCC : Term-00,
18:26:13,948 [main] INFO   jTPCC : Term-00, resultDirectory=my_result_%tY-%tm-%td_%tH%tM%tS
18:26:13,949 [main] INFO   jTPCC : Term-00, osCollectorScript=./misc/os_collector_linux.py
18:26:13,949 [main] INFO   jTPCC : Term-00,
18:26:13,964 [main] INFO   jTPCC : Term-00, copied props.ob to my_result_2022-02-02_182613/run.properties
18:26:13,964 [main] INFO   jTPCC : Term-00, created my_result_2022-02-02_182613/data/runInfo.csv for runID 21
18:26:13,964 [main] INFO   jTPCC : Term-00, writing per transaction results to my_result_2022-02-02_182613/data/result.csv
18:26:13,965 [main] INFO   jTPCC : Term-00, osCollectorScript=./misc/os_collector_linux.py
18:26:13,965 [main] INFO   jTPCC : Term-00, osCollectorInterval=1
18:26:13,965 [main] INFO   jTPCC : Term-00, osCollectorSSHAddr=null
18:26:13,965 [main] INFO   jTPCC : Term-00, osCollectorDevices=null
18:26:14,059 [main] INFO   jTPCC : Term-00,
18:26:15,031 [main] INFO   jTPCC : Term-00, C value for C_LAST during load: 24
18:26:15,032 [main] INFO   jTPCC : Term-00, C value for C_LAST this run:    121
18:26:15,032 [main] INFO   jTPCC : Term-00,                                                                                              Term-00, Running Average tpmTOTAL: 7.33    Cur18:32:31,802 [Thread-4] INFO   jTPCC : Term-00,
18:32:31,802 [Thread-4] INFO   jTPCC : Term-00,
18:32:31,802 [Thread-4] INFO   jTPCC : Term-00, Measured tpmC (NewOrders) = 2.86
18:32:31,803 [Thread-4] INFO   jTPCC : Term-00, Measured tpmTOTAL = 7.33
18:32:31,803 [Thread-4] INFO   jTPCC : Term-00, Session Start     = 2022-02-02 18:26:15
18:32:31,803 [Thread-4] INFO   jTPCC : Term-00, Session End       = 2022-02-02 18:32:31
18:32:31,803 [Thread-4] INFO   jTPCC : Term-00, Transaction Count = 45

二、查看TOP 10

SELECT/*+ PARALLEL(15)*/ SQL_ID, COUNT(*) AS QPS, AVG(t1.elapsed_time) RT 
                FROM oceanbase.gv$sql_audit t1 WHERE tenant_id = 1001 AND 
                IS_EXECUTOR_RPC = 0 AND request_time > (time_to_usec(now()) - 10000000)  AND 
                request_time < time_to_usec (now()) 
                GROUP BY t1.sql_id ORDER BY QPS DESC LIMIT 10;

在这里插入图片描述

三、查看执行计划

SELECT sum(ol_amount) AS sum_ol_amount     FROM bmsql_order_line     WHERE ol_w_id = 2 AND ol_d_id = 4 AND ol_o_id = 2119;
SELECT s_quantity, s_data,        s_dist_01, s_dist_02, s_dist_03, s_dist_04,        s_dist_05, s_dist_06, s_dist_07, s_dist_08,        s_dist_09, s_dist_10     FROM bmsql_stock     WHERE s_w_id = 1 AND s_i_id = 44448     FOR UPDATE;
UPDATE bmsql_stock     SET s_quantity = 50, s_ytd = s_ytd + 1,         s_order_cnt = s_order_cnt + 1,         s_remote_cnt = s_remote_cnt + 0     WHERE s_w_id = 2 AND s_i_id = 12177;
SQL: SELECT sum(ol_amount) AS sum_ol_amount FROM bmsql_order_line WHERE ol_w_id = 2 AND ol_d_id = 4 AND ol_o_id = 2119;
查看格式化信息
======================================================
|ID|OPERATOR       |NAME            |EST. ROWS|COST  |
------------------------------------------------------
|0 |SCALAR GROUP BY|                |1        |720140|
|1 | TABLE SCAN    |bmsql_order_line|1        |720140|
======================================================
Outputs & filters: 
-------------------------------------
  0 - output([T_FUN_SUM(bmsql_order_line.ol_amount(0x7f42ab91ab10))(0x7f42ab91a500)]), filter(nil), 
      group(nil), agg_func([T_FUN_SUM(bmsql_order_line.ol_amount(0x7f42ab91ab10))(0x7f42ab91a500)])
  1 - output([bmsql_order_line.ol_amount(0x7f42ab91ab10)]), filter([bmsql_order_line.ol_w_id(0x7f433871e0f0) = 2(0x7f433871da70)], [bmsql_order_line.ol_d_id(0x7f42ab919490) = 4(0x7f42ab918e10)], [bmsql_order_line.ol_o_id(0x7f42ab91a270) = 2119(0x7f42ab919bf0)]), 
      access([bmsql_order_line.ol_w_id(0x7f433871e0f0)], [bmsql_order_line.ol_d_id(0x7f42ab919490)], [bmsql_order_line.ol_o_id(0x7f42ab91a270)], [bmsql_order_line.ol_amount(0x7f42ab91ab10)]), partitions(p0), 
      is_index_back=false, filter_before_indexback[false,false,false], 
      range_key([bmsql_order_line.__pk_increment(0x7f4338727940)]), range(MIN ; MAX)always true
Used Hint:
-------------------------------------
  /*+
  */
Outline Data:
-------------------------------------
  /*+
      BEGIN_OUTLINE_DATA
      FULL(@"SEL$1" "obtest.bmsql_order_line"@"SEL$1")
      END_OUTLINE_DATA
  */
Plan Type:
-------------------------------------
LOCAL
Optimization Info:
-------------------------------------
bmsql_order_line:table_rows:335632, physical_range_rows:606672, logical_range_rows:335632, index_back_rows:0, output_rows:0, est_method:local_storage, optimization_method=cost_based, avaiable_index_name[bmsql_order_line], estimation info[table_id:1099511677808, (table_type:1, version:0-1-1, logical_rc:0, physical_rc:0), (table_type:7, version:1-1643711135349663-1643711137230299, logical_rc:0, physical_rc:268776), (table_type:7, version:1643711137230299-1643773772120042-1643773772120042, logical_rc:335423, physical_rc:337244), (table_type:5, version:1643711137230299-1643773772120042-1643773772120042, logical_rc:0, physical_rc:0), (table_type:0, version:1643773772120042-1643773772120042-9223372036854775807, logical_rc:209, physical_rc:652)]
Parameters
-------------------------------------
SQL: SELECT s_quantity, s_data, s_dist_01, s_dist_02, s_dist_03, s_dist_04, s_dist_05, s_dist_06, s_dist_07, s_dist_08, s_dist_09, s_dist_10 FROM bmsql_stock WHERE s_w_id = 1 AND s_i_id = 44448 FOR UPDATE;
查看格式化信息
============================================
|ID|OPERATOR  |NAME       |EST. ROWS|COST  |
--------------------------------------------
|0 |TABLE SCAN|bmsql_stock|11       |250911|
============================================
Outputs & filters: 
-------------------------------------
  0 - output([bmsql_stock.s_quantity(0x7f42973199b0)], [bmsql_stock.s_data(0x7f4297319ed0)], [bmsql_stock.s_dist_01(0x7f429731a3f0)], [bmsql_stock.s_dist_02(0x7f429731a910)], [bmsql_stock.s_dist_03(0x7f433871eba0)], [bmsql_stock.s_dist_04(0x7f433871f0c0)], [bmsql_stock.s_dist_05(0x7f433871f5e0)], [bmsql_stock.s_dist_06(0x7f433871fb00)], [bmsql_stock.s_dist_07(0x7f4338720020)], [bmsql_stock.s_dist_08(0x7f4338720540)], [bmsql_stock.s_dist_09(0x7f4338720be0)], [bmsql_stock.s_dist_10(0x7f4338721100)]), filter([bmsql_stock.s_w_id(0x7f433871e0e0) = 1(0x7f433871da60)], [bmsql_stock.s_i_id(0x7f4297319490) = 44448(0x7f4297318e10)]), 
      access([bmsql_stock.__pk_increment(0x7f4297363a50)], [bmsql_stock.s_w_id(0x7f433871e0e0)], [bmsql_stock.s_i_id(0x7f4297319490)], [bmsql_stock.s_quantity(0x7f42973199b0)], [bmsql_stock.s_data(0x7f4297319ed0)], [bmsql_stock.s_dist_01(0x7f429731a3f0)], [bmsql_stock.s_dist_02(0x7f429731a910)], [bmsql_stock.s_dist_03(0x7f433871eba0)], [bmsql_stock.s_dist_04(0x7f433871f0c0)], [bmsql_stock.s_dist_05(0x7f433871f5e0)], [bmsql_stock.s_dist_06(0x7f433871fb00)], [bmsql_stock.s_dist_07(0x7f4338720020)], [bmsql_stock.s_dist_08(0x7f4338720540)], [bmsql_stock.s_dist_09(0x7f4338720be0)], [bmsql_stock.s_dist_10(0x7f4338721100)]), partitions(p0), 
      is_index_back=false, filter_before_indexback[false,false], 
      range_key([bmsql_stock.__pk_increment(0x7f4297363a50)]), range(MIN ; MAX)always true
Used Hint:
-------------------------------------
  /*+
  */
Outline Data:
-------------------------------------
  /*+
      BEGIN_OUTLINE_DATA
      FULL(@"SEL$1" "obtest.bmsql_stock"@"SEL$1")
      END_OUTLINE_DATA
  */
Plan Type:
-------------------------------------
LOCAL
Optimization Info:
-------------------------------------
bmsql_stock:table_rows:102930, physical_range_rows:202313, logical_range_rows:102930, index_back_rows:0, output_rows:10, est_method:local_storage, optimization_method=cost_based, avaiable_index_name[bmsql_stock], estimation info[table_id:1099511677810, (table_type:1, version:0-1-1, logical_rc:0, physical_rc:0), (table_type:7, version:1-1643711133341028-1643711137434089, logical_rc:0, physical_rc:97070), (table_type:7, version:1643711137434089-1643773772483289-1643773772483289, logical_rc:102930, physical_rc:104976), (table_type:5, version:1643711137434089-1643773772483289-1643773772483289, logical_rc:0, physical_rc:0), (table_type:0, version:1643773772483289-1643773772483289-9223372036854775807, logical_rc:0, physical_rc:267)]
Parameters
-------------------------------------
SQL: UPDATE bmsql_stock SET s_quantity = 50, s_ytd = s_ytd + 1, s_order_cnt = s_order_cnt + 1, s_remote_cnt = s_remote_cnt + 0 WHERE s_w_id = 2 AND s_i_id = 12177;
查看格式化信息
=============================================
|ID|OPERATOR   |NAME       |EST. ROWS|COST  |
---------------------------------------------
|0 |UPDATE     |           |11       |264318|
|1 | TABLE SCAN|bmsql_stock|11       |264308|
=============================================
Outputs & filters: 
-------------------------------------
  0 - output(nil), filter(nil), table_columns([{bmsql_stock: ({bmsql_stock: (bmsql_stock.__pk_increment(0x7f429730c4d0), bmsql_stock.s_w_id(0x7f429730c760), bmsql_stock.s_i_id(0x7f429730c9f0), bmsql_stock.s_quantity(0x7f433871d590), bmsql_stock.s_ytd(0x7f433871da60), bmsql_stock.s_order_cnt(0x7f4297309b50), bmsql_stock.s_remote_cnt(0x7f429730a930), bmsql_stock.s_data(0x7f429730cc80), bmsql_stock.s_dist_01(0x7f429730cf10), bmsql_stock.s_dist_02(0x7f429730d1a0), bmsql_stock.s_dist_03(0x7f429730d430), bmsql_stock.s_dist_04(0x7f429730d6c0), bmsql_stock.s_dist_05(0x7f429730d950), bmsql_stock.s_dist_06(0x7f429730dbe0), bmsql_stock.s_dist_07(0x7f429730de70), bmsql_stock.s_dist_08(0x7f429730e100), bmsql_stock.s_dist_09(0x7f429730e510), bmsql_stock.s_dist_10(0x7f429730e7a0))})}]),
      update([bmsql_stock.s_quantity(0x7f433871d590)=?], [bmsql_stock.s_ytd(0x7f433871da60)=column_conv(INT,PS:(11,0),NULL,cast(bmsql_stock.s_ytd(0x7f433871da60) + 1(0x7f433871e1c0), INT(-1, 0))(0x7f429736e910))(0x7f429736d430)], [bmsql_stock.s_order_cnt(0x7f4297309b50)=column_conv(INT,PS:(11,0),NULL,cast(bmsql_stock.s_order_cnt(0x7f4297309b50) + 1(0x7f429730a2b0), INT(-1, 0))(0x7f4297370950))(0x7f429736f470)], [bmsql_stock.s_remote_cnt(0x7f429730a930)=column_conv(INT,PS:(11,0),NULL,cast(bmsql_stock.s_remote_cnt(0x7f429730a930) + 0(0x7f429730b090), INT(-1, 0))(0x7f4297372990))(0x7f42973714b0)])
  1 - output([bmsql_stock.__pk_increment(0x7f429730c4d0)], [bmsql_stock.s_w_id(0x7f429730c760)], [bmsql_stock.s_i_id(0x7f429730c9f0)], [bmsql_stock.s_quantity(0x7f433871d590)], [bmsql_stock.s_ytd(0x7f433871da60)], [bmsql_stock.s_order_cnt(0x7f4297309b50)], [bmsql_stock.s_remote_cnt(0x7f429730a930)], [bmsql_stock.s_data(0x7f429730cc80)], [bmsql_stock.s_dist_01(0x7f429730cf10)], [bmsql_stock.s_dist_02(0x7f429730d1a0)], [bmsql_stock.s_dist_03(0x7f429730d430)], [bmsql_stock.s_dist_04(0x7f429730d6c0)], [bmsql_stock.s_dist_05(0x7f429730d950)], [bmsql_stock.s_dist_06(0x7f429730dbe0)], [bmsql_stock.s_dist_07(0x7f429730de70)], [bmsql_stock.s_dist_08(0x7f429730e100)], [bmsql_stock.s_dist_09(0x7f429730e510)], [bmsql_stock.s_dist_10(0x7f429730e7a0)], [remove_const(?)(0x7f42973196a0)], [column_conv(INT,PS:(11,0),NULL,cast(bmsql_stock.s_ytd(0x7f433871da60) + 1(0x7f433871e1c0), INT(-1, 0))(0x7f429736e910))(0x7f429736d430)], [column_conv(INT,PS:(11,0),NULL,cast(bmsql_stock.s_order_cnt(0x7f4297309b50) + 1(0x7f429730a2b0), INT(-1, 0))(0x7f4297370950))(0x7f429736f470)], [column_conv(INT,PS:(11,0),NULL,cast(bmsql_stock.s_remote_cnt(0x7f429730a930) + 0(0x7f429730b090), INT(-1, 0))(0x7f4297372990))(0x7f42973714b0)]), filter([bmsql_stock.s_w_id(0x7f429730c760) = 2(0x7f429730ef00)], [bmsql_stock.s_i_id(0x7f429730c9f0) = 12177(0x7f429730fa50)]), 
      access([bmsql_stock.s_quantity(0x7f433871d590)], [bmsql_stock.s_ytd(0x7f433871da60)], [bmsql_stock.s_order_cnt(0x7f4297309b50)], [bmsql_stock.s_remote_cnt(0x7f429730a930)], [bmsql_stock.__pk_increment(0x7f429730c4d0)], [bmsql_stock.s_w_id(0x7f429730c760)], [bmsql_stock.s_i_id(0x7f429730c9f0)], [bmsql_stock.s_data(0x7f429730cc80)], [bmsql_stock.s_dist_01(0x7f429730cf10)], [bmsql_stock.s_dist_02(0x7f429730d1a0)], [bmsql_stock.s_dist_03(0x7f429730d430)], [bmsql_stock.s_dist_04(0x7f429730d6c0)], [bmsql_stock.s_dist_05(0x7f429730d950)], [bmsql_stock.s_dist_06(0x7f429730dbe0)], [bmsql_stock.s_dist_07(0x7f429730de70)], [bmsql_stock.s_dist_08(0x7f429730e100)], [bmsql_stock.s_dist_09(0x7f429730e510)], [bmsql_stock.s_dist_10(0x7f429730e7a0)]), partitions(p0), 
      is_index_back=false, filter_before_indexback[false,false], 
      range_key([bmsql_stock.__pk_increment(0x7f429730c4d0)]), range(MIN ; MAX)always true
Used Hint:
-------------------------------------
  /*+
  */
Outline Data:
-------------------------------------
  /*+
      BEGIN_OUTLINE_DATA
      FULL(@"UPD$1" "obtest.bmsql_stock"@"UPD$1")
      END_OUTLINE_DATA
  */
Plan Type:
-------------------------------------
LOCAL
Optimization Info:
-------------------------------------
bmsql_stock:table_rows:102930, physical_range_rows:202323, logical_range_rows:102930, index_back_rows:0, output_rows:10, est_method:local_storage, optimization_method=cost_based, avaiable_index_name[bmsql_stock], estimation info[table_id:1099511677810, (table_type:1, version:0-1-1, logical_rc:0, physical_rc:0), (table_type:7, version:1-1643711133341028-1643711137434089, logical_rc:0, physical_rc:97070), (table_type:7, version:1643711137434089-1643773772483289-1643773772483289, logical_rc:102930, physical_rc:104976), (table_type:5, version:1643711137434089-1643773772483289-1643773772483289, logical_rc:0, physical_rc:0), (table_type:0, version:1643773772483289-1643773772483289-9223372036854775807, logical_rc:0, physical_rc:277)]
Parameters
-------------------------------------
{obj:{"INT":50}, accuracy:{length:-1, precision:-1, scale:-1}, flag:0, raw_text_pos:-1, raw_text_len:-1, param_meta:{type:"INT", collation:"binary", coercibility:"NUMERIC"}}

四、FQA

[admin@10 run]$ ./runSQL.sh props.ob sql.common/tableCreates.sql
# ------------------------------------------------------------
# Loading SQL file sql.common/tableCreates.sql
# ------------------------------------------------------------
Error: Could not find or load main class ExecJDBC

– 设置ORACLE_HOME环境变量（可以是任意目录），在ORACLE_HOME下建立lib目录，将OceanBase的jdbc驱动放入该目录.$ORACLE_HOME/lib/oceanbase-client-1.1.10.jar；经过上面的操作，benchmarksql便可以找到jdbc驱动了。

You have an error in your SQL syntax; check the manual that corresponds to your OceanBase version for the right syntax to use near 'sequence bmsql_hist_id_seq' at line 1

– 这个问题没有继续查，个人理解是因为mysql不支持序列的原因，所以mysql租户应该不支持建立序列。

./runSQL.sh: line 14: source: funcs.sh: file not found

– 这个问题——应该说不是问题，看其他同学使用绝对路径方式解决问题。实际可以直接执行脚本来解决‘./runSQL.sh props.ob sql.common/tableCreates.sql’

夏 克
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
专栏目录
OceanBase实验6：查看OceanBase执行计划
hyu1989的专栏
11-01 1487
实验6：查看OceanBase执行计划。
mysql语句批量更新数据库_sql 更新批量数据库语句
weixin_33553051的博客
01-18 2153
JDBC(六)批量处理sql批量更新是分组在一起的一批更新，并以“批量”方式发送到数据库，而不是逐个发送更新。一次发送一批更新到数据库，比一个一个发送更快，等待每个更新完成。 发送一批更新(仅一次往返)涉及的网络流量较少，数据库可能能够并行执行一些更新。 与逐个执行更新相比，加速可能相当大。有两种方法可以执行批量更新：...文章微笑着生活2018-03-04875浏览量Java -- JDBC 学...
【OceanBase】27.OB的执行计划
weixin_43346403的博客
02-22 585
3.执行计划展示(EXPLAIN)-计划形状与算子信息。4.执行计划展示(EXPLAIN)-计划形状与算子信息。5.执行计划展示(EXPLAIN)-操作算子详细输出。6.执行计划展示(EXPLAIN)-示例。8.EXPLAIN与实时执行计划的对比。2.执行计划展示(EXPLAIN)9.查看执行计划的几种其它方式。7.实时执行计划展示。
实践练习6：查看 OceanBase 执行计划
qinwen740的博客
03-30 2031
环境准备 机器信息 机器类型 虚拟机 IP 10.201.0.170, 10.201.0.171, 10.201.0.172, 10.201.0.173 网卡名 eth0 OS CentOS Linux release 7.9.2009 CPU 4C 内存 总内存 16G，可用内存 15G 磁盘1 磁盘 /dev/vda 200G 磁盘2 磁盘 /dev/vdb 300G 机器划分 角色 机器 备注 性能测
【Oceanbase系列】——OceanBase SQL执行计划
汤庆
11-20 4183
一、前言 能点开我这篇文章的，相信应该都是有点数据库背景的，SQL语句在不同的人手中会写出不同的语句形式，比如经常遇到的SQL慢查询，这时候往往需要针对SQL进行优化。而像orancle和mysql中为保证SQL语句能够高效的运行，提供了一个Explain的命令，用来对SQL语句进行语义分析，供开发者来针对SQL进行优化。当然了 oceanbase是蚂蚁自研的分布式数据库，支持mysql和orancle两种模式，既然敢吹分布式这个牛，那这里边的执行计划就不得不提一下，毕竟你的sql是要跑在分布式...
如果我来负责支付宝双11大促保障(四)
weixin_30555753的博客
12-03 73
在梳理好有哪些系统将参与到大促后，我们的目标就是对它们的现状进行健康检查，为后续制订优化方案提供数据支持。 同样，检查纬度还是依照上面罗列的，从自身、依赖方、服务方、基础服务和后台服务五个纬度来检查。 自身 1、硬件主要是检查服务器的各项指标，包括CPU、IO、内存、连接数以及磁盘剩余空间。 2、软件此次我们只是着重于检查JVM的一些参数，如GC策略和启动参数。 3、...
OceanBase查询优化器和执行计划
互联网知识分享
08-21 592
查询优化器是数据库系统中的一个重要组件，负责对SQL语句进行优化，生成最优的执行计划。在OceanBase中，查询优化器扮演着至关重要的角色，它能够通过一系列的优化算法和规则，对查询语句进行分析，选择最佳的执行路径，并生成相应的执行计划。下面将详细介绍OceanBase查询优化器的工作原理及其相关的优化算法。转存失败重新上传取消1）查询优化器的工作原理查询优化器的主要工作就是从多个可能的执行计划中选择一个最优的执行计划。它通过以下几个步骤完成这个过程：解析SQL。
实践练习六：查看 OceanBase 执行计划
m0_55146438的博客
03-08 770
第一次执行压测shell脚本时，会报错，提示找不到funcs.sh，但funcs.sh在 安装dir/run/下的确是有这个文件，编辑runBenchmark.sh，将funcs.sh的路径改为绝对路径。编辑好配置文件后，需要在ob的目标库中建表。实验目标：使用benchmark导入数据并进行压测，查看top3sql的执行计划。修改完成后，如果执行还有报错，则根据实际错误提示进行对sql脚本进行修改即可。通过explain [extended] 查看top3 sql的逻辑执行计划。
OBCP第三章 SQL引擎高级技术-执行计划
明确的爱，真诚的喜欢，直接的厌恶，站在太阳底下的坦荡，被坚定的选择。
03-27 390
SQL 是一种“描述型”语言。与“过程型”语言不同，用户在使用 SQL 时，只描述了“要做什么”，而不是“怎么做”
linux环境，Oceanbase安装，按步骤执行即可
最新发布
05-20
linux环境，Oceanbase安装，按步骤执行即可
OceanBase诊断工具 是 原诊断信息收集工具)的功能升级版
05-07
OceanBase诊断工具(OceanBase ... 目前包含了对于OceanBase日志、SQL Audit以及OceanBase进程堆栈等信息进行的扫描、收集，可以在OceanBase集群不同的部署模式下（OCP，OBD或用户根据文档手工部署）实现一键执行。
Python中执行存储过程及获取存储过程返回值的方法
09-21
主要介绍了Python中执行存储过程及获取存储过程返回值的方法,结合实例形式总结分析了Python调用存储过程的常用方法与相关操作注意事项,需要的朋友可以参考下
datax-web:DataX集成可视化页面，选择数据源即可使用一键生成数据同步任务，支持RDBMS，Hive，HBase，ClickHouse，MongoDB等数据源，批量创建RDBMS数据同步任务，集成嵌入式调度系统，支持分布式，增量同步数据，实时查看运行日志，监控执行器资源，KILL运行进程，数据源信息加密等
03-22
任务“执行器”支持部署，支持执行器多字节路由策略选择，支持超时控制，失败重试，失败中断，任务依赖，执行器CPU。内存。负载的监控等等。后续提供更多的数据源支持，数据转换UDF，表结构同步，数据同步血缘等更...
SQL查询超时的设置方法(关于timeout的处理)
09-10
为了优化OceanBase的query timeout设置方式，特调研MySQL关于timeout的处理，下面与大家分享下处理记录，感兴趣的朋友可以参考下哈
OceanBase几个常见问题及排查思路
weixin_34267123的博客
10-29 3666
第一种情况：某一台observer挂掉，数据库异常 OceanBase采用的的是多副本集群模式，在不同的zone里面有不同的server，每个zone里面的server是互相备份的。上层是通过slb来分发所以，当其中一台server挂掉的时候，会对业务产生什么影响呢？ 制造现象：50用户并发某查询交易时，kill掉某一台（业务所在的observer跟业务...
实践练习六（必选）：查看 OceanBase 执行计划
redgame7的博客
02-07 397
装载前先优化一下测试租户的设置，避免大事务超时，先登陆到租户。运行脚本，装载数据，输出显示装载成功，仓库数选的小一些。使用 BenmarkSQL 运行 TPC-C。TPC-C TOP SQL分析。下载benchmarksql。编辑props.ob配置文件。登陆到数据库，创建两个索引。下载BenmarkSQL。执行SQL、查看执行计划。
第四章 oceanbase学习之查看oceanbase执行计划
RookieDBA的博客
04-27 1557
oceanbase执行计划
oceanbase执行计划方法
11-16
根据提供的引用内容，oceanbase执行计划的方法可以在第四章中找到。具体方法如下： 1. 打开oceanbase客户端，连接到相应的数据库。 2. 在客户端中输入要执行的SQL语句，例如： ```sql explain select * from table_name; ``` 3. 执行上述SQL语句后，oceanbase会返回执行计划，包括查询语句的优化器选择的执行计划和实际执行计划。

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

夏 克

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值