MySQL Forums
Forum List  »  InnoDB

Re: ibdata1 file getting huge
Posted by: Rick James
Date: October 18, 2014 12:25PM

Repeat your procedure, but this time with this value set in my.cnf
innodb_file_per_table = 1

Then, ibdata1 will not become huge. Instead individual .ibd files will get big. Furthermore, maintenance on an individual table will affect only the .ibd file.

> they are alsways importing and exporting huge files

Please elaborate on the steps involved. There are several techniques that may impact such. (DELETE vs TRUNCATE; import/export tablespaces; PARTITIONs; etc)

What version of MySQL are they using?

Options: ReplyQuote


Subject
Views
Written By
Posted
2549
October 17, 2014 06:57AM
Re: ibdata1 file getting huge
1474
October 18, 2014 12:25PM
1242
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.