SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help

Reply
 
Thread Tools Display Modes
Old 24/12/2012, 08:04 AM   #1
Roel
Gangsta
 
Join Date: Mar 2012
Location: Netherlands, Limburg
Posts: 727
Reputation: 229
Default SQL Database

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?
Roel is offline   Reply With Quote
Old 24/12/2012, 08:08 AM   #2
mineralo
Gangsta
 
mineralo's Avatar
 
Join Date: Oct 2011
Posts: 552
Reputation: 9
Default Re: SQL Database

try to set autoconnect to database
use if mysql_ping is -1 then connect again to database, its should help you
mineralo is offline   Reply With Quote
Old 24/12/2012, 08:13 AM   #3
iggy1
High-roller
 
iggy1's Avatar
 
Join Date: Mar 2009
Location: One past the end.
Posts: 2,421
Reputation: 273
Default Re: SQL Database

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.
iggy1 is offline   Reply With Quote
Old 25/12/2012, 09:04 AM   #4
Roel
Gangsta
 
Join Date: Mar 2012
Location: Netherlands, Limburg
Posts: 727
Reputation: 229
Default Re: SQL Database

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...
Roel is offline   Reply With Quote
Old 25/12/2012, 09:08 AM   #5
nGen.SoNNy
Gangsta
 
nGen.SoNNy's Avatar
 
Join Date: Sep 2009
Location: Romania
Posts: 929
Reputation: 69
Default Re: SQL Database

You're using mysql not sql... and try to make the database where you have the server hosted:P
__________________
If i've helped you, please click
nGen.SoNNy is offline   Reply With Quote
Old 25/12/2012, 09:26 AM   #6
Roel
Gangsta
 
Join Date: Mar 2012
Location: Netherlands, Limburg
Posts: 727
Reputation: 229
Default

Quote:
Originally Posted by nGen.SoNNy View Post
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...

Basicly that means the database is hosted at the server host...
And I think everyone know that this is MySQL...
So next time just don't reply.
Roel is offline   Reply With Quote
Old 25/12/2012, 09:37 AM   #7
linuxthefish
High-roller
 
linuxthefish's Avatar
 
Join Date: Dec 2010
Location: Al-Dunya
Posts: 2,857
Reputation: 690
Default Re: SQL Database

It depends if you have actually started MySQL? If you are using some server host, contact support.
__________________

linuxthefish is offline   Reply With Quote
Old 25/12/2012, 09:55 AM   #8
BlackBank
Gangsta
 
Join Date: Dec 2010
Location: The Netherlands
Posts: 522
Reputation: 437
Default Re: SQL Database

Quote:
Originally Posted by Roel View Post
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...
Ask to your hoster if they can put on Port Scanning, this can hold this stupid attacks for a while.
BlackBank is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Height Server Support 4 13/11/2012 02:09 PM
Database Sanady Everything and Nothing 15 01/09/2012 12:03 AM
Database help. Cyniic Scripting Help 3 10/05/2012 05:01 PM
Database ID Incognation Help Archive 7 03/05/2011 01:54 PM
DataBase Sascha Help Archive 0 29/04/2010 05:02 PM


All times are GMT. The time now is 07:49 AM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.