Beta Branch disable query_cache with mariadb 10.1 default installs

For me this one was not able to disable it:

Code:

query_cache_type = 0

at least mysqltuner can't see it as disable.....

I had to set to 0 also this:

Code:

query_cache_size = 0

Then all ok

Maybe you must set this also to 0 on the Centminmod mycnf templates?

 

So, do you advice to disable query_cache on innodb tables in mariadb ?

I have about 10gigabyte innodb database on my xenforo board and using query_cache with very big config size.

 

Mine was:

 

I tried a few days disabled the query_cache but i observe the negative effect on performance. I didn't any test but i feel the latency while open the thread_view pages especially. So i enabled it again. My database server only runs the mariadb and has 48gb of ram so cache maybe better, i don't know

 

We need a benchmark for this

 

How can i benchmark it ? If you tell me a way, then i can do it and share with you. But personally, i see that page generate times some increased after query_cache disabled.

 

Don't know

 

Be sure almost all of your tables are on Innodb and nothing on MyIsam.