Project Operation day 1-storms

On the first day of project operation, problems continued.

 

First, when the traffic reaches 200 at night, the server will be suspended. It will take about 1 minute.

Check table structure. If no index exists, the index is immediately added.

 

The next day, I reported again that the system was suspended when the traffic reached 400 in the middle of the night.

Check the table structure again, modify the Log Type table to MyISAM, and improve performance again.

 

The game server crashes. It took me two hours to immediately separate the game server from the website server.

 

After that, the game server failed to be recharged, and the game server was immediately checked. After the upgrade, the website server could not directly call the game server, so it immediately changed the recharge protocol and used the remote socket link.

 

The level of the military will be reduced. This problem has been found for a long time, allCodeAfter checking, there is no logic problem.

Finally, it is locked on the timetask of Java. It seems that there is a conflict with Mina and netty, And it is immediately replaced with thread for re-deployment. It seems that there is no problem again. At this time, it was midnight.

 

Basically, it is annoying to use a third-party framework. Many strange problems may occur.

In addition, the performance problem of the entire server is in the database, which is very disgusting. MySQL performance is not flattering...

 

There are several bugs left, but the problem is not big. Next, let's see if there are still problems with 1000 online users. If there are still problems, modify the database insertion logic and submit it to a queue for merge insertion. Let's talk about it later.