Insane CPU usage on Firebird v 1.0

From: Date: Mon, 02 Feb 2004 15:52:09 +0000
Subject: Insane CPU usage on Firebird v 1.0
Groups: php.db 
Request: Send a blank email to php-db+get-32758@lists.php.net to get a copy of this message
Hi Launched a customer-facing e-commerce site last week using PHP talking to Firebird v 1.0 Everything looked sweet until I started getting PHP-level errors about not being able to connect to the database. Check the box the database is running on (2.8 GHz dual processors) and running top found that gds_inet_server is munching 100% of resources, even with as few as 10 connections open. More worrying, some processes are staying alive like the goddamned BeeGees, in excess of half an hour at a time. I explicitly close every connection to the database in my code with ibase_close(); Thoughts? Things I should be looking into? Is there a convenient laundry-list somewhere of issues relating to CPU-munching in Firebird so I can check out each one? I've currently disabled database connections on the site, making it pretty but useless. I really need help on this one. All comments, thoughts, insights, guru-like solutions, etc, appreciated. Thanks Evan Morris evan@exclusivebooks.com +27 11 792 2777 (t) +27 11 792 2711 (f)

« previous php.db (#32758) next »