Advertisement:

Author Topic: IMPORTANT: Large sessions table on Debian/Ubuntu Linux hosted forum?  (Read 219761 times)

Offline Chriss Cohn

  • Full Member
  • ***
  • Posts: 495
  • Gender: Male
  • who does not go with the time, goes with the time
Re: IMPORTANT: Large sessions table on Debian/Ubuntu Linux hosted forum?
« Reply #20 on: February 06, 2008, 03:00:17 PM »
Can't we make a quick mod of it (until it get implemented in 1.1.5 - if they planning to do so)?

Regards, Christian

Offline Daniel15

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 4,221
  • Gender: Male
  • http://dan.cx/
    • daaniel on Facebook
    • Daniel15 on GitHub
    • daniel15 on LinkedIn
    • @Daniel15 on Twitter
    • Daniel15
Re: IMPORTANT: Large sessions table on Debian/Ubuntu Linux hosted forum?
« Reply #21 on: February 07, 2008, 03:33:12 AM »
I don't think it's worth packaging a mod for this fix, seeing as it's a really small one...
Daniel15, former Customisation team member, resigned due to lack of time. I still love everyone here :D.
Go to smfshop.com for SMFshop support, do NOT email or PM me!

Offline Panzer-

  • Full Member
  • ***
  • Posts: 481
  • Gender: Male
  • www.lastkarrde.com
    • Lastkarrde.com
Re: IMPORTANT: Large sessions table on Debian/Ubuntu Linux hosted forum?
« Reply #22 on: April 02, 2008, 12:09:49 AM »
Is this fixed in 2.0? Or is it still an issue?

Offline metallica48423

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,842
  • Gender: Male
  • Professional Multislacker!
    • Zentendo
Re: IMPORTANT: Large sessions table on Debian/Ubuntu Linux hosted forum?
« Reply #23 on: April 11, 2008, 08:00:13 PM »
this is the code from 2.0:

Code: [Select]

                // Use database sessions? (they don't work in 4.1.x!)
                if (!empty($modSettings['databaseSession_enable']) && @version_compare(PHP_VERSION, '4.2.0') != -1)
                {
                        session_set_save_handler('sessionOpen', 'sessionClose', 'sessionRead', 'sessionWrite', 'sessionDestroy', 'sessionGC');
                        @ini_set('session.gc_probability', '1');
                }
                elseif (@ini_get('session.gc_maxlifetime') <= 1440 && !empty($modSettings['databaseSession_lifetime']))
                        @ini_set('session.gc_maxlifetime', max($modSettings['databaseSession_lifetime'], 60));

From what i can see its been solved for a long time
Justin O'Leary
Ex-Project Manager
Ex-Lead Support Specialist

Quote
Microsoft wants us to "Imagine life without walls"...
I say, "If there are no walls, who needs Windows?"

Useful Links:
Online Manual!
How to Help us Help you   
Search
Settings Repair Tool
     

Offline Ibiza MF

  • Semi-Newbie
  • *
  • Posts: 82
Re: IMPORTANT: Large sessions table on Debian/Ubuntu Linux hosted forum?
« Reply #24 on: May 20, 2008, 02:49:01 PM »
That code is in 1.1.5 also and my table is 1.5 MB with about 10 000 members, 200 online... so this shouldn't be sticky...

Offline Brettflan

  • Full Member
  • ***
  • Posts: 496
  • Gender: Male
    • TaleWorlds Forum
Re: IMPORTANT: Large sessions table on Debian/Ubuntu Linux hosted forum?
« Reply #25 on: May 24, 2008, 02:06:48 AM »
Indeed, after upgrading to 2.0b3.1 I've tested it for a couple of weeks without the modification above, and have observed that the sessions table now stays at a reasonable size.
I also occasionally check the running queries for MySQL and have spotted the query running which cleans out old stuff from the sessions table.

Offline Nao 尚

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 5,928
  • Gender: Male
    • wedgebook on Facebook
    • Wedge
Re: IMPORTANT: Large sessions table on Debian/Ubuntu Linux hosted forum?
« Reply #26 on: May 24, 2008, 04:37:06 AM »
Speaking about this kind of thing...

I've noticed that my smf_log_digest table is growing large. It's not TOO large, but it's supposed to be purged at least on a weekly basis, and I've noticed that my table is filled with message notifications dating from last november! All my 2706 entries have a "daily" value of zero. At line 605 of ScheduledTasks (SMF 2.0):

Code: [Select]
WHERE ' . ($is_weekly ? 'ld.daily != {int:daily_value}' : 'ld.daily IN (0, 2)'),
"daily_value" is set to 2. So, if $is_weekly is set, all my entries will be used. If it is not set... They will still all be used!

I'm not sure this is the intended behavior... I need to point out that my Scheduled Tasks options for "weekly digest" and "daily digest" are both enabled. I don't know what else is wrong.
I will not make any deals with you. I've resigned. I will not be pushed, filed, stamped, indexed, briefed, debriefed or numbered.

Aeva Media rocks your life.

Offline John Knight

  • Newbie
  • *
  • Posts: 9
Re: IMPORTANT: Large sessions table on Debian/Ubuntu Linux hosted forum?
« Reply #27 on: July 17, 2008, 04:05:42 AM »
Hi, SMF newbie here. 

I am not a techie so please bear with me.   ;)

Would like to know if the problems we're experiencing with our host regarding increase in server memory utilization is related to this?  Just installed SMF about a week ago only. 

I have no idea how to work out the solution, but will give it a try by applying the code change as tipped in this topic. 

here is a screen of the report we got from the host.  Don't know if this is enough info to tie in our problems to the recommended fix for large sessions table.



I also noticed having problems when uploading files via FTP.  The FTP app tells me it couldn't transfer files since there are "too many connections (8) from this IP".  That happens when I am logged on SMF.  When I log-out and closed the browser for the SMF, the FTP file transfer proceeded without problems.

An immediate reply would be appreciate as our account has been suspended already.  :(  We're on shared hosting, btw.

Thanks!




Offline Nao 尚

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 5,928
  • Gender: Male
    • wedgebook on Facebook
    • Wedge
Re: IMPORTANT: Large sessions table on Debian/Ubuntu Linux hosted forum?
« Reply #28 on: July 17, 2008, 04:50:28 AM »
I don't think it's related...
Your best bet to check for a possible relation would be to launch phpMyAdmin and check whether smf_sessions is huge or not.
Usually problems happen after several months or years, not after a week...
I will not make any deals with you. I've resigned. I will not be pushed, filed, stamped, indexed, briefed, debriefed or numbered.

Aeva Media rocks your life.

Offline John Knight

  • Newbie
  • *
  • Posts: 9
Re: IMPORTANT: Large sessions table on Debian/Ubuntu Linux hosted forum?
« Reply #29 on: July 17, 2008, 05:00:04 AM »
I don't think it's related...
Your best bet to check for a possible relation would be to launch phpMyAdmin and check whether smf_sessions is huge or not.
Usually problems happen after several months or years, not after a week...

Thanks, Nao!

Offline Owdy

  • SMF Fossil
  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 15,590
  • Gender: Male
  • W00t!
    • janoloferiksson on LinkedIn
    • @@jaoler on Twitter
Re: IMPORTANT: Large sessions table on Debian/Ubuntu Linux hosted forum?
« Reply #30 on: December 05, 2009, 02:32:42 PM »
Is this still issue? Unsticky?
Former Lead Support Specialist

Tarvitsetko apua SMF foorumisi kanssa? Otan työtehtäviä vastaan, lue:http://www.simplemachines.org/community/index.php?topic=375918.0

Offline Something like that

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 2,496
  • Gender: Male
  • ]
Re: IMPORTANT: Large sessions table on Debian/Ubuntu Linux hosted forum?
« Reply #31 on: December 05, 2009, 05:38:03 PM »
Is this still issue? Unsticky?

It's still an issue, especially with SMF 1.1.

Offline Owdy

  • SMF Fossil
  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 15,590
  • Gender: Male
  • W00t!
    • janoloferiksson on LinkedIn
    • @@jaoler on Twitter
Re: IMPORTANT: Large sessions table on Debian/Ubuntu Linux hosted forum?
« Reply #32 on: December 05, 2009, 05:42:45 PM »
2.0?
Former Lead Support Specialist

Tarvitsetko apua SMF foorumisi kanssa? Otan työtehtäviä vastaan, lue:http://www.simplemachines.org/community/index.php?topic=375918.0

Offline glennk

  • Sr. Member
  • ****
  • Posts: 899
Re: IMPORTANT: Large sessions table on Debian/Ubuntu Linux hosted forum?
« Reply #33 on: January 19, 2010, 06:52:41 AM »
Can I ask what are the problems caused by this (Other than a large file, is there any load issues ?) and do they still exist in smf 2 ?

Offline Something like that

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 2,496
  • Gender: Male
  • ]
Re: IMPORTANT: Large sessions table on Debian/Ubuntu Linux hosted forum?
« Reply #34 on: January 19, 2010, 01:55:27 PM »
I believe this has been fixed in 2.0 (don't quote me on that though).

I don't believe it will cause any load issues immediately, but if it grows to millions of rows, it will slow down accesses slightly.

Offline Daniel15

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 4,221
  • Gender: Male
  • http://dan.cx/
    • daaniel on Facebook
    • Daniel15 on GitHub
    • daniel15 on LinkedIn
    • @Daniel15 on Twitter
    • Daniel15
Re: IMPORTANT: Large sessions table on Debian/Ubuntu Linux hosted forum?
« Reply #35 on: January 20, 2010, 03:42:26 AM »
Quote
I don't believe it will cause any load issues immediately, but if it grows to millions of rows, it will slow down accesses slightly.
And if it's using MyISAM (the default MySQL engine), the table locking will  eventually become really slow and kill your performance :P
Daniel15, former Customisation team member, resigned due to lack of time. I still love everyone here :D.
Go to smfshop.com for SMFshop support, do NOT email or PM me!

Offline glennk

  • Sr. Member
  • ****
  • Posts: 899
Re: IMPORTANT: Large sessions table on Debian/Ubuntu Linux hosted forum?
« Reply #36 on: January 20, 2010, 04:27:22 AM »
I have moved to cloud hosting, which I keep crashing almost hourly. The hosts technical help department are struggling to locate the problem. Whats the chances that this file is causing my problem ? Im on the latest version of smf 2
« Last Edit: January 20, 2010, 04:30:30 AM by glennk »

Offline 青山 素子

  • Server Team
  • SMF Super Hero
  • *
  • Posts: 17,021
  • 戦場ヶ原、蕩れ!
    • srvrguy on GitHub
    • @motokochan on Twitter
    • Nekomusume Moe
Re: IMPORTANT: Large sessions table on Debian/Ubuntu Linux hosted forum?
« Reply #37 on: January 20, 2010, 03:19:30 PM »
If their servers are using Debian, it's possible, otherwise it's not likely.
Motoko-chan
Director, Simple Machines

Just because it's pouring down doesn't mean we're gonna drown. There's a time when all you can say is let it rain - Mat Kearney (Let It Rain)

Note: Unless otherwise stated, my posts are not representative of any official position or opinion of Simple Machines.


Offline Something like that

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 2,496
  • Gender: Male
  • ]
Re: IMPORTANT: Large sessions table on Debian/Ubuntu Linux hosted forum?
« Reply #38 on: January 21, 2010, 12:21:57 PM »
I have moved to cloud hosting, which I keep crashing almost hourly. The hosts technical help department are struggling to locate the problem. Whats the chances that this file is causing my problem ? Im on the latest version of smf 2

Get a competent host?

Offline glennk

  • Sr. Member
  • ****
  • Posts: 899
Re: IMPORTANT: Large sessions table on Debian/Ubuntu Linux hosted forum?
« Reply #39 on: January 22, 2010, 10:12:53 AM »
Ok, Ive spoke to the host and apparently Im on centos so this isnt my issue I dont think. Thankyou for your help with this one.