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) |