Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # usage "mysql -u YOUR-DB-USER -p < dbclean.sql"
- # adapted from https://rdpetti.wordpress.com/2011/06/28/snort-database-cleaning-2/
- use snort;
- DELETE FROM event WHERE timestamp < DATE_SUB(NOW(),INTERVAL 28 DAY);
- DELETE FROM data USING data LEFT OUTER JOIN event USING (sid,cid) WHERE event.sid IS NULL;
- DELETE FROM iphdr USING iphdr LEFT OUTER JOIN event USING (sid,cid) WHERE event.sid IS NULL;
- DELETE FROM icmphdr USING icmphdr LEFT OUTER JOIN event USING (sid,cid) WHERE event.sid IS NULL;
- DELETE FROM tcphdr USING tcphdr LEFT OUTER JOIN event USING (sid,cid) WHERE event.sid IS NULL;
- DELETE FROM udphdr USING udphdr LEFT OUTER JOIN event USING (sid,cid) WHERE event.sid IS NULL;
- DELETE FROM opt USING opt LEFT OUTER JOIN event USING (sid,cid) WHERE event.sid IS NULL;
- OPTIMIZE TABLE event, data, iphdr, icmphdr, tcphdr, udphdr, opt;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement