MLF overloading our server... (Bugs)

by BrianC, Monday, December 07, 2009, 06:16 (5226 days ago)

Dear Alex,

We've been using MLF for a few years (and continue to think it excellent). We have several forums on our site with the main one now running to 37680 Postings in 6562 Threads with 493 registered members.

The problem I am about to outline is different to the one you provided a fix for when doing a search of the user posts described at: http://mylittleforum.net/bugtracker/view.php?id=2 . I had implemented that bug fix at the time and that cured that problem.

In the last week or so our server has started to overload with the cpus overloading at 87% yesterday. Normally they've been running at around 30-40% capacity.

I'm still trying to trace the problem definitively but from information supplied by our service providers a lot of other forums from Dupral, PHPBoard, etc have experienced similar problems with the search facility not of user posts but when people do a general search of the database. The problem starts to appear for large databases. It seems, from discussions I've read concerning some of these other forums, that the solution might be to limit any search to say 90 day periods rather than have the search try and navigate the entire database. For example see this discussion in relation to the another type of forum HERE. Our database now stretches back to June 2006.

Our web service provider has given a handy page in their knowledge database (See: http://help.webcity.com.au/categories/WEB-HOSTING/Managing-High-load-%7B47%7D-High-CPU-usage-acco... ) where people can find fixes for Dupral, PHPBoard and other software but there is nothing there for My Little Forum.

Has anyone else got to the stage of encountering this problem or come up with a fix yet? At present I've disabled the search facility on our forum while I hunt around for a solution. Our forum which is affected by this problem can be found HERE.


Complete thread:

 RSS Feed of thread