MySQL - Ibdata file deletion ?
Posted by: Mahesh Patil
Date: November 11, 2014 02:07AM

On a production server I have changed "innodb_file_per_table=ON" and I can see separate tablespace files for each table on my server.
I have used parititioning for tables so for each partition there is a separate .ibd file .

But I can see previous "ibdata1" file of size 10 Gb. I am bit curious whether to delete it or not ?

If I delete shared tablespace file "ibdata1" will there be any impact on server ?
Will it cause any problem ?

Options: ReplyQuote


Subject
Written By
Posted
MySQL - Ibdata file deletion ?
November 11, 2014 02:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.