The Arcive of Official vBulletin Modifications Site.

youjoomla · #1 02-06-2009, 02:51 PM

Hello , I have tested on live server for few months and where never able to go live with transfering 30000 users since my DB is crashing and every attempt to repair or optimize the tables in question( all sessions tables) results in

The storage engine for the table doesn't support optimization or
The storage engine for the table doesn't support repair ,
php 5.2.8
Mysql 5.0.67

yesterday I downloaded the latest Vb version installed on local server wamp , brand new install no posts , and same issue

php 5.2.8
Mysql 5.0.51b

could you please advise ,

thnx

Lynne · #2 02-06-2009, 04:46 PM

session tables are heap/memory tables and thus you cannot repair/optimize them.

youjoomla · #3 02-06-2009, 04:51 PM

so if the host has a limit on Mysql DB overage there is nothing I could do the site will kepp crashing untill I change host correct ?

thank you for the imfo

Lynne · #4 02-06-2009, 04:57 PM

You are reaching your size limit for you mysql database and that is causing your site to go down? Why don't you ask your host about increasing the size of the database limit?

youjoomla · #5 02-06-2009, 05:01 PM

the limit is on table overage only and they do not increase it , I must go dedicated

Lynne · #6 02-06-2009, 05:11 PM

What do you have your session timeout set to (vboptions > cookies > session timeout)?

youjoomla · #7 02-06-2009, 05:41 PM

900

Lynne · #8 02-06-2009, 05:52 PM

You may want to lower that limit.

Are you sure the cron jobs are running and are emptying the session tables?

youjoomla · #9 02-06-2009, 06:01 PM

I think that corns are disabled , where do I go again to enable them , did this 6 months ago, what should I lower the limit to ?

--------------- Added [DATE]1233950573[/DATE] at [TIME]1233950573[/TIME] ---------------

fund them , all these are enabled

05 * * * * Hourly Cleanup
This script performs various cleanup tasks once per hour.
Today
08:05 PM

05 * * * * vBSEO Update Service
Update services with new threads.
Today
08:05 PM

10 * * * * Attachment Views
This script updates attachment views once an hour if the delayed attachment views option is enabled. This is suggested for forums with a large number of attachments or users.
Today
08:10 PM

15 * * * * Restore Temporarily Banned Users
This script restores the access of temporarily banned users once an hour.
Today
08:15 PM

20, 50 * * * * Infractions Cleanup
Removes expired infractions twice an hour.
Today
08:20 PM

20 * * * * Hourly Cleanup #2
This script performs various cleanup tasks once per hour.
Today
08:20 PM

25 * * * * User Promotions
This script performs usergroup promotions once per hour.
Today
08:25 PM

56 * * * * Thread Views
This script updates thread views once per hour. This option is suggested for forums with large numbers of threads or users.
Today
08:56 PM

00 0 * * * Daily Statistics Log
This script updates forum stats once per day. These are the stats that are accessed from the Admin Control Panel (New Users, New Threads, New Posts, Active Users).
02-07-2009
07:00 AM

02 0 * * * Daily Digest
This script sends out new post and new thread digests once per day.
02-07-2009
07:02 AM

10 0 * * * Daily Cleanup

puertoblack2003 · #10 02-06-2009, 06:15 PM

Quote:

Originally Posted by Lynne

What do you have your session timeout set to (vboptions > cookies > session timeout)?

what's your best setting to allow lynne?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04362 seconds Memory Usage 2,250KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (10)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!