The Ultimate Guide to High Availability with MariaDB

Catalog status variables

You are viewing an old version of this article. View the current version here.

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.

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.