Get Instant Solutions for Kubernetes, Databases, Docker and more
SELECT table_schema AS "Database",
ROUND(SUM(datalength + index
length) / 1024 / 1024, 2) AS "Size (MB)"
FROM information_schema.TABLES
GROUP BY table_schema;
SELECT table_name AS "Table",
ROUND(((datalength + index
length) / 1024 / 1024), 2) AS "Size (MB)"
FROM information_schema.TABLES
WHERE tableschema = "your
database_name"
ORDER BY (datalength + index
length) DESC;
Ensure any data manipulation or deletion is performed cautiously, ideally with backups in place to avoid accidental data loss.
(Perfect for DevOps & SREs)
(Perfect for DevOps & SREs)
Get Instant Solutions for Kubernetes, Databases, Docker and more
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.
Block quote
Ordered list
Unordered list
Bold text
Emphasis
Superscript
Subscript
(Perfect for DevOps & SREs)
(Perfect for DevOps & SREs)