[PHP4] Logging native PHP function calls

-----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/

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

iD8DBQFGb8eB1nS0RcInK9ARAoi7AJ0THIJ3VH/43Glq7VuxgpFPqlKieQCdHc8/
VLK3Jox+9AfcNzN4bLf/n7E=
=VYuh
-----END PGP SIGNATURE