Lost connection to Mysql during query

[Necrox Guy]

Hello I have a big problem at my server, I'm using TFS 0.3.1 PL2, the problem is that after about 8-9 hours of uptime with about 200~300 players i see the following error on the console.
"Lost connection to Mysql during query"
So my question is why is this happening,

This is my config.lua:
sqlKeepAlive = 60
mysqlReadTimeout = 10

If i change that to 0 would that help me out to fix this?

Also i have another question, what distro is better?
TFS 0.3.1 PL2
TFS 0.3.2
TFS 0.3.3 (i doubt it)
TFS 0.2

Thanks for your help~

 

[ExibeR]

Hello I have a big problem at my server, I'm using TFS 0.3.1 PL2, the problem is that after about 8-9 hours of uptime with about 200~300 players i see the following error on the console.
"Lost connection to Mysql during query"
So my question is why is this happening,

This is my config.lua:
sqlKeepAlive = 60
mysqlReadTimeout = 10

If i change that to 0 would that help me out to fix this?

Also i have another question, what distro is better?
TFS 0.3.1 PL2
TFS 0.3.2
TFS 0.3.3 (i doubt it)
TFS 0.2

Thanks for your help~

Have you tried optimizing the most used tables when starting the server?

 

[Necrox Guy]

Yeah, but that doesn't work

 

[Necrox Guy]

bump~ Help Please?

 

[gnr]

About your quest, what distro is better, if you use 8.41, use 0.3.3, if you use 8.4, use 0.3.2.

 

[Necrox Guy]

Tfs 0.2 or Tfs 0.3

sorry

@double post

 

[joffily]

WTF MY server TOO :/

 

[joffily]

bum, someone have any fix for it?