----- Original Message ----- From: "Christopher A. Libby" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 16, 2002 3:32 PM Subject: Problems with high-use tables
Hi - I've been using MySQL for a variety of functions with great success over the last year. However, I recently rebuilt my log database server after a crash, and I've been having a lot of trouble with two tables getting corrupted. One table stores my syslog entries from Kiwi Syslod Daemon, and the other stores the actual firewall logs extracted from the syslog entries. Every five minutes I run a process which reads in all the syslog entries, extracts the firewall logs from them, then deletes the entries from the syslog table. My problem is I keep getting corrupted data files, which brings the whole system to a halt. I'm running MySQL v3 (latest build) on a WinNT4 box. I'm using Perl & MyODBC to process the data. Any thoughts? -Chris --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php