summaryrefslogtreecommitdiff
path: root/Docs
diff options
context:
space:
mode:
authorunknown <arjen@co3064164-a.bitbike.com>2001-12-13 12:00:03 +1000
committerunknown <arjen@co3064164-a.bitbike.com>2001-12-13 12:00:03 +1000
commite5e962e3ae93aa5b5111f38ce723239b0b3ce1f5 (patch)
tree78a6666f2504039fad5b269f350d49b39a5c4398 /Docs
parentb656c048090ee5d4619a70040a6a1c7d307dd3f7 (diff)
downloadmariadb-git-e5e962e3ae93aa5b5111f38ce723239b0b3ce1f5.tar.gz
Formatting fixups in query cache section.
Diffstat (limited to 'Docs')
-rw-r--r--Docs/manual.texi45
1 files changed, 23 insertions, 22 deletions
diff --git a/Docs/manual.texi b/Docs/manual.texi
index 578830fc477..549db7ef1e1 100644
--- a/Docs/manual.texi
+++ b/Docs/manual.texi
@@ -34695,17 +34695,17 @@ transaction cause the corresponding cache entries to be invalidated.
A query cannot be cached if it contains one of the functions:
@multitable @columnfractions .25 .25 .25 .25
@item @strong{Function} @tab @strong{Function}
-@tab @strong{Function} @tab @strong{Function}
+ @tab @strong{Function} @tab @strong{Function}
@item @code{User Defined Functions} @tab @code{CONNECTION_ID}
-@tab @code{FOUND_ROWS} @tab @code{GET_LOCK}
+ @tab @code{FOUND_ROWS} @tab @code{GET_LOCK}
@item @code{RELEASE_LOCK} @tab @code{LOAD_FILE}
-@tab @code{MASTER_POS_WAIT} @tab @code{NOW}
+ @tab @code{MASTER_POS_WAIT} @tab @code{NOW}
@item @code{SYSDATE} @tab @code{CURRENT_TIMESTAMP}
-@tab @code{CURDATE} @tab @code{CURRENT_DATE}
+ @tab @code{CURDATE} @tab @code{CURRENT_DATE}
@item @code{CURTIME} @tab @code{CURRENT_TIME}
-@tab @code{DATABASE} @tab @code{ENCRYPT} (with one parameter)
+ @tab @code{DATABASE} @tab @code{ENCRYPT} (with one parameter)
@item @code{LAST_INSERT_ID} @tab @code{RAND}
-@tab @code{UNIX_TIMESTAMP} (without parameters) @tab @code{USER}
+ @tab @code{UNIX_TIMESTAMP} (without parameters) @tab @code{USER}
@item @code{BENCHMARK}
@end multitable
@@ -34738,6 +34738,7 @@ If this is 0, the query cache is disabled (default).
@item @code{query_cache_startup_type}
This may be set (only numeric) to
@multitable @columnfractions .3 .7
+@item @strong{Option} @tab @strong{Description}
@item 0 @tab (OFF, don't cache or retrieve results)
@item 1 @tab (ON, cache all results except @code{SELECT SQL_NO_CACHE ...} queries)
@item 2 @tab (DEMAND, cache only @code{SELECT SQL_CACHE ...} queries)
@@ -34771,16 +34772,15 @@ specified in a @code{SELECT} query:
@findex SQL_CACHE
@findex SQL_NO_CACHE
-@itemize
+@multitable @columnfractions .3 .7
+@item @strong{Option} @tab @strong{Description}
@item @code{SQL_CACHE}
-If @code{SQL_QUERY_CACHE_TYPE} is @code{DEMAND},
-allow the query to be cached.
-If @code{SQL_QUERY_CACHE_TYPE} is @code{ON}, this is the default.
-If @code{SQL_QUERY_CACHE_TYPE} is @code{OFF}, do nothing.
+ @tab If @code{SQL_QUERY_CACHE_TYPE} is @code{DEMAND}, allow the query to be cached.
+ If @code{SQL_QUERY_CACHE_TYPE} is @code{ON}, this is the default.
+ If @code{SQL_QUERY_CACHE_TYPE} is @code{OFF}, do nothing.
@item @code{SQL_NO_CACHE}
-Make this query non-cachable, don't allow this query to be stored
-in the cache.
-@end itemize
+ @tab Make this query non-cachable, don't allow this query to be stored in the cache.
+@end multitable
@node Query Cache Status and Maintenance, , Query Cache in SELECT, Query Cache
@@ -34796,19 +34796,20 @@ query cache.
You can monitor query cache performance in @code{SHOW STATUS}:
-@itemize
+@multitable @columnfractions .3 .7
+@item @strong{Variable} @tab @strong{Description}
@item @code{Qcache_queries_in_cache}
-Number of queries registered in the cache.
+ @tab Number of queries registered in the cache.
@item @code{Qcache_inserts}
-Number of queries added to the cache.
+ @tab Number of queries added to the cache.
@item @code{Qcache_hits}
-Number of cache hits
+ @tab Number of cache hits
@item @code{Qcache_not_cached}
-Number of non-cached queries
-(not cachable, or due to SQL_QUERY_CACHE_TYPE)
+ @tab Number of non-cached queries
+ (not cachable, or due to SQL_QUERY_CACHE_TYPE)
@item @code{Qcache_free_memory}
-Amount of free memory for query cache.
-@end itemize
+ @tab Amount of free memory for query cache.
+@end multitable
Please note:
Total number of queries =