echo ' failed ' . PHP_EOL;
}
}
}
}
} else {
echo "no table to delete " . PHP_EOL;
}
}
/**
* 删除一个月前的日志
*/
function del_stats()
{
$time_key = date("Y-m-d", time() - 3600 * 24 * 30);
$tables = array('stats', 'stats_client', 'stats_server');
foreach ($tables as $table) {
while (true) {
$sql1 = "DELETE FROM `" . $table . "` where date_key < '{$time_key}' limit 1000";
echo $sql1 . "\n";
$res = Swoole::$php->db->query($sql1);
if ($res === false) {
break;
}
}
}
}
$cron = new Cron();
$cron->set_job('del_log');
$cron->set_job('del_stats');
$cron->run();
