About Mysql

[MxSoft]

When a server looses conection to mysql, why does this happens, can someone with big acknowledge explain why does this happens, a way to fix it, or a offer of job to optimize it.

 

[Forsaken13126]

Make sure you have port 80 forwarded and make sure in the config.lua u type in the database name that u have it named as in the mysql program

 

[Panic1]

Make sure you have port 80 forwarded and make sure in the config.lua u type in the database name that u have it named as in the mysql program

Make sure you also don't forget to breathe MxSoft!

>.<

 

[Mogex]

i always had that problem, server with no reason loses contection and nobody can conect,
Some of them says that is the Operative sistem, others that it's the TFS.
That's life :/

 

[Forsaken13126]

Theres a way to fix it your just doing somthing wrong.

 

[Mogex]

Theres a way to fix it your just doing somthing wrong.

is the way you explained before?
Because that's obious.

 

[Forsaken13126]

Thts one thing to check, lol

 

[dchampag]

>Config.lua
sqlKeepAlive = 10
mysqlReadTimeout = 0
mysqlWriteTimeout = 0

Make sure that any scripts that you're using that execcute or get results from the database free themselves.

If you're using the save system that saves players individually disable it. It is a great system but requires advanced knowledge in setup. I know quite. A bit about setting up SQL schema and such and could not figure out how to get individual player saving to work correctly without losing database connection.

 

[MxSoft]

Blame god for this , ty anyways