Based on the results of studying the situation, we see that at the moment, the main load on the server is created by input / output to the disk subsystem:
The mysql database server generates this load:
This server was not configured by us and we do not have a root password for the database server. Check with your server administrator what might be causing the load. With respect, Pogoriliy Andriy Technical support HostPro
Based on the results of studying the situation, we see that at the moment,
the main load on the server is created by input / output to the disk subsystem:
[file]5584[/file]
The mysql database server generates this load:
[file]5585[/file]
This server was not configured by us and we do not have a root password for the database server.
Check with your server administrator what might be causing the load.
With respect,
Pogoriliy Andriy
Technical support HostPro
The operation of the system, namely: crowns, users, etc. When you log in, you make inserts into the database, in turn the database writes the results of its work to disk, thus generating load on it. What is the problem at the moment?
The operation of the system, namely: crowns, users, etc. When you log in, you make inserts into the database, in turn the database writes the results of its work to disk, thus generating load on it. What is the problem at the moment?
Now, everything is fine, we want to understand the reason for what happened at 2:00, what actions generated this load, why the server was not available from 2:00 to 8:30, why it did not restart itself. We want to understand what we can do to prevent this in the future
Now, everything is fine, we want to understand the reason for what happened at 2:00, what actions generated this load, why the server was not available from 2:00 to 8:30, why it did not restart itself. We want to understand what we can do to prevent this in the future
Good afternoon. At night, in the time interval from one to 5, the system update is launched. If the structure of the database changes during the update then this process requires exclusive access to the database. At 2-40, the database backup starts. Creating a backup also requires exclusive access to the database. Time, creating a backup copy of your database, approximately 40 minutes. Today, these processes have been superimposed requiring exclusive access to the database. Competing transactions locked parts of the database and were waiting for access. By about 8:30 all processes were finalized, the backup was created and the system became available. Now the start of creating a copy of the database has been moved to 2:20. The backup process is optional, you can change it at your discretion or disable it.
Good afternoon.
At night, in the time interval from one to 5, the system update is launched. If the structure of the database changes during the update
then this process requires exclusive access to the database.
At 2-40, the database backup starts. Creating a backup also requires exclusive access to the database.
Time, creating a backup copy of your database, approximately 40 minutes.
Today, these processes have been superimposed requiring exclusive access to the database.
Competing transactions locked parts of the database and were waiting for access.
By about 8:30 all processes were finalized, the backup was created and the system became available.
Now the start of creating a copy of the database has been moved to 2:20.
The backup process is optional, you can change it at your discretion or disable it.
Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter.
Log in and comment
Donate
You don't have enough funds in your account Top up