SQL Database - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: SQL Database (/showthread.php?tid=401828)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: SQL Database (/showthread.php?tid=401828)
SQL Database - Roel - 24.12.2012
Hello,
My server is running on an SQL database, this always worked out great for me, untill now,
randomly my server losts his connection with the database and people are not able to login.
When I take a look at the mysql_log or server_log but there is nothing in it,
Anyway when I restart the server everything works fine again,
I never had this problem before, also the database is hosted localy, so if the database is down the whole server should be down...
Can it be that the database get's slow because there are to many users in it?
Atm there are 42000 users registered, but I don't this this can cause the problem?
Re: SQL Database - mineralo - 24.12.2012
try to set autoconnect to database
use if mysql_ping is -1 then connect again to database, its should help you
Re: SQL Database - iggy1 - 24.12.2012
Can you show your server/error log when you loose connection? You should get some idea of what's causing it to loose connection from the logs. IE, what happens before the connection drops.
It's nothing to do with how many records you have in the database, MySQL can handle far more than 42k records.
Re: SQL Database - Roel - 25.12.2012
Yea thats what I thought, thanks youall, it seems that my server got attacked by some idiot bot.
It made 26000 connections in 3 seconds, I think this is the cause of the closed connection...
Re: SQL Database - nGen.SoNNy - 25.12.2012
You're using mysql not sql... and try to make the database where you have the server hosted:P
nGen.SoNNy - Roel - 25.12.2012
Quote:
|
Originally Posted by nGen.SoNNy
 You're using mysql not sql... and try to make the database where you have the server hosted:P
|
Quote:
|
Originally Posted by Roel
also the database is hosted localy, so if the database is down the whole server should be down...
|
And I think everyone know that this is MySQL...
So next time just don't reply.
Re: SQL Database - linuxthefish - 25.12.2012
It depends if you have actually started MySQL? If you are using some server host, contact support.
Re: SQL Database - BlackBank - 25.12.2012
Quote:
|
Originally Posted by Roel
Yea thats what I thought, thanks youall, it seems that my server got attacked by some idiot bot.
It made 26000 connections in 3 seconds, I think this is the cause of the closed connection... |
