[Roel]

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?

[mineralo]

try to set autoconnect to database
use if mysql_ping is -1 then connect again to database, its should help you

[iggy1]

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.

[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...

[nGen.SoNNy]

You're using mysql not sql... and try to make the database where you have the server hosted:P

[Roel]

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...

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.

[linuxthefish]

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

[BlackBank]

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...

Ask to your hoster if they can put on Port Scanning, this can hold this stupid attacks for a while.