Interesting... so if the script was running as is before without an problems, then why is it causing a problem now?
hmmm
Re: Slowest queries are inserting single row into mdl_sessions
על ידי Jerry Lau בתאריך
מספר תגובות: 4
בתגובה ל: Jerry Lau
Re: Slowest queries are inserting single row into mdl_sessions
על ידי Diane Soini בתאריך
That's a mystery to us. It was bumping up to the limit of php threads before, but that was not causing any problems. We don't know if the problem is because we updated PHP to 7.2 or if there was something else. In any case, removing the table optimization eliminated the outages for our users during those moments.
בתגובה ל: Diane Soini
Re: Slowest queries are inserting single row into mdl_sessions
על ידי Jerry Lau בתאריך
Was it tested before? Changes would affect things.. change control for production? Replicate it test/development platform?
בתגובה ל: Jerry Lau
Re: Slowest queries are inserting single row into mdl_sessions
על ידי Diane Soini בתאריך
We don't have an adequate simulation for our actual usage level. I was unable to create a viable simulation using Jmeter. We are a school of 20,000 undergraduates and for our upgrade from 3.1 to 3.5 we had only one developer.
בתגובה ל: Diane Soini
Re: Slowest queries are inserting single row into mdl_sessions
על ידי Jerry Lau בתאריך
Yes.. sounds familiar