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

[Jim]

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.

[Fatboris]

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.

[Jim]

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