• 0
Sign in to follow this  
Digao_go

Qcache_queries_in_cache

Question

Ola pessoal! Tenho um problema . Meu MYSQL não coloca nada em cache. Já tentei simular, já fiz de tudo.

Peço que se possivel alguém possa me ajudar, ficarei muito grato. Já li tudo na web, pessoa so manda ativar e setar o tamanho,

peguei exemplos onde criam uma tabela, insere, da o select e nada.. Não usei funções nos selects, nada..

Qcache_free_blocks 1

Qcache_free_memory 33536952

Qcache_hits 0

Qcache_inserts 0

Qcache_lowmem_prunes 0

Qcache_not_cached 6777

Qcache_queries_in_cache 0

Qcache_total_blocks 1

ft_query_expansion_limit 20

have_query_cache YES

long_query_time 10.000000

query_alloc_block_size 8192

query_cache_limit 8388608

query_cache_min_res_unit 4096

query_cache_size 33554432

query_cache_type ON

query_cache_wlock_invalidate OFF

query_prealloc_size 8192

slow_query_log OFF

slow_query_log_file C:\ProgramData\MySQL\MySQL Server 5.5\Data\mysql-slow.log

Share this post


Link to post
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this