FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » Big problem with performance
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Big problem with performance [message #158126] Mon, 02 February 2009 15:02 Go to next message
remek is currently offline  remek   Poland
Messages: 34
Registered: August 2005
Location: Poland
Karma: 0
Member
add to buddy list
ignore all messages by this user
Hi,
I have been running my forum for 3 years. No problem so far, no changes in engine. Suddenly my problems started last month - fudforum can not serve users or serve them very very slow with big problems:
- responses are very, very slow - 10-30 sec. (some time it works great and responses are very very fast)
- many sql answers -> sql server is shutting down etc.
- 503 server overloaded
- last weekend I had to run Forum Consistency feature twice - no topics in forum

I asked my host provider if everything was OK with database. They made diagnosis and provide me info that sql/php scripts overload database.

Currently I have ~2500 users, 120 000 messages and 5100 topics. The biggest one forum has 55 000 messages and 2300 topics.

Could you give me some tips how to improve fud forum.

Forum Version: 2.7.2
Database Version: 5.0.66a-log
PHP Version: 5.2.6
Web Server: IdeaWebServer/v0.50

Best regards
Remek

[Updated on: Mon, 02 February 2009 15:07]

Report message to a moderator

Re: Big problem with performance [message #158127 is a reply to message #158126] Mon, 02 February 2009 15:26 Go to previous messageGo to next message
remek is currently offline  remek   Poland
Messages: 34
Registered: August 2005
Location: Poland
Karma: 0
Member
add to buddy list
ignore all messages by this user
For instance last 10 minutes and .... ~20 errors

1053: Server shutdown in progress
Query: SELECT SUM(length) FROM fud_pmsg WHERE duser_id=663
_GET: array ( 't' => 'ppost', 'toi' => '767', )

Re: Big problem with performance [message #158128 is a reply to message #158127] Mon, 02 February 2009 15:40 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3632
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
This is obviously not a FUDforum problem, Some suggestions:

1. See who is accessing the site (access_log), and block them ("Deny from" in .htaccess).

2. Tune the DB. This script may help: http://wiki.mysqltuner.com/MySQLTuner

3. Get a bigger dedicated server to host your forum.

Best of luck!

Frank
Re: Big problem with performance [message #158328 is a reply to message #158126] Wed, 18 February 2009 03:40 Go to previous messageGo to next message
Ciska is currently offline  Ciska   Netherlands
Messages: 3
Registered: February 2009
Location: The Netherlands
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I generally am able to solve this performance problem by sending out a mass-email.
I am not sure that it has nothing to do with the communication between my fud and server though. As half of my site is running out of the DB and I do not have trouble there. But up till now I have not been able to find a clear reason for this to happen and not a proper solution too


Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook
Re: Big problem with performance [message #158330 is a reply to message #158328] Wed, 18 February 2009 04:12 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3632
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
You can always enable MySQL's slow query log to identify what's hammering your DB.
Re: Big problem with performance [message #161305 is a reply to message #158330] Sun, 06 December 2009 02:15 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3632
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Also see Performance tuning in the manual.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: How to make a mulitlingual forum?
Next Topic: Im losing the drop box
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 18 00:22:33 EST 2017

Total time taken to generate the page: 0.00746 seconds