Insane CPU usage on Firebird v 1.0
| From: | (Evan Morris) | 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)