My System just uses 1GB of Ram but i get a lot of nginx 504 Errors and i guess mysql is the bottleneck
any hints welcome
Asked
Active
Viewed 52 times
-3
-
High CPU is almost always fixed by adding a better index (sometimes 'composite') and/or reformulating slow queries. Start a new Question with the queries and `SHOW CREATE TABLE`. – Rick James May 02 '19 at 13:33
1 Answers
3
I have a a number of hints
- Install monitoring and use it to gather information about your system.
- Read your logs to learn more about your system
- Learn scientific method, and use it with 1 and 2 above to diagnose faults.
- Learn how to write a better question.
user9517
- 114,104
- 20
- 206
- 289