no query cache

[Jakub]

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_cache_disk_use 13
Binlog_cache_use 35758
Binlog_stmt_cache_disk_use 0
Binlog_stmt_cache_use 0
Com_assign_to_keycache 0
Qcache_free_blocks 1
Qcache_free_memory 536852784
Qcache_hits 0
Qcache_inserts 0
Qcache_lowmem_prunes 0
Qcache_not_cached 30029936
Qcache_queries_in_cache 0
Qcache_total_blocks 1
Ssl_callback_cache_hits 0
Ssl_session_cache_hits 0
Ssl_session_cache_misses 0
Ssl_session_cache_mode NONE
Ssl_session_cache_overflows 0
Ssl_session_cache_size 0
Ssl_session_cache_timeouts 0
Ssl_used_session_cache_entries 0
Table_open_cache_hits 0
Table_open_cache_misses 0
Table_open_cache_overflows 0
Threads_cached 4
wsrep_local_cached_downto 64396

SHOW STATUS LIKE '%wsrep%'

Variable_name Value
wsrep_local_state_uuid f3333428-1016-11e5-a536-623568bf77fc
wsrep_protocol_version 7
wsrep_last_committed 66516
wsrep_replicated 37065
wsrep_replicated_bytes 3038640736
wsrep_repl_keys 22926283
wsrep_repl_keys_bytes 184268013
wsrep_repl_data_bytes 862034268
wsrep_repl_other_bytes 0
wsrep_received 18733
wsrep_received_bytes 14092084
wsrep_local_commits 36184
wsrep_local_cert_failures 16
wsrep_local_replays 0
wsrep_local_send_queue 0
wsrep_local_send_queue_max 10
wsrep_local_send_queue_min 0
wsrep_local_send_queue_avg 0.007299
wsrep_local_recv_queue 0
wsrep_local_recv_queue_max 10
wsrep_local_recv_queue_min 0
wsrep_local_recv_queue_avg 0.010303
wsrep_local_cached_downto 64399
wsrep_flow_control_paused_ns 116657760051
wsrep_flow_control_paused 0.000961
wsrep_flow_control_sent 0
wsrep_flow_control_recv 236
wsrep_cert_deps_distance 35.898569
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_state_comment Synced
wsrep_cert_index_size 219
wsrep_causal_reads 0
wsrep_cert_interval 0.017719
wsrep_incoming_addresses xxxx
wsrep_evs_delayed
wsrep_evs_evict_list
wsrep_evs_repl_latency 0.00176517/0.00176517/0.00176517/0/1
wsrep_evs_state OPERATIONAL
wsrep_gcomm_uuid ab0ca01e-1d4e-11e5-baac-b2da4ec21bdb
wsrep_cluster_conf_id 9
wsrep_cluster_size 3
wsrep_cluster_state_uuid xxx
wsrep_cluster_status Primary
wsrep_connected ON
wsrep_local_bf_aborts 9
wsrep_local_index 1
wsrep_provider_name Galera
wsrep_provider_vendor Codership Oy <email address hidden>
wsrep_provider_version 3.9(r93aca2d)
wsrep_ready ON

[Krunal Bauskar (krunal-bauskar)]

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 ?

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-1833