Mactrack: Automatic db maintenance

[torstentfk]

Hello,

I recognized that my mactrack-port table is getting very big (1 mio entries). I search for the last polling cycle and... the first was one month ago. So I started manually the db maintenance and 780000 entries were removed.
Could one look into the maintenance code and check it if it is really called at the given time?

Torsten

[TheWitness]

This issue will be addressed in SVN soon. I know that the maintenance script code I wrote has some issues.

TheWitness

[avillaverdec]

Hi,

I suppose this problem is already fixed, but I have not found anything about it in the web. I have fixed this problem changing some code in poller_mactrack.php, I replaced this code:

Code: Select all

if (empty($last_db_maint_time)) {
        if (strtotime($database_maint_time) < $current_time) {
                $next_db_maint_time = strtotime(date("Y-m-d") . " " . $database_maint_time) +3600*24;
        }else{
                $next_db_maint_time = strtotime(date("Y-m-d") . " " . $database_maint_time);
        }             
}else{
        $next_db_maint_time = $last_db_maint_time + 24*3600;
} 

with this one:

Code: Select all

if (empty($last_db_maint_time)) {
    $next_db_maint_time = strtotime(date("Y-m-d") . " " . $database_maint_time);
}else{
    $next_db_maint_time = $last_db_maint_time + 24*3600;
}

It´s working fine right now.