HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

What consequence deleting idb file will have on my mysql database?

Submitted by: @import:stackexchange-dba··
0
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.

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.