Information Schema Reference
Views in the information schema surface metadata about clusters and all the components within them. SingleStoreDB supports the same information_schema
views as MySQL, as well as a variety of additional views that are specific to SingleStore. The MySQL views are often useful, but it is important to note that some are included mostly for compatibility purposes, meaning that values for some columns may always be NULL
.
Many of the information schema views have an mv_
version, which is a view that aggregates over lmv_
views that are generated independently on each leaf.