Geek Answers Handbook

Mysql query cache processing on multiple instances of the same Linux machine

I have 4 instances of mysql db on a shared linux server (port 3306, 3307, 3308, 3309). I am trying to improve the frequency of requests cache hit by tuning using server variables.

My doubt is that if I go into the instance of port 3306 and run commands to display the north and state variables (for example, the display status, for example "% Qcache%"), is this a result common to all instances, or it is specific to this only instance.

So, I want to know that I set the variables for each instance or their setting applies to all (in this case, the variables are related to query_cache)

+4
source share
2 answers

MySQL, . , my.cnf .

0

4 mysql, 3306, 3307, 3308, 3309, show status like '%Qcache%' .

:

Qcache_free_blocks       numeric    GLOBAL
Qcache_free_memory       numeric    GLOBAL
Qcache_hits              numeric    GLOBAL
Qcache_inserts       numeric    GLOBAL
Qcache_lowmem_prunes     numeric    GLOBAL
Qcache_not_cached        numeric    GLOBAL
Qcache_queries_in_cache  numeric    GLOBAL
Qcache_total_blocks      numeric    GLOBAL

, .

?

0

More articles:


All Articles