Why did the CPU load skyrocket to 100%?

Question

Network administration

Server on digitalocean.com, MYSQL is crashing, what could be causing it?

Answer 1

See mysql logs. Queries without indexes are possible. Perhaps some thread innodbshnaya whistle flew off. Everything will be in the logs.
UPD. Well, they would write the characteristics of the machine + the average size of the tables + the load on mysql (requests per second), for example, you can see it through mytop.

Answer 2

See what queries are running now
SHOW PROCESSLIST
Log slow queries - write something like this in the config:
slow-query-log = 1
slow-query-log-file = /var/log/mysql/mysql-slow.log
long_query_time = 1
log -queries-not-using-indexes

Answer 3

Well, it’s corny that you have the most deshmanic droplet for schoolchildren, the Apache gobbled up all the resources, the muscle died due to lack of memory here and you don’t need to go to a fortuneteller