to New Relic

Home → Support →

DirectSQL... not seeing where this is coming from?

todd's Avatar

todd

18 Jan, 2010 03:39 PM via web

All of the most dissatisfying methods are being caused by what newrelic is reporting as directsql, the only issue is there are only a couple _by_sql calls in the entire app, none of which should be called on these controller methods. Could something else be going on?

We also run backgroundrb from 2 additional servers that share access to the main mysql db, could newrelic be getting confused?

Thanks!
Todd

  1. Support Staff 2 Posted by Ralph Bodenner on 18 Jan, 2010 07:21 PM

    Ralph Bodenner's Avatar

    Hi Todd,

    The background jobs on separate servers won't be included in the SQL time RPM is measuring--we don't measure database ops on the DB directly, but through ActiveRecord calls in the application threads.

    The DIRECTSQL numbers account for time spent in the DB outside the usual ActiveRecord model methods (find, save, etc.). There are a couple ways to get more insight into the mystery SQL:

    1. Use Transaction Traces (a Silver feature) to drill down into specific slow transactions and see what SQL is being executed, and by which code paths.

    2. Run the RPM agent in Developer Mode on your desktop. Hit the dissatisfying actions and you can drill down into each one's execution path in great detail, including the SQL. This isn't recommended for use in production, but you can set up a local_production environment if you only see the extra SQL with your production workload: http://blog.newrelic.com/2009/01/22/rails_envlocal_production/

    If you discover that the DIRECTSQL time is really happening within a find or save, let us know--it might be a bug.

    Ralph

  2. Support Staff 3 Posted by Bill Kayser on 18 Jan, 2010 09:07 PM

    Bill Kayser's Avatar

    Todd, one thing that might help is upgrading to a newer version of the Agent. This might give us a little better insight on the source of the metric. The ActiveRecord instrumentation has improved substantially.

  3. Support Staff 4 Posted by Devorah on 08 Feb, 2010 07:15 PM

    Devorah's Avatar

    Todd,
    Its been a few weeks, so I wanted to check in with you and see if Bill and Ralph's suggestions helped clear the issue.

    Please let me know so that if you're still having problems we can help resolve them ASAP.

    Thanks,
    Devorah

  4. Devorah resolved this discussion on 18 Feb, 2010 07:26 PM.

Comments are currently closed for this discussion. You can start a new one.

4 people watching.

  • New Issue

  • Conversation Started

  • The discussion is resolved

    No more actions from New Relic or the discussion starter are required.

  • Re-open the discussion

Recent Discussions

09 Sep, 2010 08:37 PM Custom instrumentation not working after gem update
09 Sep, 2010 08:03 AM Redirects giving false apdex score
09 Sep, 2010 03:43 AM No data reporting :: Error running task in Agent Worker Loop
08 Sep, 2010 10:55 PM Rails 3 support
08 Sep, 2010 10:48 PM Rolling up metrics via multiple application names

Recent Articles

Ruby Agent Release Notes
.NET Private Beta
PHP Private Beta
Does RPM work with the Bundler gem?
Where can I get a Beta of the next release?