Similar to the Oracle mode, the MySQL mode also supports dynamic performance views.
Overview
The views are dynamic because they are continuously updated when a database is opened and in use. The dynamic performance views provide information about the performance of a database.
Compared with regular database tables, dynamic performance views provide only data about internal disk structures and memory structures. You can query these views but you cannot update or modify them.
An OceanBase database contains dynamic performance tables whose names start with V$. The SYS account can create views on the dynamic performance tables. Then, the SYS account can create public synonyms. The public synonyms that are created on the dynamic performance views share the prefix V$.
In most cases, a V$ view corresponds to a GV$ view, which is a global V$ view. If you query a GV$ view, all qualified V$ view information will be returned.
Storage of dynamic performance views
Dynamic performance views are created based on virtual tables that are created from database memory structures.
They are not conventional tables that are stored in a database. Read consistency is not guaranteed for the dynamic performance views because data is updated in real time.
The dynamic performance views are not true tables. Therefore, data in these views varies based on the state of the cluster and service node.