SMF Support > Server Performance and Configuration
IMPORTANT: Large sessions table on Debian/Ubuntu Linux hosted forum?
Brettflan:
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.
Nao 尚:
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: ---WHERE ' . ($is_weekly ? 'ld.daily != {int:daily_value}' : 'ld.daily IN (0, 2)'),
--- End code ---
"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.
John Knight:
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!
Nao 尚:
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...
John Knight:
--- Quote from: Nao 尚 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...
--- End quote ---
Thanks, Nao!
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version