Index
[SYMBOL]
[A]
[B]
[C]
[D]
[E]
[F]
[G]
[H]
[I]
[J]
[K]
[L]
[M]
[N]
[O]
[P]
[Q]
[R]
[S]
[T]
[U]
[V]
[W]
[X]
[Y]
[Z]
Qcache_free_blocks status variable Qcache_free_memory status variable Qcache_hits status variable Qcache_inserts status variable Qcache_lowmem_prunes status variable Qcache_not_cached status variable Qcache_queries_in_cache status variable Qcache_total_blocks status variable queries cache configuring defragmenting disabling functionality identical queries incoming queries maintenance non-cached queries options performance monitoring status transactions variable-length blocks optimizer, controlling performance, estimating resolving with index tree results, viewing rows, retrieving running on SQL nodes speed column length mismatches condition pushdowns constant tables distinct values eq_ref tables Extra column filesorts full table scans increasing indexes join types keys LEFT JOIN multiple-table joins possible_keys column ranges ref column ref tables ref_or_null joins rows column SELECT types slow subqueries system tables tables temporary tables WHERE clauses subqueries very fast examples query_alloc_block_size system variable 2nd query_cache_limit system variable 2nd 3rd query_cache_min_res_unit system variable 2nd query_cache_size system variable 2nd 3rd query_cache_type system variable 2nd 3rd query_cache_wlock_invalidate system variable 2nd QUERY_EVENT event query_prealloc_size system variable 2nd questions Questions status variable quick option myisamchk mysql mysqlcheck mysqldump quiet option (mysqlhotcopy) QUIT command (ndb_mgm) quote-names option (mysqldump)
|