Catalog status variables
When using a MariaDB Server with catalogs support, all status information are collected for the whole server, per catalog and per user.
SHOW SERVER STATUS;
show status for the whole server. Note that only the super user in the 'def' catalog has privileges for the above statement.
SHOW GLOBAL STATUS; SHOW CATALOG STATUS;
Both commands shows the status for the current catalog.
The reason why GLOBAL
shows catalog status is that because catalogs are 'multi-tenant', a
catalog user should not be able to see the status from other users (for most things).
SHOW [SESSION] STATUS;
Shows the status for the current connection.
The main "new thing" is that catalogs enables SAS providers to see status for a single tenant (catalog user). This makes it much easier to find 'bad neighbors' (tenants that causes problems for other tenants) so that they can be moved to other servers.
When the MariaDB serer is not configured for catalogs the following commands are equal:
SHOW GLOBAL STATUS SHOW SERVER STATUS SHOW CATALOG STATUS
See also: