Ceilometer

sqlalchemy performance issue

Bug #1070074 reported by John Tran
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Ceilometer
Fix Released
Undecided
John Tran
Ceilometer 2013.1 "grizzly"

Bug Description

When the sourceassoc and|or meter tables get above 1500 rows, mysql performance grinds to a halt. A simple session.query(User).get(<user_id>) takes minutes to return (mysql running on a m1.medium). Missing indexes and|or too much lazy joins defined in the model.

John Tran (jtran)
Changed in ceilometer:
assignee: nobody → John Tran (jtran)
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/14781

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/14781
Committed: http://github.com/stackforge/ceilometer/commit/320ef645c84fbebdfd216574f0ff1b5623b26acc
Submitter: Jenkins
Branch: master

commit 320ef645c84fbebdfd216574f0ff1b5623b26acc
Author: John Tran <email address hidden>
Date: Wed Oct 24 00:06:53 2012 +0000

    Fix sqlalchemy performance problem

    Fixes bug #1070074 too much lazy loading on the
    default model. Removed those and only added lazy
    loading to queries that specifically need eager
    loading

    Change-Id: Ifa7446bddef855ae8e8b76040ba3336a53606215

Changed in ceilometer:
status: In Progress → Fix Committed
Thierry Carrez (ttx)
Changed in ceilometer:
milestone: none → grizzly-2
status: Fix Committed → Fix Released
Thierry Carrez (ttx)
Changed in ceilometer:
milestone: grizzly-2 → 2013.1
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.