Snort mailing list archives
RE: Mysql cleanup script?
From: "Mike Walter" <mwalter () 3z net>
Date: Mon, 4 Nov 2002 13:26:00 -0500
Bruce, I found this to be an issue as well. I wrote a simple script that optimizes the tables at night. This will clean up the blank space from deleteing information. I run this script every night at like 1:00 or so. I created a simple cron job as root and made a file called op.snort. Here is everything I use. Hope this helps. cron job ---------- /usr/local/mysql/bin/mysql snort -u snort -ppassword< ./op.snort file op.snort ------------ OPTIMIZE TABLE `acid_ag`; OPTIMIZE TABLE `acid_ag_alert`; OPTIMIZE TABLE `acid_event`; OPTIMIZE TABLE `acid_ip_cache`; OPTIMIZE TABLE `data`; OPTIMIZE TABLE `detail`; OPTIMIZE TABLE `encoding`; OPTIMIZE TABLE `event`; OPTIMIZE TABLE `icmphdr`; OPTIMIZE TABLE `iphdr`; OPTIMIZE TABLE `opt`; OPTIMIZE TABLE `reference`; OPTIMIZE TABLE `reference_system`; OPTIMIZE TABLE `schema`; OPTIMIZE TABLE `sensor`; OPTIMIZE TABLE `sig_class`; OPTIMIZE TABLE `sig_reference`; OPTIMIZE TABLE `signature`; OPTIMIZE TABLE `tcphdr`; OPTIMIZE TABLE `udphdr`; Mike Walter, MCP PCD Network Solutions, Inc. 3z.net a PCD Company <http://www.3z.net> "When Success is the Only Solution t h i n K 3z.net" -----Original Message----- From: Bruce Platt [mailto:Bruce () ei3 com] Sent: Monday, November 04, 2002 12:49 PM To: snort-users () lists sourceforge net Subject: RE: [Snort-users] Mysql cleanup script? On a similar subject, Over time, even with deleting old alerts, the DB itself grows. What's the best way to "shrink" it, so that it takes up less space on disk? I thought Roman had posted something like this, but I can't seem to find it. Or, perhaps I imagined it. Regards
-----Original Message----- From: Nathan Whitehouse [mailto:nwhitehouse () compendiumusa net] Sent: Monday, November 04, 2002 9:04 AM To: snort-users () lists sourceforge net Subject: [Snort-users] Mysql cleanup script? Dose anyone have a Mysql cleanup script? Something I can run once a week or month to clean out my Mysql database for snort alerts. Thanks Nathan Whitehouse Network Operations & Systems Administrator CompEndium Services Inc. Main 877-709-2667 Local 678-985-5678 Direct 770-822-6697 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.408 / Virus Database: 230 - Release Date: 10/24/2002 ------------------------------------------------------- This SF.net email is sponsored by: ApacheCon, November 18-21 in Las Vegas (supported by COMDEX), the only Apache event to be fully supported by the ASF. http://www.apachecon.com _______________________________________________ Snort-users mailing list Snort-users () lists sourceforge net Go to this URL to change user options or unsubscribe: https://lists.sourceforge.net/lists/listinfo/snort-users Snort-users list archive: http://www.geocrawler.com/redir-sf.php3?list=snort-users
------------------------------------------------------- This SF.net email is sponsored by: ApacheCon, November 18-21 in Las Vegas (supported by COMDEX), the only Apache event to be fully supported by the ASF. http://www.apachecon.com _______________________________________________ Snort-users mailing list Snort-users () lists sourceforge net Go to this URL to change user options or unsubscribe: https://lists.sourceforge.net/lists/listinfo/snort-users Snort-users list archive: http://www.geocrawler.com/redir-sf.php3?list=snort-users ------------------------------------------------------- This SF.net email is sponsored by: ApacheCon, November 18-21 in Las Vegas (supported by COMDEX), the only Apache event to be fully supported by the ASF. http://www.apachecon.com _______________________________________________ Snort-users mailing list Snort-users () lists sourceforge net Go to this URL to change user options or unsubscribe: https://lists.sourceforge.net/lists/listinfo/snort-users Snort-users list archive: http://www.geocrawler.com/redir-sf.php3?list=snort-users
Current thread:
- Mysql cleanup script? Nathan Whitehouse (Nov 04)
- Re: Mysql cleanup script? quentyn (Nov 04)
- Re: Mysql cleanup script? gerhard (Nov 04)
- Re: Mysql cleanup script? Ian Macdonald (Nov 05)
- <Possible follow-ups>
- RE: Mysql cleanup script? Bruce Platt (Nov 04)
- RE: Mysql cleanup script? Derrick Lichti (Nov 04)
- RE: Mysql cleanup script? Mike Walter (Nov 04)
- RE: Mysql cleanup script? Mike Walter (Nov 04)
- Re: Mysql cleanup script? quentyn (Nov 04)