Shanti, Thanks for the link!
I have seen a lot of blogs but let's pretend you have a lot of PHP & MySql users and even more - PHP is on one host and MySQL is on another host. There is no guarantee even in case PHP and MySQL are on the same machine but multiple users access this AMP Stack that I will get MySQL query "MY" Php function call. Did I miss something? Is there any way to get univocal correspondence between Php function call and MySQL query execution? Thanks, Maria Shanti Subramanyam wrote: > We've demoded this many times using only the php dtrace probes and > then simply tracing thru the mysql dispatch_command call. See > http://blogs.sun.com/shanti/entry/debugging_amp for details. > > Shanti > > Martin MC Brown wrote: >> Hi Maria, >> >> >>> We are working on Photon project which is WebStack + Dtrace in >>> NetBeans >>> (http://jupiter.czech.sun.com/wiki/view/Netbeans/NB70DynLangDTrace ). >>> >> >> >>> I tried to find a way to be able to set up correspondence between >>> function call from PHP and query execution in MySQL using Dtrace. >>> >>> All I have in PHP itself is function-entry and function-return probes. >>> >>>> From MySQL I can get more info: such as connection id, host , user >>>> name, etc. >>>> >>> But how to set up this univocal correspondence between PHP and MYSQL? >>> >> >> You mean how do you identify within the PHP part of the code and >> relate those to the corresponding MySQL DTrace probes are you >> triggering? >> >> There isn't a way I can think of doing this currently with PHP only >> through DTrace, but in theory you could find out the information by >> asking PHP to return the connection ID (by running the query 'select >> connection_id()'), and then use that to work with the DTrace probes >> you are monitoring on the MySQL side. >> >> That's a bit clumsy, but it is an issue that crossed my mind when >> talking to Ted Leung about the project. I had some ideas before the >> Christmas break, but didn't get a chance to follow them through. I'm >> properly back in the office on Monday and will take a look at my >> notes then. >> >> MC >> >> -- >> Martin 'MC' Brown, mc at mcslp.com and mc.brown at sun.com >> Technical Writer, Database Group, Sun Microsystems >> Everything MCslp: http://planet.mcslp.com >> >> _______________________________________________ >> >> >> webstack-discuss mailing list >> webstack-discuss at opensolaris.org >> http://mail.opensolaris.org/mailman/listinfo/webstack-discuss >>
