Cron Jobs Table........Clarification Please

OK there is a table called sys_cron_jobs which is a large list of some 16 cron jobs in a database format for each. I am confused at the purpose of that table? 1) Is it there to clarify the individual cron jobs? 2) Is there a master cron that fires that table in order? Please just help me understand the purpose of the information in that table........... You still have to for me have cron jobs setup in the cpanel to have them actually work............?? Just trying to understand that table.......................
Csampson
Quote · 23 Sep 2011

In Dolphin 7 they tried to make things more "modular" so the mod writers could make mods that wouldn't require edits to the base code. The physical file (/periodic/cron.php) fires once a minute.. and when it does it executes everything in that db table. Whenever you install a mod that requires automation it should just add itself to that table with the correct frequency. Make sense?

BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin
Quote · 23 Sep 2011

Hello!

Cron Jobs from installation has value only for launching 1 file - periodic/cron.php. And this file takes data from this table, and according info there calculates in what time interval need to launch every command.

Example, bx_videos. It has:

time='*/5'

class="BxDolCronVideo"

file="flash/modules/video/inc/classes/BxDolCronVideo.php"

So it means that every 5 minutes system will launch method "processing"  of class "BxDolCronVideo" from file

flash/modules/video/inc/classes/BxDolCronVideo.php.

This command convert new uploaded videos with Ffmpeg.

 

Regards

Quote · 23 Sep 2011

for every task that requires automation, there is an entry injected into the sys_cron table. 

 

cron job from 'cpanel' or from crontab

gives instruction to crond that based on the entered parameters the specific task shall automate with no human intervention.

 

crontab settings invoking cron.php every minute, cron.php instantiates sys_cron, specific parameters are given for each task on the database table. based on those parameters, is when they will execute. 

 

fairly simple and self-explanatory really. 

if you have 16 entries on your sys_cron, identify those cron jobs, and adjust the initialization as you see fit.

as a general rule, a cron job should never fire every minute on the minute, but guess that they were unable to fire cron.php for execution of ffmpeg.exe so they just run the cron every minute. not sure what the reasoning really is behind their suggested parameters. 

When a GIG is not enough --> Terabyte Dolphin Technical Support - Server Management and Support
Quote · 23 Sep 2011

Well if there is anything that I have learned it is quite clear how the cron jobs have affected my site.  At this very second my site is blazing fast as fast as i have ever seen it be.   Well that is because there are no cron jobs firing at this very moment and I am about to rebuild that process from scratch.

It appears that the true issue for my site speed has been in conflicting crons as the site has 16 AND the what we will call property crons had about 12 as well.  No matter how I slice it this comes down to doing the proper math problem or timing of crons to make the site as efficient as possible.  The information you shared with me put that table in a much better light for me...................

I just wonder if I could add the property crons to that table as well?  I don't see why I couldn't if you see an issue or something I am missing in that thought process.........please advise............There is no difference between a DOLPHIN cron job and a cron job in theory only having nothing to do with the obvious answer of how each cron can be so different in what it does...................Am I right in that thought and I can add my property crons to that table?

I really think this is a giant step forward to understand the science that this site is.................

 

 

Csampson
Quote · 23 Sep 2011

Notifications are not on a cron job either? Hmmm I thought they were.....

Csampson
Quote · 23 Sep 2011
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.