Turn logging on or off for SQL statements

2002-09-22 Thread Owain McGuire
Is there an easy way to turn logging or SQL statement executions on or off without having to restart with a changed my.cnf file? Just want to log queries to try and sort out some performance problems. Thanks, O. (sql) -

re-using $dbh

2002-09-21 Thread Owain McGuire
I have written a web application using Perl, DBI and MYSQL 3.23.41. I have built the application so that only the interface logic is in the perl cgi scripts (not fastcgi) and all of the real work is done is in perl modules, one of which I call Mydefaults.pm which holds the db connect informat