IronPort MailFlow Central Database Size

Unanswered Question
Apr 18th, 2014
User Badges:

Hello,

 

Is there a way to increase the database storage size for mail flow central without re installing it?  I cut down the # of months to store data, but this didn't do anything.  Can you increase the storage capacity of the database without re-installing it?  We are using 85% of the database right now.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
TexHwyMan Thu, 01/08/2015 - 07:47
User Badges:

I realize this thread is a bit dated now, but in case anyone else needs this answer...

Yes, you can increase it by changing the config file using these instructions:

1. Stop the Mail Flow Central service.
2. Stop the MySQL service.
3. Make a backup copy of your my.cnf file — my.cnf.bak.
4. Use a text editor of your choice (one that will not imbed any formatting or RTF
information into a plain text document) to edit the c:/my.cnf file.
5. Change the maximum database size from the current value (this size is set to 10GB by
default in Mail Flow Central version 1.2) to your new desired value. You must never
reduce the value in the file. Find the following line in your file:
innodb_data_file_path = ibdata1:10G:autoextend:max:10G
Increase the value indicated after the string “max:” For example, to change the maximum
database size from 10GB to 90GB, the modified line would look like this:
innodb_data_file_path = ibdata1:10G:autoextend:max:90G
6. Save the c:/my.cnf file and exit the editor.
7. Start the MySQL service.
8. Once the MySQL service has started, start the Mail Flow Central service.

Hope that helps someone.

noraarellano Wed, 03/18/2015 - 16:34
User Badges:

Hi!

 

I still have Mailflow Central and I want to increase the database size, I follow your method but as soon as I start the Mail Flow Central Service the size of the database comes back to 10... I need to do something else?

 

Also, I find 2 my.cnf files, one inside  \Program Files\IronPort Systems\Mail Flow Central\db\data and another one inside \Program Files\IronPort Systems\Mail Flow Central\mailFC\sql; Which one did you modify?

 

Thanks for your help!!

TexHwyMan Thu, 03/19/2015 - 08:13
User Badges:

Actually, it's neither of those two-- those are just sample files.  Edit the one in the root of C:\.

noraarellano Thu, 03/19/2015 - 10:24
User Badges:

It worked!!!

 

Thank you!!!

 

One doubt, just for curiosity: If some time later I need to extend the db again and I already have information in it, its possible to increase again or I will lose my data?

 

Regards!

TexHwyMan Thu, 03/19/2015 - 10:37
User Badges:

Yes, you should be able to increase it again without losing your data.  But back it up first-- just in case.  ;-)

Actions

This Discussion