We found that the smartfox server's concurrent users count dropped significantly when we are exporting data from MySQL database.
The concurrent users count dropped from around 1500 to 750 during the database data exporting.
The max connections of the DB is 312, and there is no connections refused due to the max_connections limit in the DB's status.
We are using:
- SFS2X v2.13.0 (Amazon EC2 server)
- MySQL database (Amazon RDS server)
Why users are being disconnected during database data exporting?
Thanks in advance,
Sunny
Here is the log:
Code: Select all
17 Mar 2021 | 15:00:16,337 | INFO | SFSWorker:Sys:3 | v2.api.SFSApi | | User disconnected: { Zone: ABC }, ( User Name: 20602847, Id: 42586, Priv: 1, Sess: 60.249.199.88:57485 ) , SessionLen: 437081, Type: Unity / .Net
17 Mar 2021 | 15:00:16,337 | INFO | SFSWorker:Sys:3 | entities.managers.SFSRoomManager | | Room removed: { Zone: ABC }, [ SFSGame: NR1_171453377231, Id: 39598, Group: NR1, public: false, minPlayers: 2 ], Duration: 397064
17 Mar 2021 | 15:00:16,338 | INFO | SFSWorker:Sys:3 | v2.api.SFSApi | | User disconnected: { Zone: ABC }, ( User Name: 20981217, Id: 42732, Priv: 1, Sess: 180.217.46.201:10612 ) , SessionLen: 393170, Type: Unity / .Net
17 Mar 2021 | 15:00:16,338 | INFO | SFSWorker:Sys:3 | entities.managers.SFSRoomManager | | Room removed: { Zone: ABC }, [ SFSGame: SR1_171456061323, Id: 40105, Group: SR1, public: false, minPlayers: 2 ], Duration: 250137
17 Mar 2021 | 15:00:16,338 | INFO | SFSWorker:Sys:3 | v2.api.SFSApi | | User disconnected: { Zone: ABC }, ( User Name: 20955370, Id: 43190, Priv: 1, Sess: 223.136.43.58:26795 ) , SessionLen: 257034, Type: Unity / .Net
17 Mar 2021 | 15:00:16,338 | INFO | SFSWorker:Sys:3 | entities.managers.SFSRoomManager | | Room removed: { Zone: ABC }, [ SFSGame: NR1_171456344714, Id: 40195, Group: NR1, public: false, minPlayers: 2 ], Duration: 221831
17 Mar 2021 | 15:00:16,339 | INFO | SFSWorker:Sys:3 | v2.api.SFSApi | | User disconnected: { Zone: ABC }, ( User Name: 20557314, Id: 43310, Priv: 1, Sess: 27.147.29.110:61050 ) , SessionLen: 223173, Type: Unity / .Net