Scalr\System\Zmq\Cron\Task\Rotate::rotateTable PHP Method

    private function rotateTable($query, $opt = array(), $service = 'adodb')
    {
        $db = \Scalr::getContainer()->{$service};
        $opt[] = $this->config()->delete['limit'];
        do {
            $db->Execute($query . " LIMIT ?", $opt);
            $affected = $db->Affected_Rows();
            $this->getLogger()->info("%d record%s %s removed", $affected, $affected != 1 ? 's' : '', $affected > 1 ? 'were' : 'was');
            if ($affected == $this->config()->delete['limit']) {
                $this->getLogger()->info("I am waiting for %d seconds before removing next records.", $this->config()->delete['sleep']);
                sleep($this->config()->delete['sleep']);
            }
        } while ($affected >= $this->config()->delete['limit']);
    }