Since the launch of OBQ [Q&A area], we have received questions from developers every day. Thank you for your interaction and support. Every question is the continuous power of the community. In view of your busy daily work, OB Gunter selected and summarized the problems of high fever, so as to focus on reading and efficient learning.

Let’s take a look at kangkang’s picks for this week’s Q&A

OBQ q&a

Q1: How does OceanBase support HTAP?

Tag: # System Architecture & Principles #

A: The original distributed computing engine of OceanBase database enables multiple computing nodes in the system to run OLTP type applications and complex OLAP type applications at the same time, realizing the ability to support mixed load with one set of computing engine, and making full use of customers’ computing resources. Save customers’ cost of purchasing additional hardware resources and software authorization.

Q2: OceanBase Developer Center Import big data SQL timeout, how to do?

Questioner: Sugar Brother hashtag: # Install, Deploy & Monitor

A: It is recommended to operate in two ways:

1. Divide a large SQL file into multiple SQL files. 2. Modify the timeout parameters of the current connection based on the specific exception information, such as transaction timeout and modifying transaction timeout, connection timeout and modifying connection timeout.

Show variables like ‘% timeout %’; Query the value of the timeout period. Set global [variable_name] = XXXX; Or set [variable_name] = XXXX; If global is added, the global variable takes effect after the session is reconnected. If global is not added, the variable is changed to the current session variable.

Q3: Are there sysbench procedures for OceanBase?

Asked by: Wangergui Hashtag: # System Architecture & Principles #

A: yes. Ob_poc_sysbench.tar.gz contains multiple test case scenarios, such as non-partitioned, write only, read only, read and write test cases for partitioned tables in single zone and multiple zones.

Poc test documentation for Sysbench tests can be found at www.modb.pro/doc/1742.

Q4: Does OceanBase support synchronizing MySQL 8.0 data?

Questioner: Small O hashtag: # Data Migration #

A: Yes. Data synchronization is not directly related to the database version and can be migrated using various migration tools or commands carried by the database itself.

Q5: Execution plan cache hit problem: v$plan_cache_plan_stat has execution times and hit times. In which scenario will the execution be executed but not hit?

Tag: # System Architecture and Principle #

A: The execution times and hit times are generally 1 more than the hit times. The reason is that the first execution is added to the plan cache by a newly generated plan. This increases the execution times by 1, but does not increase the hit times by + 1. + 1 for execution count and hit count statistics.

OBQ is dedicated to building a high-quality community for developers to share creation, meet partners and co-host. If you have any questions or suggestions on distributed technology, please feel free to comment, discuss and share!