When the scripts where originally written, I didn't have a clue about the DBD::MySQL module. I've also got scripts running in VBScript via ODBC, so I wanted to stick to a standard I/O method.
-Chris ----- Original Message ----- From: "William R. Mussatto" <[EMAIL PROTECTED]> To: "Christopher A. Libby" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, July 18, 2002 11:30 AM Subject: Re: Fw: Problems with high-use tables Just a quick question. Why are you not running DBD::Mysql directly? It should eliminate the ODBC layer and help with speed. On Thu, 18 Jul 2002, Christopher A. Libby wrote: > Date: Thu, 18 Jul 2002 08:22:33 -0400 > From: Christopher A. Libby <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Fw: Problems with high-use tables > > > ----- 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 > Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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