MySQL Forums
Forum List  »  InnoDB

ibdata1 file getting huge
Posted by: jens verlinden
Date: October 17, 2014 06:57AM

Hello,

A customer of us uses a mysql innoDB databases. The problem is they are alsways importing and exporting huge files (up to 33 GB..). So the ibdata1 file becomes really big! Last time it was 52 GB and their hard drive is getting full because of this.

We have done this procedure 2 times, but it really takes long..:

1) backup all databases
2) drop all databases
3) stop mysql
4) remove all files (ibdata1 etc..)
5) start mysql
6) recreate databases and import them.

Then the ibdata1 file is again 9 GB, but shortly after if they start importing data again it grows really huge.

Is there anything we can do about this, execept inserting an extra hard disk?
Can't the ibdata1 be cleaned in some way? Rather then always backup and restore everything?

Kind Regards

Options: ReplyQuote


Subject
Views
Written By
Posted
ibdata1 file getting huge
2548
October 17, 2014 06:57AM
1474
October 18, 2014 12:25PM
1241
October 20, 2014 06:08AM
1225
October 21, 2014 09:57AM
1544
October 25, 2014 01:02AM


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.