Hello 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.
Other detail mysqld: 437.56% Java: 238.11% Apache2: 231.02%
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.
Thanks
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
A single node is a single point of failure. It would be a good idea to use a multi-tier architecture, look at load balancing your app, and to scale horizontally. You’ll get far better performance from many smaller droplets than one expensive high mem system.
I would also refrain from using a non-LTS release of Ubuntu - 16.10 has been EOL since July.
400 rps is NOT highload; it’s your application being inefficient. Start by profiling mysql load. Post samples of SHOW FULL PROCESSLIST and SHOW VARIABLES. Do the normal tuning dance with mysql tuner script. Show SQL dataset sizes. Enable slow logging and check tables for queries with missing or suboptimal indices. There’s plenty of tuning to do.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.