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 |