Front End 100% CPU Load and DB high CPU Utilization

Sync warpack between test and production for Front End server and the performance improve.

Customer reported that DB server now is having high CPU Utilization.

After checking log and performance, it is found that these are typical activities. Inform customer as below:

It is not MySQL DB that make the high utilization on CPU, but it is MongoDB.

Since both DBs are sitting on the same server, given time this is only natural.

As time goes by the data growth has becoming increasingly large and hence the processing needs to increase over time.

However, we will assist on clearing unwanted logs in the DBs and perform indexing, but this will not guarantee help on CPU usage.

Suggest to customer to do the following:

We have check with the installation team and usually for PRODUCTION environment, it is recommended to use 4 servers as below:

1. Frontend server
2. Backend server
3. DB server
4. Cache server (This will host the MongoDB)

Definitely the DBs are separated into 2 servers because over time the volume can only increase. In this case, you may probably need to separate the two DBs into separate servers.