Newsgroups: php.internals Path: news.php.net Xref: news.php.net php.internals:30146 Return-Path: Mailing-List: contact internals-help@lists.php.net; run by ezmlm Delivered-To: mailing list internals@lists.php.net Received: (qmail 61134 invoked by uid 1010); 13 Jun 2007 07:01:08 -0000 Delivered-To: ezmlm-scan-internals@lists.php.net Delivered-To: ezmlm-internals@lists.php.net Received: (qmail 61099 invoked from network); 13 Jun 2007 07:01:07 -0000 Received: from unknown (HELO lists.php.net) (127.0.0.1) by localhost with SMTP; 13 Jun 2007 07:01:07 -0000 Authentication-Results: pb1.pair.com header.from=markus@fischer.name; sender-id=unknown Authentication-Results: pb1.pair.com smtp.mail=markus@fischer.name; spf=permerror; sender-id=unknown Received-SPF: error (pb1.pair.com: domain fischer.name from 213.46.255.22 cause and error) X-PHP-List-Original-Sender: markus@fischer.name X-Host-Fingerprint: 213.46.255.22 viefep18-int.chello.at Solaris 10 (beta) Received: from [213.46.255.22] ([213.46.255.22:21752] helo=viefep25-int.chello.at) by pb1.pair.com (ecelerity 2.1.1.9-wez r(12769M)) with ESMTP id 39/76-04698-C269F664 for ; Wed, 13 Jun 2007 03:01:05 -0400 Received: from genuine ([213.47.89.232]) by viefep25-int.chello.at (InterMail vM.7.08.02.00 201-2186-121-20061213) with ESMTP id <20070613070057.PZFW11663.viefep25-int.chello.at@genuine> for ; Wed, 13 Jun 2007 09:00:57 +0200 Received: from mail.netcare.at ([213.164.23.137] helo=[10.15.10.15]) by genuine with esmtpa (Exim 4.50) id 1HyMi2-00078V-HG for internals@lists.php.net; Wed, 13 Jun 2007 08:52:06 +0200 Message-ID: <466F9623.3050102@fischer.name> Date: Wed, 13 Jun 2007 09:00:51 +0200 User-Agent: Thunderbird 2.0.0.0 (Windows/20070326) MIME-Version: 1.0 To: internals@lists.php.net X-Enigmail-Version: 0.95.1 OpenPGP: id=C2272BD0; url=http://markus.fischer.name/my_public_key.txt Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Spam-Score: 0 X-Spam-Level: / X-Spam-Report: Spam detection software, running on the system "genuine", has identified this incoming email as possible spam. The original message has been attached to this so you can view it (if it isn't spam) or label similar future email. If you have any questions, see the administrator of that system for details. Content preview: -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I've this very very special problems and would ask for some hints, any helpful response is very appreciated :) [...] Content analysis details: (0.0 points, 5.0 required) pts rule name description ---- ---------------------- -------------------------------------------------- Subject: [PHP4] Logging native PHP function calls From: markus@fischer.name (Markus Fischer) -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I've this very very special problems and would ask for some hints, any helpful response is very appreciated :) The usual story: old system, big, clunky, legacy, PHP4, can't upgrade. We're having serious problems with MySQL and too many connections and so on, but we can't find out where the problematic cases are. We've gone already through lengthy auditing and logging sessions without real success. So my next idea: I go into the PHP source, in my case specifically into ext/mysql/php_mysql.c, reactive my old C skills and inject the logging of connects and queries directly into the source. Because, as ironic as it sounds, with the HUGE amount of code we have we still were not able to identify all places where mysql_(p)connect/mysql_query is used, because of using variable variables and other nice [tm] tricks. I understand my attempt is brute force and I'm pretty alone out there. So, actually I would start hacking away this very moment. But, if anyone has other suggestion how to go for this, it would be very very much appreciated. thanks for reading, - - Markus -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFGb5Yj1nS0RcInK9ARAq75AJ95JT3BqFblyfd+FUG2EsKbN8TAdgCfQ0c/ YNTYC8qTPHgzIQPxiJsGJW0= =4wNf -----END PGP SIGNATURE-----