vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Which cronjob empties the session mysql table? (https://vborg.vbsupport.ru/showthread.php?t=327659)

postcd 11-17-2019 04:31 PM

Which cronjob empties the session mysql table?
 
Because it happens to me in vbulletin 4.2.5 that the session table is full and vbulletin reports mysql error via e-mail. So please which cron task does it and how to run that task manually and see exact output of it to verify it really empty the table?

footer template contains {vb:raw cronimage}

Seven Skins 11-17-2019 05:19 PM

I think they are hourly cleanup and hourly cleanup2

postcd 11-23-2019 12:18 PM

those seems enabled.
session table was full again, but i think only temporarily and then vbulletin solved it possibly, 8107 lines in table.
Should i run any cronjob more frequently? how frequently and which? Or how to create new job that will empty just session table? Or how to increase its size?

Seven Skins 11-23-2019 06:03 PM

cronjob will run when someone visits your site, no visits = no cronjob.
You may be able to add these cronjob to server/cpanel etc..

Dave 11-23-2019 07:37 PM

If you get that error when the session table contains 8107 lines as you said then your host has extreme low limitations applied to your MySQL server. Generally this issue only happens when you have a significant number of visitors on your site (or HTTP flood/DDoS/DoS)

postcd 12-05-2019 07:33 AM

Thank you Dave, i contacted my provider and he told me "I've increased our MEMORY table limit (it was at default, nothing to do with us restricting)."
Also my session timeout (AdminCP > Settings > Options > "Cookies and HTTP header options") was set to 36 hours.. now i decreased it to 1800 seconds as suggested + emptied the session mysql table. Let's see what will happen.. If it will not work, i will be interested on how to run the table emptying sql query "truncate table session;" via cron..


All times are GMT. The time now is 05:38 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01033 seconds
  • Memory Usage 1,713KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete