-
1. Re: vizql and redis interaction
lenaic.ridingerDec 13, 2016 5:44 AM (in response to learner always)
Hello learner always,
I'm not well versed into Cache and Server, however I'm sure how community could help you on that matter.
Does anyone knows why the why would total_net_output_bytes is reported as '0'?
-
2. Re: vizql and redis interaction
learner always Dec 13, 2016 8:57 AM (in response to lenaic.ridinger)Along the same lines i see the following parameter set to true, i.e. disabled, what does this parameter mean:
backgrounder.properties:backgrounder.external_native_query_cache_disable=true
backgrounder.properties:external_native_query_cache_disable=true
backgrounder.properties:vizportal.external_native_query_cache_disable=true
backgrounder.properties:wgserver.external_native_query_cache_disable=true
dataserver.properties:backgrounder.external_native_query_cache_disable=true
dataserver.properties:vizportal.external_native_query_cache_disable=true
dataserver.properties:wgserver.external_native_query_cache_disable=true
filestore.properties:backgrounder.external_native_query_cache_disable=true
filestore.properties:vizportal.external_native_query_cache_disable=true
filestore.properties:wgserver.external_native_query_cache_disable=true
tabadminservice.properties:backgrounder.external_native_query_cache_disable=true
tabadminservice.properties:vizportal.external_native_query_cache_disable=true
tabadminservice.properties:vizqlserver.external_native_query_cache_disable=true
tabadminservice.properties:wgserver.external_native_query_cache_disable=true
vizportal.properties:backgrounder.external_native_query_cache_disable=true
vizportal.properties:external_native_query_cache_disable=true
vizportal.properties:vizportal.external_native_query_cache_disable=true
vizportal.properties:wgserver.external_native_query_cache_disable=true
vizql.properties:backgrounder.external_native_query_cache_disable=true
vizql.properties:external_native_query_cache_disable=true
vizql.properties:vizportal.external_native_query_cache_disable=true
vizql.properties:wgserver.external_native_query_cache_disable=true
workgroup.yml:backgrounder.external_native_query_cache_disable: true
workgroup.yml:vizportal.external_native_query_cache_disable: true
workgroup.yml:vizqlserver.external_native_query_cache_disable: true
workgroup.yml:wgserver.external_native_query_cache_disable: true
Thanks,
-
3. Re: vizql and redis interaction
learner always Dec 13, 2016 10:11 AM (in response to learner always)Another parameter that is confusing:
backgrounder.properties:dataserver.external_abstract_query_cache_disable=true
dataserver.properties:dataserver.external_abstract_query_cache_disable=true
dataserver.properties:external_abstract_query_cache_disable=true
filestore.properties:dataserver.external_abstract_query_cache_disable=true
tabadminservice.properties:dataserver.external_abstract_query_cache_disable=true
vizportal.properties:dataserver.external_abstract_query_cache_disable=true
vizql.properties:dataserver.external_abstract_query_cache_disable=true
workgroup.yml:dataserver.external_abstract_query_cache_disable: true
Whats the difference between external_abstract_query_cache_disable and external_native_query_cache_disable
Thanks,
-
4. Re: vizql and redis interaction
Russell Christopher Dec 13, 2016 10:53 AM (in response to learner always)2 of 2 people found this helpfulHey Learner!
Glad you're having fun with the YAML files! However, the settings which aren't documented....well, they aren't documented. You generally won't get much additional help with them here because we frankly don't want you messing with them and potentially breaking something
You should also keep in mind that some of the settings you see may not even apply to your "On-prem" Tableau Server - some of them are used for Tableau Online or Public.
SO, if you're really curious about these, my advice would be to change them (on a QA server) and see what happens! 60% of the time, you probably won't be able to detect a difference. 20% of the time ou'll break something, the other 20% might yield some interesting results.
FYI, the difference between the abstract and native cache is the TYPE of data they hold. The abstract cache is a more generalized cache that can often be re-used many times to answer slightly different questions. Entries in the Native cache are tried directly to a specific querystring & connect string combination.
-
5. Re: vizql and redis interaction
learner always Dec 13, 2016 11:10 AM (in response to Russell Christopher)Thanks Russell,
Understood, do these settings impact "on-perm" tableau server or are they for online only.
-
6. Re: vizql and redis interaction
Russell Christopher Dec 13, 2016 11:13 AM (in response to learner always)Don't know - I'd never be interested in these settings because turning the cache off would be bad for all-around performance. I'm sure there's a reason why they're in there, but I don't know it