Linux TFS 0.4 Mysql connection lost always in the mornings? around 7-8:00 CET

[Linken93]

Hello!

I've got this problem that my server is losing connection with the mysql database in the mornings. Im hosting at a VPS company. Could It be that?

 

[slaw]

Database connection lost? Most likely.

 

[Linken93]

Database connection lost? Most likely.

Nope , It worked :S

 

[slaw]

I mean that server lost connection with mysql. It always happened on my server when I had no optimized mysql database and had same symptoms as you got. What happens with peoples that are inside game? Do they got freeze or they can normally play, their characters are saved but just new players can't login?

 

[Linken93]

I mean that server lost connection with mysql. It always happened on my server when I had no optimized mysql database and had same symptoms as you got. What happens with peoples that are inside game? Do they got freeze or they can normally play, their characters are saved but just new players can't login?

I guess the server lost connection with mysql. People were able to play but couldn't login again.

 

[slaw]

I guess the server lost connection with mysql. People were able to play but couldn't login again.

Bingo!

 

[Linken93]

Bingo!

So how do I solve this then?

 

[simkal]

hosting on own computer?

 

[Linken93]

hosting on own computer?

Nope, Dedicated

 

[Kippetjee]

Nope, Dedicated

Ur hosting on cheapvps?

becouse i have the same problem there on 8~ server lost connection

 

[Linken93]

Ur hosting on cheapvps?

becouse i have the same problem there on 8~ server lost connection

Yes Im doing that ;p

 

[Kippetjee]

Im thinking its not your fould but cheapvps... Becouse i have exuactly the same problem and when i speak with them they sayd... noting

 

[Linken93]

So my server crashed again at Save and got this in console.

[22:2:04.489] mysql_commit() - MYSQL ERROR: Lost connection to MySQL server during query (2013)
[22:2:04.489] mysql_real_query(): SELECT `id`, `value`, `param`, `expires` FROM `bans` WHERE `type` = 1 AND `active` = 1 - MYSQL ERROR: MySQL server has gone away (2006)

 

[Linken93]

BUMP!

I really need to fix this with lost connection to the database! , Anything I can do??

 

[Linken93]

bump

 

[Kippetjee]

Bring this up!

 

[Linken93]

Bring this up!

You got the same problem with cheapvps? There must be something wrong with them.. This is really Annoying..

 

[Linken93]

bump

 

[Kippetjee]

Freee bump for cheapvps members

 

[Linken93]

bump