### What problem were solved in this pull request?

Issue Number: close #178 

Problem:
sysbench is a powerful concurrency test tool and we should use it to
test our program.

### What is changed and how it works?
I create two sysbench lua scripts and a github workflow.

### Other information

### What problem were solved in this pull request?

Problem:
与训练营配合，可以在SQL命令请求过程中，添加调试信息

### What is changed and how it works?
可以参考 debug-output.md 文档。
增加 sql_debug 变量，使用set sql_debug=1; 可以设置。
在SQL命令执行过程中，调用sql_debug函数，增加调试信息。在普通文本通讯协议中，调试信息会以 '#'
开头的形式打印出来。但是注意调试信息中不要带换行符。

### Other information

### What problem were solved in this pull request?

Issue Number: close #162 

Problem:
当前的observer启动流程和调试方法比较繁琐，必须使用客户端服务端的方式，先启动服务端程序，再使用客户端启动调试

### What is changed and how it works?
observer可以直接启动，不监听tcp或unix socket，直接通过终端/控制台输入命令并执行，极大的方便了调试

### Other information
新的启动方法：
./bin/observer -P cli -f ../etc/observer.ini

### What problem were solved in this pull request?

Issue Number: close #173 close #136 

ref #174 
ref #165 

Problem:
这个PR修改了多个问题，可以参考各个issue。包括observer编译两次、代码目录规划不合理、command executor未全部实现等

### What is changed and how it works?
做一些重构优化，包括CMakelist、一些代码目录、command executor

### What problem were solved in this pull request?

close issue: #186 

Problem:
实现MVCC代码后没有将持久化代码合并进来

### What is changed and how it works?
支持并发模式下落日志，并在异常停机后回复。

持久化是事务模块中最复杂的功能（没有之一），当前miniob实现的持久化简化了非常多，因此不能依赖持久化能力，仅仅作为一个学习测试的工具，在实际测试时也有一些限制。

### Other information

### What problem were solved in this pull request?

Issue Number: close #91 close #1 

Problem:
编译时编译器抛出的一些告警信息可以帮我们避免很多问题，但是现在并没有利用这个特性

### What is changed and how it works?
CMake中增加-Werror编译选项

### Other information

### What problem were solved in this pull request?

Issue Number: close #155 close #135 

Problem:
实现了简单的事务处理。
当前支持并发事务数据.

### What is changed and how it works?
- 支持两种事务模式：Vacuous和MVCC。
  Vacuous 事务模式算是没有事务，它的事务接口什么都不做。
MVCC 是多版本并发控制(Multi-Version Concurrency
Control)，使用多个版本保留记录数据。启动miniob时增加运行时选项 -t mvcc可以选择mvcc。

- MVCC：简单模式的多版本并发控制。
  当前miniob仅包含insert和delete操作，因此数据最多包含两个版本，并且不需要在record中保留版本链表信息；
  不支持持久化；
  没有做垃圾回收；
  遗留一个BUG：在提交时没有保证提交的数据一次性对外可见；
  使用简单的写写冲突策略：检测到要修改的数据当前有人在修改，就回退

- 编译MINIOB时使用 -DCONCURRENCY=ON 才会支持并发
支持各个模块并发处理，包括buffer pool、bplus、record
manager。如果编译时没有使用CONCURRENCY选项，则保持原样，不支持并发，保持系统的简单性。

- 编译时增加 -DDEBUG=ON 还会增加并发调试日志与严格的运行时检测(ASSERT语句)
- 当前版本代码中包含了bplus tree和record manager的并发测试，参考benchmark目录下的代码。

### Other information

### What problem were solved in this pull request?

Issue Number: close #159 

Problem:
common链接库编译了两次

### What is changed and how it works?
删除common_static，将common直接改成static链接库

Fix problem:
1. the buffer pool and b tree is not thread safe;
2. github/workflow/build does not work

### What is changed and how it works?
1. thread-safe buffer pool
- I use a mutex in buffer pool and take a lock in buffer pool operations
such as allocate frame, dispose frame;
- The frame is locked while updating/reading the content of frame;
- Frame manager take a lock when allocate/free pages.

2. thread-safe b+tree
- Crabing protocol is used to support concurrent

3. github/workflow/build
- update the submodules;
- create a build script and run build.sh in build.yaml

logical plan & physical plan;
explain;
yacc rewrite;
join operator(nested loop join);
simple rewrite rules;
fix some issues of mysql protocol;

tested by mariadb ( Ver 15.1 Distrib 5.5.65-MariaDB, for Linux (x86_64) using readline 5.1)
but failed with obclient

2022 oceanbase competition

* 简化git submodule操作

* support build with address sanitizer

using cmake options `-DENALBE_ASAN=ON` to enable address sanitizer

* fix some memory leaks detected by asan

* stage线程分配问题 #75
* 客户端连接可以指定host和port

优化load data效率

* stage线程分配问题 #75

* 设置线程名称，在top时显示线程名，便于调试

没有为stage分配配置的线程池，而使用了默认线程池

add copyright header info

Other improvement
1. add code format file
2. add gitignore
3. add memory pool utility
4. remove useless file mpool.h, index_manager.cpp/h
5. rename the interface of disk_buffer_pool basing on the new mem_pool
6. add some logs in db/table/disk_buffer_pool
7. add unit test mem_pool_test/log_test/bplus_tree_test
8. code format all modified files
9. redefine the interface of table_meta
10. change log's  full path as file name
11. add utility function, print_callstack, remove warning of path