Advise Requested: Troubleshooting Perl/Mysql/Sendmail Performance

Hi: I'm hoping you can lend some helping thoughts The system: a perl mailing list tool which accepts add/deletes via emails (sendmail piped) and then updates the backend database accordingly. The problem: once about 10 or more emails arrive, I begin to get performance problems from the

RE: Quotation Marks in Mysql fields

Bill: What about the DBI's quote() method... isn't this what its for? http://www.mysql.com/doc/P/e/Perl_DBI_Class.html Keith -Original Message- From: Bill Platt [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 02, 2002 2:25 AM To: [EMAIL PROTECTED] Subject: Quotation Marks in Mysql

HELP Needed! myisamchk error!

Hi: I am running a simple INSERT query in perl code and am getting the following error from myisamchk: myisamchk: warning: 1 clients is using or hasn't closed the table properly Note that no such warning occurs when I issue a SELECT query. I can clean up the warning by issuing a check table,

myisamchk -e reports: clients haven't closed table after INSERT

Hi: I am finding that my perl code generates warnings by myisamchk whenever it executes an INSERT command, but *NOT* a SELECT command. I just upgraded this perl application (which had no problems before), to: MySQL-3.23.48-1 perl-DBD-MySQL-1.2216-4 perl-DBI-1.18-1 If I connect to the database