> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of > Martin Moss > Sent: Wednesday 07 June 2000 16:03 > To: Perl-Win32-Users Mailing List; [EMAIL PROTECTED] > Subject: Corruption of Database > > > All, > > I have a problem with a mysql database. > I need to make many, many updates and additions, but no deletions from a > mysql database, all in quick succession. > > basically I'm using a mysql database on a the back end of a web robot. so > every second there is a list of links (new entries) and 1 update > to be made. > There are also concurrent processes using the database. > > The problem:- > > usually within the space of about 5 minutes my database becomes extremely > corrupt so that I get an error 127. > > I get this error, and others simillar, when I run myisamchk on > the database > whilst the processes are running > > Checking MyISAM file: Links.MYI > Data records: 42556 Deleted blocks: 0 > - check file-size > - check key delete-chain > - check record delete-chain > - check index reference > - check data record references index: 1 > myisamchk: error: Found 42570 keys of 42556 > - check record links > myisamchk: error: Keypointers and record positions doesn't match > MyISAM-table 'Links.MYI' is corrupted > Fix it using switch "-r" or "-o" > > Could somebody provide some clarification opn the use of the Perl DBI > module? > currently I only make one $dbh connection, and then use multiple > sth handles > to update the database. then I close the $dbh handle. > However the table becomes corrupted before the web robot has > finished and I > close the $dbh connection. > > I did try using one $dbh handle for every $sth execution, however after a > period of about 5 mins again, I would get database connection failures. > > I would appreciate any thoughts or comments that anybody might have. > > Regards > > Marty > > > > > > _______________________________________________ > Perl-win32-users mailing list > [EMAIL PROTECTED] > http://listserv.activestate.com/mailman/listinfo/perl-win32-users > _______________________________________________ > Perl-Win32-Users mailing list > [EMAIL PROTECTED] > http://listserv.ActiveState.com/mailman/listinfo/perl-win32-users --------------------------------------------------------------------- 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