Blip Docs
Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Toggle Dark/Light/Auto mode Back to homepage

size.table

The size.table domain includes metrics about table sizes.

Usage

Table size is calculated as:

SELECT
  table_schema AS db,
  table_name as tbl,
  COALESCE(data_length + index_length, 0) AS tbl_size_bytes
WHERE
  /* include or exclude list */
FROM
  information_schema.tables

Table size includes secondary indexes.

Reported table size and size on disk can vary due to several factors. If the difference is large, rebuild the table by performing a no-op schema change.

Since table 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.

Derived Metrics

bytes

Metric Typegauge
Value Unitsbytes

Table size in bytes.

Options

exclude

Value TypeCSV string of db.table
Defaultmysql.*,information_schema.*,performance_schema.*,sys.*

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

include

Value TypeCSV string of db.table
Default

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

total

ValueDefaultDescription
yesReport size of all tables combined
noOnly report tables individually

Group Keys

KeyValue
db, tblDatabase and table name, or empty string for all tables (total)

Meta

None.

Error Policies

None.

MySQL Config

None.

Changelog

Blip VersionChange
v1.0.0Domain added