OpenStack Compute (Nova)

Database logging required

Reported by justinsb on 2012-03-25
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack Compute (nova)
Wishlist
justinsb

Bug Description

We need a way to enable SQL logging in the field so that when someone reports "OMG the DB is so slow, Y U not using MongoDB - it is web scale" then we will be able to analyze the problem intelligently. See Bug #964824 for the sort of issues this can show.

(I proposed an initial patch here https://review.openstack.org/#change,5783 , but apparently the correct procedure is to file a bug and get it merged into master and then essex.)

tags: added: essex-rc-potential

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

Changed in nova:
assignee: nobody → justinsb (justin-fathomdb)
status: New → In Progress
Thierry Carrez (ttx) on 2012-03-27
Changed in nova:
importance: Undecided → Wishlist

Reviewed: https://review.openstack.org/5816
Committed: http://github.com/openstack/nova/commit/6432997f672f5b20b3d5b6b961fc3b9bf1117022
Submitter: Jenkins
Branch: master

commit 6432997f672f5b20b3d5b6b961fc3b9bf1117022
Author: Justin Santa Barbara <email address hidden>
Date: Mon Mar 26 09:32:43 2012 -0700

    Support sql_connection_debug to get SQL diagnostic information

    We've had a few reports of SQL issues; it'll be very helpful to be able to get SQL information
    into our log.

    Bug #964844

    Change-Id: I9d08991a3677bc6cbed45a930ede9271d685cac1

Changed in nova:
status: In Progress → Fix Committed

Reviewed: https://review.openstack.org/6031
Committed: http://github.com/openstack/nova/commit/ed26fb38263d9aa3df52005f304921ffd51f8d4a
Submitter: Jenkins
Branch: milestone-proposed

commit ed26fb38263d9aa3df52005f304921ffd51f8d4a
Author: Justin Santa Barbara <email address hidden>
Date: Mon Mar 26 09:32:43 2012 -0700

    Support sql_connection_debug to get SQL diagnostic information

    We've had a few reports of SQL issues; it'll be very helpful to be able to get SQL information
    into our log.

    Bug #964844

    Change-Id: I9d08991a3677bc6cbed45a930ede9271d685cac1

Changed in nova:
status: Fix Committed → Fix Released
Thierry Carrez (ttx) on 2012-04-05
Changed in nova:
milestone: none → 2012.1
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers