Author Topic: Forum connection problems  (Read 5491 times)

Offline Pecan

  • Plugin developer
  • Lives here!
  • ****
  • Posts: 2257
Forum connection problems
« on: April 30, 2009, 02:39:49 pm »
I'm getting

Quote
Connection 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?

Offline ollydbg

  • Developer
  • Lives here!
  • *****
  • Posts: 5238
  • OpenCV and Robotics
    • Chinese OpenCV forum moderator
Re: Forum connection problems
« Reply #1 on: April 30, 2009, 02:44:13 pm »
I always meet this problem. Nearly every week. See my original post.
http://forums.codeblocks.org/index.php/topic,10148.0.html
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.

Offline MortenMacFly

  • Administrator
  • Lives here!
  • *****
  • Posts: 9597
Re: Forum connection problems
« Reply #2 on: April 30, 2009, 03:40:07 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: http://www.codeblocks.org/docs/main_codeblocks_en.html
C::B FAQ: http://wiki.codeblocks.org/index.php?title=FAQ

Offline thomas

  • Administrator
  • Lives here!
  • *****
  • Posts: 3979
Re: Forum connection problems
« Reply #3 on: May 12, 2009, 01:34:01 pm »
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."

Offline ollydbg

  • Developer
  • Lives here!
  • *****
  • Posts: 5238
  • OpenCV and Robotics
    • Chinese OpenCV forum moderator
Re: Forum connection problems
« Reply #4 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.  :(
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.

Offline thomas

  • Administrator
  • Lives here!
  • *****
  • Posts: 3979
Re: Forum connection problems
« Reply #5 on: May 13, 2009, 01:16:00 am »
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."