Lampwrights Forum

Lampwrights Forum (http://www.lampwrights.com/index.php)
-   vBulletin Talk (http://www.lampwrights.com/forumdisplay.php?f=12)
-   -   Tracing MySQL Queries in Vbulletin (http://www.lampwrights.com/showthread.php?t=359)

Jeff 07-18-2012 02:17 PM

Tracing MySQL Queries in Vbulletin
 
Sometimes you find the need to to trace back where queries are coming from, whether they be in your slow log, or if you are watching them real time. Sometimes it can be hard finding which script is firing certain queries. By editing includes/class_core.php, you can insert a MySQL comment at the end of all queries telling you what script was invoked when the call was made. Find this code:

PHP Code:

    function &execute_query($buffered true, &$link)
    {
        
$this->connection_recent =& $link;
        
$this->querycount++; 

Add this line afterwards:

PHP Code:

$this->sql .= ' #Executed from ' $this->escape_string(THIS_SCRIPT); 

Now when you view a query coming through the MySQL server, you will see something like:

Code:

SELECT * FROM thread where userid = 901324 #Executed from showthread


All times are GMT -4. The time now is 06:45 PM.

Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2024, vBulletin Solutions, Inc.