Project

General

Profile

Actions

Bug #19527

closed

'messages' table can get large and can also get slow to query

Added by Ondřej Pražák almost 7 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Normal
Target version:
Difficulty:
Triaged:
No
Fixed in Releases:
Found in Releases:

Description

Description of problem:

Querying the 'messages' table for an entry can take some time. For example, when we logged all queries over 1000msec for a user that uses openscap heavily, this query was about half of all logged queries:

SELECT "messages".*
FROM "messages"
WHERE "messages"."value" = <value>
AND "messages"."digest" = <digest>
AND "messages"."severity" = <sev>
AND "messages"."description" = <description>
AND "messages"."rationale" = <rationale>
ORDER BY "messages"."id" ASC
LIMIT 1

Actions #1

Updated by The Foreman Bot almost 7 years ago

  • Status changed from New to Ready For Testing
  • Assignee set to Ondřej Pražák
  • Pull request https://github.com/theforeman/foreman_openscap/pull/257 added
Actions #2

Updated by Marek Hulán almost 7 years ago

  • Subject changed from 'messages' table can get large and can also get slow to query to 'messages' table can get large and can also get slow to query
  • translation missing: en.field_release set to 245
Actions #3

Updated by Ondřej Pražák almost 7 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100
Actions #4

Updated by Ondřej Pražák over 6 years ago

  • Bugzilla link changed from 1438479 to 1520074
Actions

Also available in: Atom PDF