Log rotation in MySQL table

remove_old_log_entries.sql

DELETE FROM logs WHERE id IN (select id from (select id FROM log ORDER BY id DESC LIMIT 1000, 500) x)

schema.sql

CREATE TABLE `log` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`level` TINYINT(4) NOT NULL,
	`content` TEXT NOT NULL,
	`date` DATETIME NOT NULL,
	PRIMARY KEY (`id`)
)
ENGINE=InnoDB;

script.php

<?php
$limit = 1000;
$remove = 500;

$sth = Flight::db()->prepare( 'DELETE FROM log WHERE id IN (select id from (select id FROM log ORDER BY id DESC LIMIT :limit, :remove) x)' );
$sth->bindParam( ':limit', $limit, PDO::PARAM_INT );
$sth->bindParam( ':remove', $remove, PDO::PARAM_INT );
$sth->execute();        
        
$count = $sth->rowCount();
$sth->closeCursor();