- Posts
- 10,811
- Posts Power
- 10,811.0%
- Liked
- 890
- Joined
- Jan 2, 1996
- Website
- inviteshop.us
Update completed, about the upgrade problems and instability in the past week
First of all, I apologize for the problems that have been going on for so many days.
I upgraded the server today and found the root cause of the crash problem. I was deceived by the pagoda panel. In the pagoda monitoring, the crash always showed that mysql was overloaded. I didn't check the system records and the changes in the monitoring system. I have been checking various problems with mysql. When I consulted others, they also asked about the high load of mysql. In the middle, mysql was reinstalled. More problems occurred. The impact of the constant crash was too great. I took the time to study the mysql log in the past few days, and many other problems were not dealt with. Sorry again.
I asked the maintenance boss for help this time. After looking at it for a while, he found that it was a virtual memory problem. This server was not configured with virtual memory. A certain program caused the memory to increase. After a certain proportion, the kswapd0 process wanted to use virtual memory, but there was no virtual memory available, so an error occurred, causing the system to freeze. At this time, mysql wanted to read the database, so it also froze. When mysql froze and most programs froze, the memory usage was low, and the kswapd0 process was restored, and so on. The Pagoda panel only shows that MySQL is stuck. This problem can be solved by adding virtual memory. It took so many days to solve such a simple problem.
I also upgraded the server configuration. After monitoring for a long time, there is no problem. If there is a problem, just PM the management group.
The server upgrade is completed. The problem of no increase in magic power since the 22nd has been fixed. Compensation magic power +66688
First of all, I apologize for the problems that have been going on for so many days.
I upgraded the server today and found the root cause of the crash problem. I was deceived by the pagoda panel. In the pagoda monitoring, the crash always showed that mysql was overloaded. I didn't check the system records and the changes in the monitoring system. I have been checking various problems with mysql. When I consulted others, they also asked about the high load of mysql. In the middle, mysql was reinstalled. More problems occurred. The impact of the constant crash was too great. I took the time to study the mysql log in the past few days, and many other problems were not dealt with. Sorry again.
I asked the maintenance boss for help this time. After looking at it for a while, he found that it was a virtual memory problem. This server was not configured with virtual memory. A certain program caused the memory to increase. After a certain proportion, the kswapd0 process wanted to use virtual memory, but there was no virtual memory available, so an error occurred, causing the system to freeze. At this time, mysql wanted to read the database, so it also froze. When mysql froze and most programs froze, the memory usage was low, and the kswapd0 process was restored, and so on. The Pagoda panel only shows that MySQL is stuck. This problem can be solved by adding virtual memory. It took so many days to solve such a simple problem.
I also upgraded the server configuration. After monitoring for a long time, there is no problem. If there is a problem, just PM the management group.
The server upgrade is completed. The problem of no increase in magic power since the 22nd has been fixed. Compensation magic power +66688