FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum » FUDforum Suggestions » Enhancement request: Reduce consistency check lock time
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Enhancement request: Reduce consistency check lock time [message #24511] Sat, 30 April 2005 08:37 Go to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Hi,

Quote:

Consistency check is a complex process which may take several minutes to run, while it is running your forum will be disabled.


Would it be possible to perform all consistency checks on-line and only lock the forum while making changes. This will reduce the impact consistency checking has on working users.

Best regards.

Frank

Report message to a moderator

Re: Enhancement request: Reduce consistency check lock time [message #24515 is a reply to message #24511] Sat, 30 April 2005 15:04 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
No, because it needs a constant data state.

FUDforum Core Developer

Report message to a moderator

Re: Enhancement request: Reduce consistency check lock time [message #24517 is a reply to message #24515] Sat, 30 April 2005 18:12 Go to previous messageGo to next message
Anonymous   South Africa
Hi,

Obviously, but you can do all the validations prior to locking the forum, and run only the DML statements while the forum is locked.

Also, if you at least allow read-only access during consistency checking, it will help tremendously.

Regards.

Frank

Report message to a moderator

Re: Enhancement request: Reduce consistency check lock time [message #24518 is a reply to message #24517] Sat, 30 April 2005 18:19 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Incorrect, many of the forum validations could falsely trigger and result in data removal if the operation runs while someone is posting a message or during other mid-action events.

Consistency checker is not ment a s frequently ran tool, it should not be executed more then once per day and even that it is often too frequent. Even on large installs one run per week is more then enough, given that the operation takes 5-10 minutes (BIG forum over 1/2 million messages) it by no means is a large downtime.

FUDforum Core Developer

Report message to a moderator

Re: Enhancement request: Reduce consistency check lock time [message #24539 is a reply to message #24518] Mon, 02 May 2005 14:08 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
I try to do a consistency check once per week during quite times. However, it pains me to so many user unable to use the forum for so long.

To prevent this, one should consider scaling horizontally instead of having a singe forum growing out of control.

Best regards.

Frank

Report message to a moderator

Re: Enhancement request: Reduce consistency check lock time [message #24544 is a reply to message #24539] Mon, 02 May 2005 15:18 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
What do you mean so long, 5 minutes during off hours? C'mon it not like the forum pages just stall, your users see the message you get to define yourself indicating that the forum is undergoing maintenance process.

FUDforum Core Developer

Report message to a moderator

Re: Enhancement request: Reduce consistency check lock time [message #24567 is a reply to message #24544] Wed, 04 May 2005 05:37 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Hi,

I've timed the consistency checker to about 12 minutes. That is sure going to upset a few users, even over weekends. Just hope they don't give-up too quickly.

Anyway, it was just a suggestion, if it cannot be done, then so be it.

Best regards.

Frank

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: New question for FAQ System
Next Topic: Preview message focus
Goto Forum:
  

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

Current Time: Thu Nov 28 21:09:20 GMT 2024

Total time taken to generate the page: 0.02698 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software