Hi All,
I've been running version 8.x for about 10 months on this machine and my monitoring system shows a usual CPU load of around 10-20%, with occasional spikes up to about 30-40%.
Since upgrading to MySQL version 5.5 and JSS version 9.11 my CPU load has averaged around 50%+ during the day. Yesterday afternoon and overnight it dropped back down to around 20% but has been running at 50%+ again for the last hour.
I am running on Windows 2008R2 in a Hyper-V virtual environment. This is the same environment I've used all along. I have allocated 4Gb RAM and Tomcat has been allocated 2Gb RAM.
After reading a separate post about this issue I was wondering what I could tweak to get this back to "normal". I have allocated 115 connections (some SQL monitoring I have done showed a previous maximum connections of 85) and a max packet size of 128m.
Should I enable binary logging? (I did this with another MySQL application and it didn't work so I'm wary of enabling this for JSS).
Somewhere in the upgrade I saw something about the max thread count for tomcat (should be 1.5 times the max MySQL connections) but I can't find where that is now. Should I increase this from the 150 that was default and how do I do this?
Approx 80% of my 1300 iPads have checked in since the upgrade so I would have hoped that the system would return to normal by now.
Any help greatly appreciated.
Cheers,
Chris.
