>I may just leave HMM off and run with it.
That makes me sad. HMM is really good. Worth fixing.
On Thu, Mar 17, 2016 at 11:48 AM, Jay <h...@herodata.com> wrote:
> I appreciate the advice and input. I don't suspect hardware just yet,
> since the mail server software runs on the same box and has no issues.
> However, since I have shutoff the HMM and still use MySQL for the
> spamdb, ASSP starts up in a few seconds without any delay. So I am going
> to leave HMM off for a few days and evaluate where things are. If my
> users are not seeing a spike in spam I may just leave HMM off and run
> with it.
>
> If not, then I have a plan of action that I listed below.
>
> On 3/17/2016 11:34 AM, Scott MacLean wrote:
> > Just a thought, but anytime I see sudden unexplained slowness, I start
> > looking at hardware, in particular disk hardware. Check your physical
> > disk average disk queue lengths and see if you've got a drive
> > bottleneck, it can mean either the disk hardware is not up to the task,
> > or it is failing, and internal disk retries are causing the bottleneck.
> >
> > Of course, this is assuming you are running on physical hardware, and
> > not a VM.
> >
> > On 3/17/2016 11:26 AM, Jay wrote:
> >> The answer to your first question is no. It has not always been this
> way.
> >>
> >> This is really starting to look like the HMMdb table in MySQL might be
> >> corrupt/damaged in some way. I looked through my rebuild logs from the
> >> past 6 months and what I am finding is before this situation happened,
> >> our HMM rebuild was taking from 10-15 mins tops to finish according to
> >> the log. Now looking at the log when we started having the slow issue,
> >> our HMM rebuild is taking 30mins or longer to finish rebuilding. Now I
> >> realize as the data grows it's going to take longer for a rebuild, but
> >> there's a major jump in the rebuild for the HMM is a very short time
> >> frame. Within a couple of days and not a huge jump in data size.
> >>
> >> So with the information I uncovered and thinking this over, I am going
> >> to go at this in a few steps:
> >>
> >> 1. Update MySQL to 5.5.48
> >> 2. Delete the HMM table out of MySQL and start over fresh
> >>
> >> At that point I will see where things stand. I appreciate all the input
> >> on this and advice.
> >>
> >> Thank you.
> >>
> >
> >
> ------------------------------------------------------------------------------
> > Transform Data into Opportunity.
> > Accelerate data analysis in your applications with
> > Intel Data Analytics Acceleration Library.
> > Click to learn more.
> > http://pubads.g.doubleclick.net/gampad/clk?id=278785231&iu=/4140
> > _______________________________________________
> > Assp-user mailing list
> > Assp-user@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/assp-user
> >
> >
> >
> > -----
> > No virus found in this message.
> > Checked by AVG - www.avg.com
> > Version: 2016.0.7497 / Virus Database: 4542/11829 - Release Date:
> 03/17/16
> >
> >
>
>
>
>
>
> ------------------------------------------------------------------------------
> Transform Data into Opportunity.
> Accelerate data analysis in your applications with
> Intel Data Analytics Acceleration Library.
> Click to learn more.
> http://pubads.g.doubleclick.net/gampad/clk?id=278785231&iu=/4140
> _______________________________________________
> Assp-user mailing list
> Assp-user@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/assp-user
>
------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785231&iu=/4140
_______________________________________________
Assp-user mailing list
Assp-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-user
