Habeeb556 commented on issue #29401:
URL: https://github.com/apache/superset/issues/29401#issuecomment-2255641430

   NICE! RESOLVED
   
   
   ```
   REDIS_HOST = os.getenv("REDIS_HOST", "localhost")
   REDIS_PORT = os.getenv("REDIS_PORT", "6379")
   REDIS_CELERY_DB = os.getenv("REDIS_CELERY_DB", "2")
   REDIS_RESULTS_DB = os.getenv("REDIS_RESULTS_DB", "3")
   REDIS_CACHE_DB = os.getenv("REDIS_CACHE_DB", "4")
   
   # Redis Caching
   CACHE_CONFIG = {
       "CACHE_TYPE": "RedisCache",
       "CACHE_DEFAULT_TIMEOUT": 900,
       "CACHE_KEY_PREFIX": "superset_results",
       "CACHE_REDIS_URL": f"redis://{REDIS_HOST}:{REDIS_PORT}/{REDIS_CACHE_DB}",
   }
   DATA_CACHE_CONFIG = CACHE_CONFIG
   
   # Long running query handling using Celery workers
   class CeleryConfig(object):
       BROKER_URL = f"redis://{REDIS_HOST}:{REDIS_PORT}/{REDIS_CELERY_DB}"
       CELERY_IMPORTS = ("superset.sql_lab", "superset.tasks.thumbnails")
       CELERY_RESULT_BACKEND = 
f"redis://{REDIS_HOST}:{REDIS_PORT}/{REDIS_RESULTS_DB}"
       #CELERY_ANNOTATIONS = {"sql_lab.add": {"rate_limit": "10/s"}}
       CELERYD_LOG_LEVEL = 'DEBUG'
       CONCURRENCY = 1
       #CELERYD_PREFETCH_MULTIPLIER = 10
       #CELERY_ACKS_LATE = TRUE
   
   CELERY_CONFIG = CeleryConfig
   
   # Persisting results from running query handling using Celery workers
   from cachelib.redis import RedisCache
   RESULTS_BACKEND = RedisCache(host='localhost', port=6379, 
key_prefix='superset_results')
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org
For additional commands, e-mail: notifications-h...@superset.apache.org

Reply via email to