Similar to the Oracle mode, the MySQL mode also supports dynamic performance views.
Overview
Dynamic performance views are called as such because they are continuously updated when you open and use a database, and their content is mainly about performance.
Such views look like regular database tables but provide only data related to internal disk structures and memory structures. You can select these views but cannot update or modify them.
An OceanBase database contains dynamic performance tables whose names start with V$. Dynamic performance views are created on these tables, and public synonyms for these views are created and named with the prefix V$.
Almost each V$ view corresponds to a GV$ view, namely, a global V$ view. If you query a GV$ view, all qualified V$ view information will be returned.
Storage
A dynamic performance view is a virtual table that is created based on database memory structures.
A dynamic performance view is not a regular table stored in a database because the data in a dynamic performance view is constantly updated. As a result, data reads from the view keep changing.
The data in a dynamic performance view depends on the status of the cluster and service nodes because such a view is not a real table.