Hi Markus, > 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
You can configure xdebug to create a trace log showing the parameters passed to the called functions. This could be a basis for what you need. > Additional to that I need information like: > * server ip (multiple servers) > * remote ip > * http host (zillions of vhosts) > * uri > * user agent string A quick and maybe dirty idea that comes to my mind is to add a function call in your application that has these parameter (easy to gather from $_SERVER etc.) so they show up in the trace logs. Then it's a matter of processing a gazillion lines of trace log to get out the information you need, but at least it should be there. > in the past, profiling things, but I don't see this possible in > production environment running and getting out the the information I need. Trace logging in a production environment *absolutely* kills your performance, so if you have to dedicated test environment, hmmm. But would you actually create a patched PHP and deploy this in your production environment. Then I personally would rather opt for running an xdebug-based trace Sunday morning at 4 am. Kind regards, Stefan -- >e-novative> - We make IT work for you. e-novative GmbH - HR: Amtsgericht München HRB 139407 Sitz: Wolfratshausen - GF: Dipl. Inform. Stefan Priebsch http://www.e-novative.de -- PHP Internals - PHP Runtime Development Mailing List To unsubscribe, visit: http://www.php.net/unsub.php
