Snort mailing list archives
RE: ACID Archive Database
From: "Lance Boon" <lboon () firststatebanksw com>
Date: Thu, 2 Sep 2004 09:13:31 -0500
Try this http://dev.mysql.com/doc/mysql/en/myisamchk_repair_options.html --safe-recover, -o Do a repair using an old recovery method that reads through all rows in order and updates all index trees based on the rows found. This is an order of magnitude slower than -r, but can handle a couple of very unlikely cases that -r cannot. This recovery method also uses much less disk space than -r. Normally, you should repair first with -r, and then with -o only if -r fails. If you have lots of memory, you should increase the value of key_buffer_size. -----Original Message----- From: snort-users-admin () lists sourceforge net [mailto:snort-users-admin () lists sourceforge net] On Behalf Of Ma, Kenneth K. Sent: Thursday, September 02, 2004 8:23 AM To: 'snort-users () lists sourceforge net' Subject: [Snort-users] ACID Archive Database The acid_archive database is reporting errors when I am running the myisamchk -r on the data.MYD. I can't repair this table. Is there anything I can do or do I need to dump the entire database? thanks Kenneth Ma 2415 First Ave MS: B192 Sacramento, CA 95818 (916) 657-8198 kma () dmv ca gov ------------------------------------------------------- This SF.Net email is sponsored by BEA Weblogic Workshop FREE Java Enterprise J2EE developer tools! Get your free copy of BEA WebLogic Workshop 8.1 today. http://ads.osdn.com/?ad_id=5047&alloc_id=10808&op=click _______________________________________________ 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
Attachment:
smime.p7s
Description:
Current thread:
- ACID Archive Database Ma, Kenneth K. (Sep 02)
- <Possible follow-ups>
- RE: ACID Archive Database Lance Boon (Sep 02)