The Ultimate Guide to High Availability with MariaDB

Catalog Status Variables

MariaDB starting with 11.8

Catalog support is planned for 11.8.

When using a MariaDB Server with catalogs support, all status information is collected for the whole server, per catalog and per session.

SHOW SERVER STATUS;

shows the 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 show the status for the current catalog. The reason that 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 enable SAS providers to see the status for a single tenant (catalog user). This makes it much easier to find 'bad neighbors' (tenants that cause problems for other tenants) so that they can be moved to other servers.

When the MariaDB server is not configured for catalogs, the following commands are equivalent:

SHOW GLOBAL STATUS
SHOW SERVER STATUS 
SHOW CATALOG STATUS

See Also

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.