size.database

The size.database domain includes metrics about database sizes.

Database size is calculated as:

SELECT
  table_schema AS db,
  SUM(data_length + index_length) AS bytes
FROM
  information_schema.tables
WHERE
  /* include or exclude list */
GROUP BY 1

Database size includes all secondary indexes.

Reported table size and size on disk can vary due to several factors.

Since database sizes aren’t expected to have large and rapid changes, best practice is to collect this domain infrequently: 5, 10, 15, 30, or 60 minutes.

Database size in bytes.

A comma-separated list of database or table names to exclude (ignored if include is set).

A comma-separated list of database or table names to include (overrides option exclude).

If enabled (like = yes), the query becomes (table_schema LIKE 'foo') OR (table_schema LIKE 'bar'), where “foo” and “bar” are the included or excluded database names and can contain wildcards like %. Else, the query becomes table_schema IN ('foo', 'bar').

None.

None.

None.