Actions
Bug #19527
closed
'messages' table can get large and can also get slow to query
Difficulty:
Triaged:
No
Bugzilla link:
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
Updated by The Foreman Bot over 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
Updated by Marek Hulán over 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
Updated by Ondřej Pražák over 7 years ago
- Status changed from Ready For Testing to Closed
- % Done changed from 0 to 100
Applied in changeset foreman_openscap|75895fdd0aa4a9f4536b6542f5b946552a24ba78.
Updated by Ondřej Pražák about 7 years ago
- Bugzilla link changed from 1438479 to 1520074
Actions