slow query response of event collection in MongoDB

Bug #1526793 reported by Igor Degtiarov
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Ceilometer
Fix Released
Undecided
Igor Degtiarov

Bug Description

We do not have any indexes in event collection in MongoDB except ttl index.

This means that any query for event collection will became slower with collection growth.

Changed in ceilometer:
assignee: nobody → Igor Degtiarov (idegtiarov)
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to ceilometer (master)

Fix proposed to branch: master
Review: https://review.openstack.org/258508

Changed in ceilometer:
status: New → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to ceilometer (master)

Reviewed: https://review.openstack.org/258508
Committed: https://git.openstack.org/cgit/openstack/ceilometer/commit/?id=033a2e3fd22f1e96b999a92ffc3e6686debd50ff
Submitter: Jenkins
Branch: master

commit 033a2e3fd22f1e96b999a92ffc3e6686debd50ff
Author: Igor Degtiarov <email address hidden>
Date: Wed Dec 16 15:48:57 2015 +0200

    [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: #1526793
    Change-Id: I87f13262a213828e1aca5fbe60544db78999a341

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

Other bug subscribers

Remote bug watches

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