Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:30150
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: error (pb1.pair.com: domain fischer.name from 213.46.255.22 cause and error)
Message-ID: <466FC781.3010601@fischer.name>
Date: Wed, 13 Jun 2007 12:31:29 +0200
User-Agent: Thunderbird 2.0.0.0 (Windows/20070326)
MIME-Version: 1.0
To: Alexey Zakhlestin <indeyets@gmail.com>, 
 stefan.priebsch@e-novative.de
CC:  internals@lists.php.net
References: <466F9623.3050102@fischer.name> <cd5680a20706130103q5c52e23bid428c7c0e5602b@mail.gmail.com>
In-Reply-To: <cd5680a20706130103q5c52e23bid428c7c0e5602b@mail.gmail.com>
OpenPGP: id=C2272BD0;
	url=http://markus.fischer.name/my_public_key.txt
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Subject: Re: [PHP-DEV] [PHP4] Logging native PHP function calls
From: markus@fischer.name (Markus Fischer)

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello Alexey, Stefan,

first thanks for the replies!

Actually I'm in general aware of xdebug, however I didn't know it met my
criteria.

The thing is: I need to know specific information of the mysql operations:

1) host,user,pass of connects/pconnects (and which type of connect),
count of connects this very request already had
2) sql statement on query, execution time, count of how many statements
this very request already had

Additional to that I need information like:
* server ip (multiple servers)
* remote ip
* http host (zillions of vhosts)
* uri
* user agent string


This is what we currently log for debugging, but we're unable to fully
coverage all sources.

As can be seen, my idea was to have a single place where to log things
from all servers/vhosts/applications, because they also make use of the
single mysql.so driver.

Is this possible with xdebug in this manner? With my current information
I really need this information and to my knowledge (falsely?) I can't
this out of xdebug. Probably important to note, I've been using xdebug
in the past, profiling things, but I don't see this possible in
production environment running and getting out the the information I need.

thank you,
- - Markus

Alexey Zakhlestin wrote:
> http://xdebug.org/
> 
> On 6/13/07, Markus Fischer <markus@fischer.name> wrote:
> 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
>>
- --
PHP Internals - PHP Runtime Development Mailing List
To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGb8eB1nS0RcInK9ARAoi7AJ0THIJ3VH/43Glq7VuxgpFPqlKieQCdHc8/
VLK3Jox+9AfcNzN4bLf/n7E=
=VYuh
-----END PGP SIGNATURE-----