Prior to upgrade, page loads were <1 to 2 seconds. Now, page loads are 30-120+ seconds. I am not sure what happened, I do not see any errors in php or sugar logs. Slow query log has a few that pop up, but none are related or new during my page load testing.
Seems database related, when I open the admin or repair screen, i get <1s loads, anything that has to pull from database is 30+ seconds every time. Running a ‘show processlist’ reveals that the queries look to be finished in <1 second.
I have done some searching and verified my optimization settings, though I am not sure what would have changed between 7.4 and 7.5.1. Sugar version 6.5.20. I have done several quick repair and rebuild relationships after each attempt at changing a setting.
Please help me locate the source of this issue.