Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

LP #1318985: pt-stalk should use SQL_NO_CACHE

Description

**Reported in Launchpad by Kenny Gryp last update 26-09-2014 10:37:41

pt-stalk should use SQL_NO_CACHE when executing queries.

I had pt-stalks where most of the queries that were 'waiting on query cache mutex' were the pt-stalk queries (INNODB_TRX).

Ok, the query cache is a problem in this environment, but it skews up my stats I would get out of processlist and causes more threads_running spikes and potentially fails to obtain the necessary statistics in time.

Environment

None

Smart Checklist

Activity

Show:

lpjirasync January 24, 2018 at 4:25 PM

**Comment from Launchpad by: Frank Cizmich on: 05-09-2014 17:31:43

Added the SQL_NO_CACHE directive to the queries for locks and transactions

e.g:

SELECT SQL_NO_CACHE * FROM INFORMATION_SCHEMA.INNODB_LOCKS

etc

Done

Details

Assignee

Reporter

Priority

Labels

Smart Checklist

Created January 24, 2018 at 4:24 PM
Updated January 24, 2018 at 4:25 PM
Resolved January 24, 2018 at 4:25 PM