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
