Get Instant Solutions for Kubernetes, Databases, Docker and more
When encountering the error "1237: Partition is full" in MySQL DB, follow these steps:
df -h
Look for the partition that MySQL uses and check if it's almost full.
SELECT table
name AS `Table`, round(((data
length + index_length) / 1024 / 1024), 2) `Size in MB`
FROM information_schema.TABLES
WHERE tableschema = "database_name>"
ORDER BY (datalength + indexlength) DESC;
SELECT partitionname, tablerows, datalength, indexlength,
round(((datalength + indexlength) / 1024 / 1024), 2) as `Size in MB`
FROM information_schema.partitions
WHERE tablename = 'yourtablename' AND tableschema = 'yourdatabasename';
OPTIMIZE TABLE yourtablename;
Remember, if these steps involve changes to production data or critical systems, ensure you have appropriate backups and understand the commands you're running to avoid accidental data loss or downtime.
(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)