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.
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×