544943 - prod homepage timeouts due to long TCBS query

Status: RESOLVED FIXED

(Socorro :: General, task)

Description

[Austin King [:ozten]]

production is timing out due to slow TCBS queries.

Workaround - Continue to use the query page directly.
http://crash-stats.mozilla.com/query/query

Comment 1

[Michael Morgan [:morgamic]]

We should modify the front page to eliminate the problem query.  Working on patching front page so the dashboard widgets aren't there until we can get the RAM upgraded, etc.

Comment 2

[Austin King [:ozten]]

Short term fix: Bug#544944

We are also upgrading Postgres RAM

We are evaluating removing data older than 28 days. This is how the system used to work.

We should evaluate how we are using the branchs admin config. TCBS reports are very expensive in terms the numer of rows created in the db. Originally this report was run very selectively and now is run by default for several months.

Comment 3

[Austin King [:ozten]]

Short term fix: Bug#544944

We are also upgrading Postgres RAM

We are evaluating removing data older than 28 days. This is how the system used
to work.

We should evaluate how we are using the branchs admin config. TCBS reports are
very expensive in terms the numer of rows created in the db. Originally this
report was run very selectively and now is run by default for several months

Comment 4

[Ryan Snyder [:ryansnyder] [:rsnyder] [:rysny]]

Is this bug still an issue?

Comment 5

[Laura Thomson :laura]

Seems like no, also the 1.6 push will get rid of older data and prevent this from happening again.