How to optimize server for high traffic load in 32GB RAM Droplet
I am using 32 GB Memory / 40 GB Disk / BLR1 - Ubuntu 16.10 x64 droplet and my android app running on this droplet but i am facing critical issue on server.
Basically my application based on chatting so i installed openfire on this server. sometimes my application API not working because of high traffic load. According to firebase analytics my application active users are 100 per minute. So i am sure that problem occur because of high traffic load. I used all optimized query for application api but still mysqld used 400% CPU usage. its very strange problem me. Why mysqld taking high CPU usage.
Digital Ocean Graph detail
- CPU Usage: Total : 88.82%
- RAM Usage: Total: 14%
strange why RAM used only 14% out of 32GB RAM and CPU taking too much process.
mysqld used too much CPU process.
I try to found solution but still i am not getting any success result. Please help me if someone know that how to fix this issue.