oceanbase / miniob

MiniOB is a compact database that assists developers in understanding the fundamental workings of a database.
https://oceanbase.github.io/miniob/
Mulan Permissive Software License, Version 2
2.86k stars 1.01k forks source link

虚拟表 #346

Open hnwyllmm opened 2 months ago

hnwyllmm commented 2 months ago

Is your feature request related to a problem? Please describe. A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

当前MiniOB没有查询数据库内部状态的能力,比如当前正在执行的会话以及他们的状态、系统的配置信息、内部组件的统计信息等。

Describe the solution you'd like A clear and concise description of what you want to happen.

实现虚拟表功能。 虚拟表的数据是在内存中的,给用户提供统一的抽象访问方式虚拟表,用户可以访问内存中的数据。 比如系统配置,提供虚拟表实现查询方式: select * from miniob.__config;miniob.__config的存储引擎中,返回配置数据访问的接口。 此功能依赖 #345 提供一个抽象的引擎访问接口。

Describe alternatives you've considered A clear and concise description of any alternative solutions or features you've considered.

Additional context Add any other context or screenshots about the feature request here. OceanBase 的实现参考 https://github.com/oceanbase/oceanbase/tree/develop/src/observer/virtual_table

还可以参考 MySQL information_schema 的实现。