Get Instant Solutions for Kubernetes, Databases, Docker and more
SELECT PARTITION
NAME, TABLE
NAME FROM information
schema.partitions WHERE TABLE
SCHEMA = 'your
database
name';
Replace `yourdatabasename` with the name of your database.
SELECT TABLE
NAME, COLUMN
NAME, CONSTRAINT
NAME, REFERENCED
TABLE
NAME, REFERENCED
COLUMN_NAME
FROM informationschema.KEY
COLUMN_USAGE
WHERE REFERENCEDTABLE
SCHEMA = 'your
database
name';
SHOW ENGINE INNODB STATUS;
Look under the `TRANSACTIONS` section for transactions that might be using the partition.
SET FOREIGN
KEY
CHECKS=0;
-- Your DROP PARTITION command here
SET FOREIGNKEY
CHECKS=1;
Be sure to replace `-- Your DROP PARTITION command here` with your actual `DROP PARTITION` command.
ALTER TABLE your
table
name DROP PARTITION partition_name;
Replace `yourtablename` with the name of your table and `partition_name` with the name of the partition you wish to drop.
(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)