Not signed in (Sign In)

Vanilla 1.1.5a is a product of Lussumo. More Information: Documentation, Community Support.

    • CommentAuthorrobv
    • CommentTimeNov 16th 2010
     
    Is there any way to show how many times the queries that show up under "Top Queries" and "Slow Queries" ran?
    It shows total time which is good but we are interested in how many times the query actually ran as well.
  1.  
    Jet Profiler does not collect all traffic to the database server, it
    only polls every x milliseconds. So it sees all queries that are
    executing at the polling time. But any queries that are executed between
    two samples are missed. Therefore Jet Profiler cannot tell how many
    times the query has run during a time frame.

    What could be presented is the number of times the query has been
    sampled (observed). But I'm unsure whether this is a valuable measure,
    since it might be very different from the actual number of executions.
    We've not decided whether to add this measure or not, since it might
    confuse users.

    This is also the reason we have the thread load measure, where we try to
    visualize the observed frequency, expressed by how many threads are
    observed running the query at every sample time. A value of 1 means the
    query is always running (by one thread on average).