Tchater maintenant avec le support
Tchattez avec un ingénieur du support

Spotlight on Oracle 10.6 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

Query Cache Hit Rate Alarm

The MySQL query cache stores the most recent SELECT queries performed by the MySQL database server, together with the result sets of those queries. This can reduce much of the parsing overhead, and logical or physical I/O, associated with those queries if and when the queries are repeated.

The Query Cache Hit Rate alarm fires when the proportion of SQL queries that can be found in the MySQL query cache drops below a specified threshold.

You may be able to tune the performance of the query cache by modifying configuration variables to:

  • Change the size or type of the query cache.
  • Change the maximum size of queries that can be cached.
  • Change the allocation size or minimum block size for cached queries.

 

Related Topics

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation