Questions about the Forum (Skuzzy) ??

[Heater]

I have noticed that a lot of times mostly between 08:00 and 10:00 CET, that the Forum is unresponsive i.e. you can log-on etc and the main forum works but if you click on a topic.. it appears to time out...
or is very slow...

so the question is during this time are updates, cleanup scripts or indexing running in the background?

[ImADot]

I'm curious too. 

But, I've also read that if someone is using the forum search, it pulls resources away from everyone else while it chugs through looking for search results.  This is probably one of the main reasons for so many double and triple posts as people think the forum is stuck and their "submit" click didn't register.  And is why shopping cart sites say to click "submit payment" only once no matter what - or you could end up buying the same thing multiple times.

[Skuzzy]

No, it has to do with too many large searches running simulataneously causing resource issues with MySQL.  Unfortunately, there is no throttle on this type of thing with SMF.  When I find it happening, I manually kill the search(s) causing it.

[Heater]

Skuzzy...
Take a look at Postqresql... it's opensource, you can set up throttles etc...

Cheers

[VonMessa]

Skuzzy...
Take a look at Postqresql... it's opensource, you can set up throttles etc...

Cheers

Thought MySQL was open source, also?   

[Skuzzy]

MySQL is not the issue. SMF allows unlimited number of searches to be done.  When you have 3.5million posts and then fifty to one hundred searches hit at one time, resources have a tendency to starve.  Right now, MySQL is the throttle.  I can reduce the resource usage of MySQL, but all that will do is bring on the same symptoms, more often, for shorter periods of time.  I cannot up the resources of MySQL without detrimental effects on everything else on the server.

SMF has a poor search code implementation.

I have an idea I want to try, but it will require taking the board down for a few days to implement it.

[Jayhawk]

MySQL is not the issue. SMF allows unlimited number of searches to be done.  When you have 3.5million posts and then fifty to one hundred searches hit at one time, resources have a tendency to starve.  Right now, MySQL is the throttle.  I can reduce the resource usage of MySQL, but all that will do is bring on the same symptoms, more often, for shorter periods of time.  I cannot up the resources of MySQL without detrimental effects on everything else on the server.

SMF has a poor search code implementation.

I have an idea I want to try, but it will require taking the board down for a few days to implement it.

[guncrasher]

can it be done the first week in october?  I going on vacation then to a place with no dsl connection.  the Texas state fair.  .


semp