Hello Alexey, Stefan,
first thanks for the replies!
Actually I'm in general aware of xdebug, however I didn't know it met my
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)
* 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.
- - Markus
Alexey Zakhlestin wrote:
On 6/13/07, Markus Fischer wrote:
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
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
thanks for reading,
PHP Internals - PHP Runtime Development Mailing List
To unsubscribe, visit: http://www.php.net/unsub.php