vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 5.x Products & Extensions (https://vborg.vbsupport.ru/forumdisplay.php?f=258)
-   -   Administrative and Maintenance Tools - Clean the cache automatically with schedule task (https://vborg.vbsupport.ru/showthread.php?t=327824)

mc0676 02-12-2020 10:00 PM

Clean the cache automatically with schedule task
 
1 Attachment(s)
TEXTED in VB5.5.6

This simply mod "truncate" there two table:
- cache
- cacheevent

How u know vb5 cache everything and after some hous the dabatase is huge.

So with this tool and a scheduled task u can decide to truncate those table when you want.

INSTALL

1) download the zip and unzip;

2) open cleancache.php with Notepad or a txt editor;

3) fill the first 6 lines (connection information and tables name) and save the file;
$localhost = 'xx.xx.xx.xx';
$user = 'xxxxxx';
$password = 'xxxxxx';
$database = 'xxxxxx';
$cache_table = xxxx; // cache table name, example vb_cache
$cacheevent_table = xxxx; // cacheevent table nama, example vb_cacheevent

4) upload the file in this folder:
/core/includes/cron

5) go in admin panel and open the Scheduled Task Manager

6) scroll ad the and choose Add New Scheduled Task

7) fill like in attachment: in this example the cache will be "cleaned" every hour at 45 minutes (14:45, 15:45, 16:45, etc etc), but u can choose to clear one a day or other;

8) save the scheduled task.

delicjous 02-13-2020 01:32 PM

Sorry, but I would not recomment to fill db-data to that files. There is another possibility here: https://vbulletin.org/forum/showthread.php?t=327063 which use vb-standard-classes.

In Omnibus 02-13-2020 02:13 PM

As Joe pointed out in his mod most sites do not need to clear the cache automatically and there are reasons for not doing so. Clearing the cache via cron job can cause sites to lose data.


All times are GMT. The time now is 01:04 AM.

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.01814 seconds
  • Memory Usage 1,712KB
  • 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
  • (3)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