[DEBIAN] Lost connection to MySQL database?

[Kaboo]

Hello. Everything was fine with my server (Debian Lenny, TFS 0.4 rev 3777), without crashes in three weeks.
Today at morning a friend told me that no one could login ("Invalid acccount name" error), I've checked the server console using Putty and I could also noticed that when someone logged out, it returned the error: "Cannot save player: "X"". I reopened the server and it worked again.

With some research I've found that my server lost connection to MySQL database. It happened to me a year ago and I had to deactivate MySQL strict mode, but it is already deactivated now. What else could cause the connection loss? I have two servers online, and the problem happened only with the first one.

I will be thankful for anything!
Thanks!

 

[qban]

find in config.lua

mysqlReadTimeout = 10
	mysqlWriteTimeout = 10

and change it to

	mysqlReadTimeout = 0
	mysqlWriteTimeout = 0

There will be ~30s lag

 

[mankdam]

Stop using XAMPP! Use UNIFORM and optimize you mysql config. This solves

 

[qban]

Stop using XAMPP! Use UNIFORM and optimize you mysql config. This solves

(Debian Lenny, TFS 0.4 rev 3777)
There is no UniServer or XAMPP for linux os.

Read it clearly, then answer (if you know the answer)...

 

[Collz]

Stop using XAMPP! Use UNIFORM and optimize you mysql config. This solves

I had this error before, but for windows. All I did was restart the server and mysql and it worked fine.

 

[Kaboo]

find in config.lua

mysqlReadTimeout = 10
	mysqlWriteTimeout = 10

and change it to

	mysqlReadTimeout = 0
	mysqlWriteTimeout = 0

There will be ~30s lag

Thanks for the tip! Just a question, when the 30s lag is going to happen?

Thanks.

 

[qban]

Same time that an error occurs.
Whole error looks like that:

At my server it was about 00.00h... but on some servers it happens randomly.
Same with the lag. On my server its about 30 seconds, but on your it could be 10 or more/less.