vb.org Archive
Page 2 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   Optimizing or repairng MySql tables (https://vborg.vbsupport.ru/showthread.php?t=204467)

Lynne 02-06-2009 06:39 PM
900 is the default which is 15 minutes. There are a couple of Scheduled Tasks which are supposed to be running that clear that session table based on that session timeout. So, assuming your scheduled tasks are running (which it looks like they are), I was thinking if you lower that limit, maybe your session table won't get so full. So, maybe try 600, or 10 minutes, and see if that makes a difference.

youjoomla 02-06-2009 06:56 PM
thank you much for your help , I will try that

Dismounted 02-07-2009 03:26 AM
Quote:
Originally Posted by Lynne (Post 1736266)
session tables are heap/memory tables and thus you cannot repair/optimize them.
However, you can clear them. :)

puertoblack2003 02-07-2009 04:50 AM
Quote:
Originally Posted by Dismounted (Post 1736733)
However, you can clear them. :)
by clearing them,you mean truncate the tables?

Dismounted 02-07-2009 04:55 AM
Yep, or you could restart the MySQL daemon, that would clear all the HEAP/MEMORY tables as well.

youjoomla 02-07-2009 04:36 PM
tried clearing few times end up with crashed table and dead forum

Marco van Herwaarden 02-09-2009 08:40 AM
I would not set the cookie timeout to a lower value then the default 900.


All times are GMT. The time now is 04:47 PM.
Page 2 of 2 1 2
Show 40 post(s) from this thread on one page

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.01027 seconds
  • Memory Usage 1,725KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete