Forums - Thread Details
  • State Not Answered
  • Replies 2 replies
  • Subscribers 319 subscribers
  • Views 1635 views
  • Users 0 members are here
Forum Actions
Related

external cache db    what does it do

David Matrai

Hello Community, 

Using SugarCRM 9.01   - onsite 

I am running into an issue of my database server filling up its temp file and then slowly filling up the HDD space causing Sugar to stop functioning. 

After looking at everything I possibly can I have come to this 

Whenever a write query is performed on key_value_cache table the temp file fills exponentially until it has no more room to grow. 

I have found references to the following setting 

$sugar_config['external_cache_disabled_db'] = true; 

but cannot find reference as to what this actually does other than not write that query. 

Can someone tell me what this does in Sugar   and will performance be compromised if I enable this setting ? 

Any help is greatly appreciated. 

Parents
  • 0

    Hi David,

    We use the external caches in SugarCRM to enhance the performance. There are many supportable caches for store the Sugar Files like APC, Memcached, etc. For storing the DB queries external_cache_disabled_db property is used.

    If the performance is the concern then it totally depends that what is actual load on the server. Like currently I am working on a project in which Sugar instance is deployed on some "ABC" server, its DB is deployed on some "XYZ" server and Elastic search is on some other server and bandwidth and load on the server is also not too much that is why here in this situation there is no need to enable any external caches.

    But if the load on the server is more and there are many instances and DBs deployed on the same server then there will need to enable the external caches because data retrieval from the files takes less time and while querying from the DB tables will take more time.

Reply
  • 0

    Hi David,

    We use the external caches in SugarCRM to enhance the performance. There are many supportable caches for store the Sugar Files like APC, Memcached, etc. For storing the DB queries external_cache_disabled_db property is used.

    If the performance is the concern then it totally depends that what is actual load on the server. Like currently I am working on a project in which Sugar instance is deployed on some "ABC" server, its DB is deployed on some "XYZ" server and Elastic search is on some other server and bandwidth and load on the server is also not too much that is why here in this situation there is no need to enable any external caches.

    But if the load on the server is more and there are many instances and DBs deployed on the same server then there will need to enable the external caches because data retrieval from the files takes less time and while querying from the DB tables will take more time.

Children
No Data