Results 1 to 1 of 1
  1. #1
    Join Date
    Jul 2011
    Posts
    32

    Unanswered: Different 'Cumulative Time' for the Same Set of Queries

    Hi,

    I'm not using query cache by setting
    Code:
    SET SESSION query_cache_type=0
    How come I still see different 'cumulative time' for the same set of queries? For example for the first run from a web page the time is 1054ms, the subsequent runs are less than 100ms. I did not pay attention to this before thinking I'm probably getting query cache results but this is not the case as I have printed Qcache variables by using the following to make sure there are no query cache hits.
    Code:
    SHOW GLOBAL STATUS LIKE 'Qcache%'
    Appreciated..
    Last edited by akrashdi; 11-05-12 at 11:01.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •