Abnormal query ?

  • Resolved joy0114

    (@joy0114)


    1 year, 2 months ago

    Hi,

    I’ve just starting using your plugin and I wonder if one query is abnormal or not.
    I started a monitor and I can see two queries like this:

    Site 32 66,6ms 2,08ms ±0,54ms 3,87ms UPDATE boutique_xxxx_options SET option_value = s WHERE option_name = s boutique_xxxx_options (PRIMARY) [range] Where

    and

    Site 95 17,8ms 187μs ±69μs 339μs SELECT option_value FROM boutique_xxxx_options WHERE option_name = s LIMIT 1 Impossible WHERE noticed after reading const tables

    The other queries do not exceed 3ms.

    My report number is zQwM8AN6

    Thanks in advance for any advices !
    Best regards

    • This topic was modified 1 year, 2 months ago by joy0114.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author OllieJones

    (@olliejones)

    Thanks for your question.

    This Site 32 66,6ms 2,08ms ±0,54ms 3,87ms means queries like the one you showed ran a total of 32 times while you were gathering your monitor data. Together they took a total of 66.6ms, for an average time of 2.08ms and a 95th-percentile (===almost worst case) time of 3.87 ms. So, no, this is **not abnormal.**

    You already have a persistent object cache, it seems (the one built into the LiteSpeed server stack). That’s good. Your 8GiB buffer cache in your MariaDB server is almost full, so your performance may benefit from adding more RAM to that cache.

    Thread Starter joy0114

    (@joy0114)

    Hi Olliejones,

    Thanks ever so much for tour answer and your clear explanations !

    One last thing: How do you know that I have 8GB of cache ? What tool do you use to determine this value ?

    Thanks again for your tips.
    Best regards

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Abnormal query ?’ is closed to new replies.