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 :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
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 04:37 Go 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
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
Re: Enhancement request: Reduce consistency check lock time [message #24515 is a reply to message #24511] Sat, 30 April 2005 11: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
add to buddy list
ignore all messages by this user
No, because it needs a constant data state.

FUDforum Core Developer
Re: Enhancement request: Reduce consistency check lock time [message #24517 is a reply to message #24515] Sat, 30 April 2005 14:12 Go to previous messageGo to next message
Anonymous   South Africa
Karma:
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
Re: Enhancement request: Reduce consistency check lock time [message #24518 is a reply to message #24517] Sat, 30 April 2005 14: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
add to buddy list
ignore all messages by this user
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
Re: Enhancement request: Reduce consistency check lock time [message #24539 is a reply to message #24518] Mon, 02 May 2005 10:08 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
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
Re: Enhancement request: Reduce consistency check lock time [message #24544 is a reply to message #24539] Mon, 02 May 2005 11: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
add to buddy list
ignore all messages by this user
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
Re: Enhancement request: Reduce consistency check lock time [message #24567 is a reply to message #24544] Wed, 04 May 2005 01:37 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
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
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: New question for FAQ System
Next Topic: Preview message focus
Goto Forum:
  

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

Current Time: Mon Dec 18 11:48:23 EST 2017

Total time taken to generate the page: 0.00667 seconds