×

Warning message

  • Cisco Support Forums is in Read Only mode while the site is being migrated.
  • Cisco Support Forums is in Read Only mode while the site is being migrated.

Mail Flow Central - Slowness and database issues

Unanswered Question
Jan 17th, 2006
User Badges:

Hello,
My MFC database is about 220 gig, keeping 45 days of data. It is running on a large system (Quad XEON Processor HP ML 570, with 6 Spindals for the data drive) and it still gets so busy it shuts down MySql.

Support keeps telling me to index the tables, but they are indexed, and I keep getting errors.

Is anyone else having issues?

Anybody with a database this size or larger?

Thanks,
Mike

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Erich_ironport Tue, 01/17/2006 - 19:06
User Badges:

From our experience the performance issues with MFC are around the purge process.

Our ugly work around was to set the purge date to 3 months our and to start over with a clean database every 2 months or so. Effective the purge never happens, we wipe and recreate. Like I said it is an ugly kludge. Eight weeks of data ends up being about a 512GB size database in our environment.

Long-term I think MFC has to go to a rolling partitioned table solution, based on date. So then the purge process can be done more efficiently at the partition level.

http://dev.mysql.com/doc/refman/5.1/en/partitioning-types.html

- Erich

mgraci_ironport Fri, 01/20/2006 - 16:54
User Badges:

I do not use MFC yet and based upon what I have been hearing, I am in no hurry.

I just wish we could get more traffic detail on the actual box.

At minimum let me set the time period to look at the data that is already displayed via the GUI instead of only Hour, Day, Week, Month. For example I want to see the Incoming info on IP x.x.x.x from 06:30 to 07:10 am this morning.

-Matt

sandeep_ironport Thu, 03/02/2006 - 05:55
User Badges:

I think using 'grep' from the command line will give you some basic output.

supported flags:
grep -e regexp [-e regexp] [-i] [-p] [-t] log_name

shannon.hagan Thu, 03/02/2006 - 15:03
User Badges:

Have you tried the reporting api? You can specify a time period and the data comes back in csv format.

I do not use MFC yet and based upon what I have been hearing,  I am in no hurry.

I just wish we could get more traffic detail on the actual box.

At minimum let me set the time period to look at the data that is already displayed via the GUI instead of only Hour, Day, Week, Month. For example I want to see the Incoming info on IP x.x.x.x from 06:30 to 07:10 am this morning.

-Matt

Actions

This Discussion