The VPS server is hanging.

Grigory, I have analyzed the support report and the current state of the server. The overload of MySQL in conjunction with OpenCart is a critical but solvable problem that usually arises from non-optimal queries of heavy modules or aggressive bot attacks. I will conduct a detailed audit of the slow query logs to identify and completely eliminate the malfunctioning module, as well as optimize the structure of the tables and indexes of the database to reduce the load. At the same time, I will set up reliable protection against synthetic traffic at the web server level or Cloudflare, which will allow us to cut off useless parsers and free up resources for real users. Additionally, I will adjust the MySQL configuration files to fit the architecture of your server to ensure maximum system stability. As a result, we will achieve smooth operation of the website without freezes and the need for constant reboots. I am ready to start working promptly.

Show original

Translate

Hello. I am ready to discuss the details of our collaboration. Write to me. Thank you.

Show original

Translate

Good day!

I will solve the problem with the VPS hanging. I will remove the faulty module, optimize MySQL, and limit synthetic traffic. I have experience working with OpenCart and optimizing server loads.

Feel free to contact me, and we will discuss the details.

Show original

Translate

Good day, Konstantin!
I will conduct diagnostics of the server, requests, and logs to identify the problematic plugin and problematic requests.
Feel free to reach out if you are interested in the offer or have any questions.

Show original

Translate

Hello! I am ready to help with your project. I have extensive experience in development and will be able to implement all necessary components according to your documentation. I guarantee quality execution within the agreed deadlines.

Show original

Translate

Hello. Contact me, I will do it. OpenCart, its database is what I know perfectly, I know all the problems related to it.

Show original

Translate

Hello, I have extensive experience in optimizing VPS. I will identify the problematic module through analyzing slow query logs in MySQL. To cut off synthetic traffic and parsers, I will set up filtering through Cloudflare or server limits. I am ready to start working right now.

Show original

Translate

Good day, I have experience solving similar tasks for large portals with high traffic, I will conduct an audit to identify bottlenecks, I will select the optimal configuration, for discussion please write to me in private messages.

Show original

Translate

Good day.
I am ready to help solve the problem.
It seems that the reason is the large number of requests to the web, which in turn affects the load on MySQL.
I will conduct a full diagnosis and perform optimization of MySQL and Nginx settings, and if necessary, I will disable the problematic module.
Feel free to reach out.

Show original

Translate

The problem is clear: heavy requests from a faulty module + external synthetic traffic are overwhelming MySQL. I will analyze the slow query log, find the source of the load, remove/disable the problematic module, and set up basic rate limiting at the nginx or .htaccess level to filter out bots.

Which module do you suspect — do you have any ideas, or should I start searching from scratch through the logs?

Show original

Translate