News:

Accounts with zero posts and zero activity during the last months will be deleted periodically to fight SPAM!

Main Menu

Forum connection problems

Started by Pecan, April 30, 2009, 02:39:49 PM

Previous topic - Next topic

Pecan

I'm getting

QuoteConnection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

on about 1/4 of my clicks in the forum.

Anyone else having this problem?

ollydbg

If some piece of memory should be reused, turn them to variables (or const variables).
If some piece of operations should be reused, turn them to functions.
If they happened together, then turn them to classes.

MortenMacFly

Quote from: Pecan on April 30, 2009, 02:39:49 PM
Anyone else having this problem?
Me, too.

Once I informed Yiannis he did "something" at it seemed to work better - but now it's worse again.
Compiler logging: Settings->Compiler & Debugger->tab "Other"->Compiler logging="Full command line"
C::B Manual: [url="https://www.codeblocks.org/docs/main_codeblocks_en.html"]https://www.codeblocks.org/docs/main_codeblocks_en.html[/url]
C::B FAQ: [url="https://wiki.codeblocks.org/index.php?title=FAQ"]https://wiki.codeblocks.org/index.php?title=FAQ[/url]

thomas

Sometimes MySQL seems to hang and needs a restart (which is strange, but still).
However, what annoys me more is that the overall performance has gone down a lot too. Compared to "instantaneous", the time to deliver a page has been least 1-2 seconds for several months (sometimes up to 30 seconds).
My guess is that it's a thousand chinese spambots crawling the server all day long.
"We should forget about small efficiencies, say about 97% of the time: Premature quotation is the root of public humiliation."

ollydbg

You can block these IPs.
But please don't blocks all the Chinese IPs, because that will block me too.  :(
If some piece of memory should be reused, turn them to variables (or const variables).
If some piece of operations should be reused, turn them to functions.
If they happened together, then turn them to classes.

thomas

Quote from: ollydbg on May 12, 2009, 01:40:46 PM
You can block these IPs.
But please don't blocks all the Chinese IPs, because that will block me too.  :(
We had done that on the old server two years ago, and it worked wonders. On the current one, only the Madraman has access... so that'll be his to do :)
"We should forget about small efficiencies, say about 97% of the time: Premature quotation is the root of public humiliation."