no query cache
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC |
New
|
Undecided
|
Unassigned |
Bug Description
Hi
Why query cache doesn't work?
# mysql --version
mysql Ver 14.14 Distrib 5.6.22-72.0, for debian-linux-gnu (x86_64) using EditLine wrapper
# xtrabackup --version
xtrabackup version 2.2.10 based on MySQL server 5.6.22 Linux (x86_64) (revision id: )
SHOW STATUS LIKE '%cache%'
Variable_name Value
Binlog_
Binlog_cache_use 35758
Binlog_
Binlog_
Com_assign_
Qcache_free_blocks 1
Qcache_free_memory 536852784
Qcache_hits 0
Qcache_inserts 0
Qcache_
Qcache_not_cached 30029936
Qcache_
Qcache_total_blocks 1
Ssl_callback_
Ssl_session_
Ssl_session_
Ssl_session_
Ssl_session_
Ssl_session_
Ssl_session_
Ssl_used_
Table_open_
Table_open_
Table_open_
Threads_cached 4
wsrep_local_
SHOW STATUS LIKE '%wsrep%'
Variable_name Value
wsrep_local_
wsrep_protocol_
wsrep_last_
wsrep_replicated 37065
wsrep_replicate
wsrep_repl_keys 22926283
wsrep_repl_
wsrep_repl_
wsrep_repl_
wsrep_received 18733
wsrep_received_
wsrep_local_commits 36184
wsrep_local_
wsrep_local_replays 0
wsrep_local_
wsrep_local_
wsrep_local_
wsrep_local_
wsrep_local_
wsrep_local_
wsrep_local_
wsrep_local_
wsrep_local_
wsrep_flow_
wsrep_flow_
wsrep_flow_
wsrep_flow_
wsrep_cert_
wsrep_apply_oooe 0.002981
wsrep_apply_oool 0.001267
wsrep_apply_window 1.006018
wsrep_commit_oooe 0.000000
wsrep_commit_oool 0.001155
wsrep_commit_window 1.005236
wsrep_local_state 4
wsrep_local_
wsrep_cert_
wsrep_causal_reads 0
wsrep_cert_interval 0.017719
wsrep_incoming_
wsrep_evs_delayed
wsrep_evs_
wsrep_evs_
wsrep_evs_state OPERATIONAL
wsrep_gcomm_uuid ab0ca01e-
wsrep_cluster_
wsrep_cluster_size 3
wsrep_cluster_
wsrep_cluster_
wsrep_connected ON
wsrep_local_
wsrep_local_index 1
wsrep_provider_name Galera
wsrep_provider_
wsrep_provider_
wsrep_ready ON
Can you provide a use-case as to what things you tried and what things you observed.
Also, can you try it with latest 5.6 ?