Problem with TFS and mysql

[destro84]

Hey, I have problem with mysql. TFS sometimes loses connection with mysql
Also I have problem with save server because it saves server in 40-50seconds and everyone got kick
how can I fix it?

 

[Djivar]

Whats your internet upload and your ram ect?

 

[destro84]

Server dedicated: 8GB ram DDR3 / 100/100Mb / Linux (Debian)

 

[Djivar]

uhm :s

 

[destro84]

yea tfs sux :S

 

[Djivar]

Nah, tfs works fine for me

 

[ligus]

Yea tfs sux. If you have 20 players online you can have uptime 1000h, but if 200+ its impossible

 

[Djivar]

Na its not impossible

 

[ligus]

I know its possible to have uptime 1000h with 800players online but I have to change something in my.cnf file, but what?

 

[Djivar]

	sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "" -- password to your database
	sqlDatabase = "" -- database name
	sqlFile = "forgottenserver.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	passwordType = "plain"

 

[Kavvson]

	sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "" -- password to your database
	sqlDatabase = "" -- database name
	sqlFile = "forgottenserver.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	passwordType = "plain"

Mine

	sqlFile = "forgottenserver.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	encryptionType = "plain"

and work fine also

 

[Djivar]

sqlType = "mysql"
	sqlHost = "localhost"
	sqlPort = 3306
	sqlUser = "root"
	sqlPass = "" -- password to your database
	sqlDatabase = "" -- database name

The database thing in config then?

 

[destro84]

Mine

	sqlFile = "forgottenserver.s3db"
	sqlKeepAlive = 0
	mysqlReadTimeout = 10
	mysqlWriteTimeout = 10
	encryptionType = "plain"

and work fine also

Yea i have it.. and sometimes TFS loses connection with mysql

 

[Djivar]

Hm, i saw another user that had the same problem :S