Application timeout issue due to slow DB queries about bugzilla-customisation HOT 10 CLOSED

I bumped the Application load balancer timeout from 60s to 120s.

from bugzilla-customisation.

Dumping some resources I found in my travels:

• https://mariadb.com/kb/en/library/slow-query-log-overview/
• https://mariadb.com/kb/en/library/explain-in-the-slow-query-log/
• https://github.com/jynus/query-optimization
• https://metacpan.org/pod/DBI#DBI_TRACE

from bugzilla-customisation.

This query on login seems crazy slow: https://s.natalian.org/2017-12-08/1512709174_2164x1398.png

I'm debugging like so:

innotop -h db.dev.unee-t.com -P 3306 -u root --password=$(aws --profile lmb-dev ssm get-parameters --names MYSQL_ROOT_PASSWORD --with-decryption --query Parameters[0].Value --output text)

from bugzilla-customisation.

We know the query is slow: we are addressing this in issue #21

This issue should be about the AWS timeout issue in the dev environment IMO so we can tackle these different (albeit related) problems separately.

My intuition is that fixing the timeout should MUCH faster than fixing the BZ query issue...

from bugzilla-customisation.

The application timeout is some arbitrary limit like a minute (at a guess). I'm confident we would not see the timeout if the query was fast. So I am not sure what you are asking me to do there. Somehow configure the timeout to >1min?

from bugzilla-customisation.

"Somehow configure the timeout to >1min?"
Exactly
This is a temporary fix until we can sort out and fix the underlying issue with the query (see issue #21)

from bugzilla-customisation.

https://www.youtube.com/watch?v=BiScul_hGNg&feature=youtu.be video about enabling slow log on a RDS.

from bugzilla-customisation.

If I'm not mistaken, slow_log is already enabled in the dev.
@kaihendry are you OK to close this issue now?

From my POV, the only thing we can do for now is:
1- Make sure that the timeout is the same in the prod too (so we can do private Beta despite issue #21.
2- Make sure that the DB expert find a way to improve the slow query (issue #21) that is causing this timeout issue in the first place.

from bugzilla-customisation.

I'm unable to reproduce the timeout on login, so perhaps you can close it.

from bugzilla-customisation.

closing this:

• timeout increase and
• first DB optimization (see case #21)
  have made the problem disappear in the dev.

from bugzilla-customisation.