patternsqlMinor
What consequence deleting idb file will have on my mysql database?
Viewed 0 times
deletingfilewhatidbdatabasemysqlwillconsequencehave
Problem
I tried to check what is consumming my Disk Space on Centos 7, I found these 2 database file:
/var/lib/mysql/pub/vues.ibd: 8.1G
/var/lib/mysql/pub/log.ibd: 8.6G
I would like to delete them. pub is the name of my database.
And log and vues are tables.
/var/lib/mysql/pub/vues.ibd: 8.1G
/var/lib/mysql/pub/log.ibd: 8.6G
I would like to delete them. pub is the name of my database.
And log and vues are tables.
Solution
As @danblack pointed out it's not the best idea. However to formally answer your question - if you delete the
vues.ibd and log.ibd files the InnoDB dictionary will still keep entries about them. If you ever decide to create tables with same name the CREATE TABLE statement will fail.Context
StackExchange Database Administrators Q#218301, answer score: 2
Revisions (0)
No revisions yet.