[openstack-dev] [Openstack][Nova] Slow Nova API Calls from periodic-tempest-devstack-vm-check-hourly

Devananda van der Veen devananda.vdv at gmail.com
Thu Jan 10 17:11:09 UTC 2013


On Sun, Jan 6, 2013 at 11:55 PM, Monty Taylor <mordred at inaugust.com> wrote:

> Getting client ids passed to the db log for correlation will be
>  trickier. A lot of the big web properties will do tricks in their db
> layer where they will add embedded comments into the sql passed in that
> include information like client ids. I'm not sure how hard that sort of
> tracing would be to do on our end -but turning on the slow query log
> while doing these sorts of things is probably a great starting place.
>
>
This might be done by extending patch_mysqldb_with_stacktrace_comments:
https://github.com/openstack/nova/blob/master/nova/db/sqlalchemy/session.py#L565

One way to approach this would be to inspect the stack for particular
things (file name, variable, or something else) and only then get the
client ids and add them to the comment string, though at the moment I'm not
quite clear on how session.py is going to access the API client id.

-Devananda
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20130110/c02170c9/attachment.html>


More information about the OpenStack-dev mailing list