IBM Support

How to Optimize Mongo Performance with IBM Content Analyzer

How To


Summary

For IBM Business Automation Content Analyzer (ACA) systems that use Mongo for their database, performance can degrade as the database accumulates more data after heavy or long-term use. The user observes documents taking longer to process, and in severe cases might see timeout errors preventing documents from processing at all.

This technote provides a procedure to clear out the data and restore performance to previous levels.

Environment

Applies to Content Analyzer versions 20.0.1 and earlier, which used Mongo for the database.  Version 20.0.2 does not use Mongo and is not subject to the performance degradation.

Steps

  1. From the command line, get the names for the Mongo pods. 
    kubectl -n <namespace> get pods | grep mongo
  2. Log in to the Mongo pod. 
    kubectl -n <namespace> exec -it <name for Mongo pod> /bin/bash
  3. Log in to the Mongo database. 
    mongo --host 127.0.0.1:27017 --username admin --password $ENTRYPASSWORD --authenticationDatabase admin --ssl --sslPEMKeyFile /etc/certs/mongo.pem --sslCAFile /etc/certs/mongo.crt --sslAllowInvalidCertificates
  4. Optional: Show the databases and sizes. 
    show dbs
  5. Drop the cogdig database. 
    use cogdig
    db.dropDatabase()
  6. Quit from the Mongo database and exit the pod. 
    quit()
    exit
  7. Log in to the Mongo admin pod. 
    kubectl -n <namespace> exec -it <name for Mongo admin pod> /bin/bash
  8. Log in to the Mongo admin database. 
    mongo --host 127.0.0.1:27017 --username admin --password $ENTRYPASSWORD --authenticationDatabase admin --ssl --sslPEMKeyFile /etc/certs/mongo.pem --sslCAFile /etc/certs/mongo.crt --sslAllowInvalidCertificates
  9. Optional: Show the databases and sizes. 
    show dbs
  10. Drop the binaryfiles database. 
    use binaryfiles
    db.dropDatabase()
  11. Quit from the Mongo admin database and exit the pod. 
    quit()
    exit
  12. Restart any one backend pod.

Document Location

Worldwide

[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSUM7G","label":"IBM Business Automation Content Analyzer on Cloud"},"ARM Category":[{"code":"a8m0z0000001jATAAY","label":"ACA App Management"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

Document Information

Modified date:
23 November 2020

UID

ibm16371346

Page Feedback