Solved Databse Connection Issue

[dchampag]

Alright, I made a new save system for my server but now after a few hours of running less depending how many people are online the mysql server crashes and refuses connections from all applications

the save system saves players every 5 minutes after their time of login, and their house, saves houses every time they enter leave, or relog in a house

but the issue started before I even added house saving, it started when I had added saving players every 5 minutes



----------------------------------------------------------

Changed some config.lua information regarding the MySQL database, timeouts set to 0 and reconnect limit set to unlimited

 

[kermaxpl]

Maybe your user has setted "max queries per hour" or something like that?

 

[dchampag]

Ughm I am using root but I will be sure to check that


Nope just checked all is fine in that department

 

[dchampag]

bump

 

[unixstyle297]

Maybe, If you are using UniServer change it. The last version while I executed last TFS, I catched full of errors, and my database was interrupted. Try to install xampp, or other version of UniServ.
Try to change on xampp if you use uniserv, the new version of xampp is much better than all of other applications. It should be working correctly.
If I helped, don't thanks, regards ~unix.

 

[dchampag]

I am using iis to host my site but I am using xampps MySQL server because with my distro for some reason the standalone MySQL server errors I will try and fix my issue with standalone MySQL and see where I stand with that but the current issue only happens with individual player saving... I had the server save every 5 minutes to test and this didnt happen only with individual player saves....