size.table
The size.table
domain includes metrics about table sizes.
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.
Metric Type | gauge |
Value Units | bytes |
Table size in bytes.
Value Type | CSV string of db.table |
Default | mysql.*,information_schema.*,performance_schema.*,sys.* |
A comma-separated list of database or table names to exclude (ignored if include
is set).
Value Type | CSV string of db.table |
Default |
A comma-separated list of database or table names to include (overrides option exclude
).
Value | Default | Description |
---|---|---|
yes | ✓ | Report size of all tables combined |
no | Only report tables individually |
Key | Value |
---|---|
db , tbl | Database and table name, or empty string for all tables (total ) |
None.
None.
None.
Blip Version | Change |
---|---|
v1.0.0 | Domain added |