Nuxeo Performance Issues
I have a bad situation, Nuxeo isn't going well :(. I use Nuxeo 9.10 version and Nuxeo has a lot of performance issues. I attached appdynamics screenshots. As you can see some methods are very slow, such as /nuxeo/api/v1/path, /nuxeo/api/v1/group,/nuxeo/api/v1/repo
com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke org.nuxeo.ecm.restapi.server.APIServlet.service java.util.concurrent.locks.LockSupport.parkNanos
Do you have any ideas or suggestions?
I assume it used to work just fine and the performance started to degrade, presumably with increased data volume? Was it a gradual process, or did it happen day-by-day?
In principle Nuxeo as such shouldn't be the performance bottleneck. Just like any other ECM, it has underlying storage. Here you would typically have at least 2: Elastic and a DB, as far as I remember you have a relational DB underneath. I'd say with 70% of certainty the problem lays somewhere in there.
- Start with monitoring slow queries: https://doc.nuxeo.com/nxdoc/monitoring-slow-nxql-queries/
- Run profiling on my database
- Run detailed profiling on Nuxeo. Appdynamics should let you drill down to the very last method costing time.