Not signed in (Sign In)

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

General: Plotting values

Bottom of Page

1 to 4 of 4

  1.  
    • CommentAuthorsandy
    • CommentTimeApr 10th 2012
     
    Hi,

    Are you plotting charts based on queries per second?

    In Presets - Tables chart y-axis values are 0.1, 0.2, 0.3 , 0.4, 0.5 etc. Descriptions says "Heaviest tables and how many queries are running against them."
    Same applies for Schemas also.
  2.  
    Hi,

    table and schema statistics are based on SHOW OPEN TABLES. The measure is, on average, how many table handles are in use per table. Every time a table is used in a query, it counts as 1 for the duration of the query. So it is not strictly based on the queries, but rather on the underlying table handle information obtained from MySQL.
    • CommentAuthorsandy
    • CommentTimeApr 11th 2012 edited
     
    From your reply,
    "The measure is, on average, how many table handles are in use per table."

    Can you please explain this in more detail?
    Suppose 1 query is executing for 10 seconds. There is only one open handle for the duration of query(10 sec).
    So how do you plot this value in the chart? Can you please explain this in numbers.

    Thanks,
    Sandy
  4.  
    If the query is

    SELECT ... FROM t1 WHERE ...

    Table t1 will get an open count of 1. The value plotted during those 10 seconds will be 1. Afterwards it will drop back to 0.

    If the query is

    SELECT ... FROM t1 JOIN t1 ON ... WHERE ...

    Table t1 will get an open count of 2. Likewise if you have two queries of the first kind running simultaneously.

1 to 4 of 4

  1.