Front Range 4x4 Upcoming Trail Runs - Add a New Trail Run

Results 1 to 3 of 3

Thread: 2014-08: Pending behind-the-scene forum change

  1. #1
    Join Date
    Sep 2011
    Member
    #921
    Last Online
    1 Hour Ago
    Location
    Fort Collins
    4x4
    1990 Jeep Wrangler (YJ)
    Posts
    10,057
    User Name
    Jim
    Real Name
    Jim Williamson
    Thanks Given
    2,462
    Thanked 3,008 Times in 2,005 Posts

    Default 2014-08: Pending behind-the-scene forum change



    One of the forum's files (I believe) needs to be changed. I anticipate making subtle changes to the file early next week and it may take me several days to complete the work (making a subtle change per day). Should the forum become inoperative, I should know it as I'd anticipate the forum might die right when I make the change. If needed, my phone # is on the rescue list (it's the quickest way to notify me).


    The reason for the edit is to 1) keep the forum from "occasionally" becoming inoperative (when the session table fills to max) and 2) get the thread/post notification system working as it should.

  2. The Following 8 Members Say Thanks to Jim For This Post:

    Bob (August 23rd, 2014),Brad (February 6th, 2015),carpenle (February 6th, 2015),Chris (August 23rd, 2014),FINOCJ (August 27th, 2014),glacierpaul (August 23rd, 2014),Java (August 23rd, 2014),The StRanger (February 5th, 2015)

  3. #2
    Join Date
    Dec 2010
    Member
    #756
    Last Online
    January 17th, 2019
    Location
    Parker, CO
    4x4
    '11 Wrangler JK
    Posts
    365
    User Name
    Fatboris
    Real Name
    Eric
    Thanks Given
    18
    Thanked 28 Times in 22 Posts

    Default Re: 2014-08: Pending behind-the-scene forum change



    1. Thanks for all you do to keep this up and running!
    2. If you come up with something for people to help with "occasionally becoming inoperative" can you let me know? Thanks.

  4. #3
    Join Date
    Sep 2011
    Member
    #921
    Last Online
    1 Hour Ago
    Location
    Fort Collins
    4x4
    1990 Jeep Wrangler (YJ)
    Posts
    10,057
    User Name
    Jim
    Real Name
    Jim Williamson
    Thanks Given
    2,462
    Thanked 3,008 Times in 2,005 Posts

    Default Re: 2014-08: Pending behind-the-scene forum change



    Several weeks prior I made a change to the forum header/footer code. The purpose was two-fold: One the v_session table was not auto-purging and two "notifications" to subscriptions were not being sent out. Since the change I have been documenting the v_session table size to monitor if the issue is fixed. The past few entries showed the table growing towards its max size (not what I wanted to see) - until I checked today. It shrunk / was reset and not by me - good news!

    Date..... Name..... Rows. Avg. DataLength MaxLength.. Index
    1/10/2015 v_session 16345 1435 25,147,520 123,145,960 2,069,068 ...0 12/28/2014 2:11
    1/15/2015 v_session 23035 1435 33,530,368 123,145,960 2,992,468 ...0 12/28/2014 2:11
    1/24/2015 v_session 33161 1435 50,296,064 123,145,960 4,177,004 ...0 12/28/2014 2:11
    1/28/2015 v_session 36862 1435 54,487,488 123,145,960 4,873,240 1435 12/28/2014 2:11
    2/05/2015 v_session .2360 1435 .4,190,400 123,145,960 ..591,248 ...0 02/04/2015 0:47


    Of significance - when v_session hits its max size the forum dies. We're presented with a database error and that's it. To get the forum on its feet I submit (if I'm not able to log into the admin console to fix it myself) a support ticket to the host. They're quick with tickets (I'm the slow piece of the puzzle) but I want to enure the forum is up 99.9999%

    In the summertime, with higher activity, the table fills rather quickly (several days).

    I'll keep monitoring the file

  5. The Following 5 Members Say Thanks to Jim For This Post:

    Chris (February 5th, 2015),Fatboris (February 5th, 2015),FINOCJ (February 5th, 2015),Jackie (February 6th, 2015),Myrtle Turtle (February 6th, 2015)

Similar Threads

  1. Member UserID Name Changes
    By Jim in forum Forum News and Help
    Replies: 1
    Last Post: August 2nd, 2022, 07:53 PM
  2. Name Change
    By Chris in forum General Topics
    Replies: 2
    Last Post: August 26th, 2012, 07:17 AM
  3. New to Colorado and 4x4 scene
    By Newb Tourist in forum Introductions
    Replies: 15
    Last Post: August 20th, 2011, 05:17 AM
  4. name change
    By Geno in forum General Topics
    Replies: 2
    Last Post: March 20th, 2011, 10:11 PM
  5. Name change
    By Hypoid in forum General Topics
    Replies: 2
    Last Post: September 7th, 2010, 05:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
BACK TO TOP