100 sites (100 or more days :P)
* * * * * mysql -e "use <schema>; delete from <table> where date_created < (now() - interval 5 minute);"
$mysql_user="your user here";
$mysql_password="your password here";
hundred
), grant the above credentials rights for INSERT and SELECT and DELETE:
grant select, insert on <schema>.<table> to 'user'@'localhost' identified by 'password'
+--------------+-------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+-------------------+----------------+
| id | int(5) | NO | PRI | NULL | auto_increment |
| date_created | timestamp | NO | | CURRENT_TIMESTAMP | |
| url | text | YES | | NULL | |
| shortlink | varchar(50) | YES | | NULL | |
+--------------+-------------+------+-----+-------------------+----------------+
this lives ine one of these places: