Mirantis OpenStack

[MongoDB] decrease response of Event collection

Bug #1527240 reported by Igor Degtiarov
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Mirantis OpenStack
Fix Released
Medium
Igor Degtiarov
Mirantis OpenStack 8.0

Bug Description

Event collection in MongoDB has only TTL index now.

Without indexing fields that frequently used in queries for event collection response time highly increases with growth of collected data.

See original description
Tags: ceilometer
Igor Degtiarov (idegtiarov)
description: updated
Changed in mos:
milestone: none → 8.0
assignee: nobody → Igor Degtiarov (idegtiarov)
Roman Podoliaka (rpodolyaka)
Changed in mos:
status: New → Confirmed
importance: Undecided → Medium
Igor Degtiarov (idegtiarov)
description: updated
Revision history for this message
Fuel Devops McRobotson (fuel-devops-robot) wrote : Fix proposed to openstack/ceilometer (openstack-ci/fuel-8.0/liberty)

Fix proposed to branch: openstack-ci/fuel-8.0/liberty
Change author: Igor Degtiarov <email address hidden>
Review: https://review.fuel-infra.org/14816

Changed in mos:
status: Confirmed → In Progress
Revision history for this message
Fuel Devops McRobotson (fuel-devops-robot) wrote : Fix merged to openstack/ceilometer (openstack-ci/fuel-8.0/liberty)

Reviewed: https://review.fuel-infra.org/14816
Submitter: Pkgs Jenkins <email address hidden>
Branch: openstack-ci/fuel-8.0/liberty

Commit: 0672eb4dc5281734ba4eb54c6677ac72964471aa
Author: Igor Degtiarov <email address hidden>
Date: Wed Dec 30 10:10:37 2015

[MongoDB] add indexes in event collection

Now in event collection only ttl index existed, that means response
on queries for event collection will become slower with collection growth.
Additional indexes based on timestamp and event_type fields in improves this.

Closes-bug: #1527240
Change-Id: I87f13262a213828e1aca5fbe60544db78999a341
(cherry-picked from upstream change I87f13262a213828e1aca5fbe60544db78999a341)

Changed in mos:
status: In Progress → Fix Committed
Timur Nurlygayanov (tnurlygayanov)
tags: added: ceilometer
Revision history for this message
Vitaly Gusev (vgusev) wrote :

Verified on ISO:
VERSION:
  feature_groups:
    - mirantis
  production: "docker"
  release: "8.0"
  api: "1.0"
  build_number: "466"
  build_id: "466"
  fuel-nailgun_sha: "f81311bbd6fee2665e3f96dcac55f72889b2f38c"
  python-fuelclient_sha: "4f234669cfe88a9406f4e438b1e1f74f1ef484a5"
  fuel-agent_sha: "6823f1d4005a634b8436109ab741a2194e2d32e0"
  fuel-nailgun-agent_sha: "b2bb466fd5bd92da614cdbd819d6999c510ebfb1"
  astute_sha: "b81577a5b7857c4be8748492bae1dec2fa89b446"
  fuel-library_sha: "fe03d887361eb80232e9914eae5b8d54304df781"
  fuel-ostf_sha: "ab5fd151fc6c1aa0b35bc2023631b1f4836ecd61"
  fuel-mirror_sha: "b62f3cce5321fd570c6589bc2684eab994c3f3f2"
  fuelmenu_sha: "fac143f4dfa75785758e72afbdc029693e94ff2b"
  shotgun_sha: "63645dea384a37dde5c01d4f8905566978e5d906"
  network-checker_sha: "9f0ba4577915ce1e77f5dc9c639a5ef66ca45896"
  fuel-upgrade_sha: "616a7490ec7199f69759e97e42f9b97dfc87e85b"
  fuelmain_sha: "727f7076f04cb0caccc9f305b149a2b5b5c2af3a"

Changed in mos:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.