vb.org Archive - vbcron - repair/optimize script ?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - vbcron - repair/optimize script ? (https://vborg.vbsupport.ru/showthread.php?t=66136)

slothy

06-13-2004 07:00 PM

vbcron - repair/optimize script ?

Hi, new guy here, i have a problem, until our host figures out wtf is going on our server drops everday or so (have 2 other forums on the same server no probs though). I wanted to just set up a repair/optimize vbcron job, but i dont know the command line (if there even is) to set up in the scheduler in vb 3.01. I not around all the time and kind of getting tired of peeps calling me telling me the board is down..

So in short, im just looking for a script or hack or something to be able to have it run every hour or something and repair/optimize tables .. (small forum, so im not worried about server load)

Zachery

06-13-2004 10:25 PM

Quote:

Originally Posted by slothy

Hi, new guy here, i have a problem, until our host figures out wtf is going on our server drops everday or so (have 2 other forums on the same server no probs though). I wanted to just set up a repair/optimize vbcron job, but i don?t know the command line (if there even is) to set up in the scheduler in vb 3.01. I not around all the time and kind of getting tired of peeps calling me telling me the board is down..

So in short, im just looking for a script or hack or something to be able to have it run every hour or something and repair/optimize tables .. (small forum, so im not worried about server load)

Well, the forums crash on a daily basis? what hacks have you put on the forum? what version of vBulletin are you running 2.x 3.0.x ? beta 3?

slothy

06-14-2004 12:05 AM

vb 3.01 just arcade is the only hack (but it was doing it before then) , this was doing it with phpboard and invisionboard too. But the 3 other boards have no probs with crashing and they are on the same server, using the same mysql and php version.. So i fiqured the quick solution would be stetting up a vbcron job ever hour or so, so if im not around its sorta fixes it self (repair fixes the prob everytime)

Zachery

06-14-2004 12:06 AM

What version of mysql are you running right now?

slothy

06-14-2004 01:35 PM

my versions

mysql 4.0.12

php 4.3.4

Zachery

06-14-2004 04:13 PM

Quote:

Originally Posted by slothy

my versions

mysql 4.0.12

php 4.3.4

upgrade mysql to 4.0.16 or 4.0.20 and you wont have a problem anymore, older verisons (before .16 i think) had table crashing problems, it has since been resolved.

slothy

06-16-2004 02:38 PM

if thats the case, then why dont the other boards (same server/php/mysql version) crash ? thats why im like durrh wtf is going on ehhhe..

All times are GMT. The time now is 10:27 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01039 seconds Memory Usage 1,723KB 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)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: