RE: DBI access from CGI script

2001-05-25 Thread Andy Sharp
The syntax for connecting to a mysql database from perl/DBI is my $dbh = DBI-connect('dbi:drivername:database:host','username','passwor d'); If host is ommitted, it presumes localhost. Eg: $dbh = DBI-connect('dbi:mysql:testDB:dbserv','$username','$password'); There are more options see

Re: mysql uses 99% cpu under freebsd 4.3

2001-04-09 Thread Andy Sharp
Similar problems on FreeBSD 4.2-RELEASE. Dedicated Mysql server is pinning the CPU, under a load of 500+ queries per second. Memory is not exausted, and Disk usage is 0. Just the CPU is pinned. [EMAIL PROTECTED] wrote: Description: mysql uses 99% cpu and becomes extremely

Speed and Hardware

2001-04-04 Thread Andy Sharp
Hi, I'm facing an issue with my primary mySQL server. It powers a web site, which loads almost 100% dynamic data. At peak times of the day, it seems to me that the Database is becomming maxxed. (Thus bogging the site) I'm aware that there are simply too many variables to completely answer