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>