Originally Posted by
Krato5
Hey everyone!
We just wanted to provide you with a little more information about the issues that were experienced with PL yesterday. We performed an upgrade of the database and operating system on the database servers. Once we started up the game, we noticed that our database was performing poorly and under an unusually high load. We also noticed that players were experiencing significantly long load times. This was a result of our database queries taking an extremely long amount of time to complete. We performed several tasks, such as, upgrading the volumes of the database to obtain higher IOPS and executing some clean up/performance optimization actions on the database tables, in an attempt to resolve the problem. Ultimately, the root cause of the problem was that our database was executing a certain query in a very inefficient manner. Instead of using an index scan on our tables, which completed the query in seconds, it used a sequential scan that took minutes to complete. In order to resolve this issue, we made a configuration change that would tell the database to prefer an index scan when executing queries. Once that was implemented, our queries finished quickly and performance returned to normal.
Just want to say thank you all for being patient with us! Apologies for the extremely long downtime, as I know it must have been frustrating having the game down for so long. Thanks again for bearing with us while we worked to find a solution! Have fun playing PL!
Bookmarks