MySQL :: MySQL 5.7 Reference Manual :: Query Cache Probes

MySQL :: MySQL 5.7 Reference Manual :: Query Cache Probes Contact MySQL  |  Login  |  Register The world's most popular open source database MySQL.com Downloads Documentation Developer Zone Developer Zone Downloads MySQL.com Documentation MySQL Server MySQL Enterprise Workbench Router Utilities/Fabric MySQL NDB Cluster Connectors More MySQL.com Downloads Developer Zone Section Menu:   Documentation Home MySQL 5.7 Reference Manual Preface and Legal Notices General Information Installing and Upgrading MySQL Using MySQL as a Document Store Tutorial MySQL Programs MySQL Server Administration The MySQL Server Configuring the Server Server Configuration Defaults Server Option and Variable Reference Server Command Options Server System Variables Using System Variables Structured System Variables Dynamic System Variables Server Status Variables Server SQL Modes IPv6 Support Verifying System Support for IPv6 Configuring the MySQL Server to Permit IPv6 Connections Connecting Using the IPv6 Local Host Address Connecting Using IPv6 Nonlocal Host Addresses Obtaining an IPv6 Address from a Broker Server-Side Help Server Response to Signals The Server Shutdown Process The MySQL Data Directory The mysql System Database MySQL Server Logs Selecting General Query and Slow Query Log Output Destinations The Error Log The General Query Log The Binary Log Binary Logging Formats Setting The Binary Log Format Mixed Binary Logging Format Logging Format for Changes to mysql Database Tables The Slow Query Log The DDL Log Server Log Maintenance MySQL Server Plugins Server Plugins Available Installing and Uninstalling Plugins Obtaining Server Plugin Information MySQL Enterprise Thread Pool Thread Pool Components Thread Pool Installation Thread Pool Operation Thread Pool Tuning The Rewriter Query Rewrite Plugin Installing or uninstalling the Rewriter Query Rewrite Plugin Using the Rewriter Query Rewrite Plugin Rewriter Query Rewrite Plugin Reference Version Tokens Version Tokens Components Installing or Uninstalling Version Tokens Using Version Tokens Version Tokens Reference Running Multiple MySQL Instances on One Machine Setting Up Multiple Data Directories Running Multiple MySQL Instances on Windows Starting Multiple MySQL Instances at the Windows Command Line Starting Multiple MySQL Instances as Windows Services Running Multiple MySQL Instances on Unix Using Client Programs in a Multiple-Server Environment Tracing mysqld Using DTrace mysqld DTrace Probe Reference Connection Probes Command Probes Query Probes Query Parsing Probes Query Cache Probes Query Execution Probes Row-Level Probes Read Row Probes Index Probes Lock Probes Filesort Probes Statement Probes Network Probes Keycache Probes Security Backup and Recovery Optimization Language Structure Globalization Data Types Functions and Operators SQL Statement Syntax The InnoDB Storage Engine Alternative Storage Engines High Availability and Scalability Replication MySQL NDB Cluster 7.5 Partitioning Stored Programs and Views INFORMATION_SCHEMA Tables MySQL Performance Schema MySQL sys Schema Connectors and APIs Extending MySQL MySQL Enterprise Edition MySQL Workbench MySQL 5.7 Frequently Asked Questions Errors, Error Codes, and Common Problems Restrictions and Limits Indexes MySQL Glossary Related Documentation MySQL 5.7 Release Notes Download this Manual PDF (US Ltr) - 35.7Mb PDF (A4) - 35.7Mb PDF (RPM) - 34.7Mb EPUB - 8.7Mb HTML Download (TGZ) - 8.5Mb HTML Download (Zip) - 8.5Mb HTML Download (RPM) - 7.3Mb Eclipse Doc Plugin (TGZ) - 9.3Mb Eclipse Doc Plugin (Zip) - 11.5Mb Man Pages (TGZ) - 203.5Kb Man Pages (Zip) - 308.9Kb Info (Gzip) - 3.3Mb Info (Zip) - 3.3Mb Excerpts from this Manual MySQL Backup and Recovery MySQL Globalization MySQL Information Schema MySQL Installation Guide MySQL and Linux/Unix MySQL and OS X MySQL Partitioning MySQL Performance Schema MySQL Replication Using the MySQL Yum Repository MySQL Restrictions and Limitations Security in MySQL MySQL and Solaris Building MySQL from Source Starting and Stopping MySQL MySQL Tutorial MySQL and Windows MySQL Cluster NDB 7.5 version 5.7 8.0 5.6 5.5 5.6  Japanese MySQL 5.7 Reference Manual  /  ...  /  MySQL Server Administration  /  Tracing mysqld Using DTrace  /  mysqld DTrace Probe Reference  /  Query Cache Probes Query Cache Probes The query cache probes are fired when executing any query. The query-cache-hit query is triggered when a query exists in the query cache and can be used to return the query cache information. The arguments contain the original query text and the number of rows returned from the query cache for the query. If the query is not within the query cache, or the query cache is not enabled, then the query-cache-miss probe is triggered instead. query-cache-hit(query, rows) query-cache-miss(query) query-cache-hit: Triggered when the query has been found within the query cache. The first argument, query, contains the original text of the query. The second argument, rows, is an integer co