This PHP Script is a tool to monitor your MySQL service/server and is used to show/display a complete list of MySQL processes with some details.

With this, we can see what is MySQL currently doing/executing. Provided information are active process ID, host name, users, databases being accessed, command type, state, running time per process, and SQL queries being executed.

Preview

Source code

Here is the complete code of this script

<?php
    //By    : Xhanch Studio
    //URL   :  http://xhanch.com/ 

    if(!isset($_GET['xhc-token']))
        die('Invalid token');

    $db_usr = "mysql user";
    $db_pwd = "mysql password";
    $db_hst = "localhost";

    $ato_rfr = 0;

    if($ato_rfr > 0)
       echo '<meta http-equiv="refresh" content="'.$ato_rfr.'">';    

    $con = mysql_connect($db_hst, $db_usr, $db_pwd);
    $rcd = mysql_list_processes($con);

    echo '
        <style>
            body{
                background:#cacaca;
                padding:0;
                margin:0
            }

            table{
                border:1px solid #c0c0c0
            }

            td, th{
               font-family: arial;
               font-size: 12px;
               text-align:left
            }

            th{
                background:#000;
                color:#fff;
            }

            td{
                background:#ffffff;
                border-bottom:1px solid #000
            }

            .kld td{
               background:#ff0000;
               color:#fff
            }
        </style>

        <table cellpadding="3" cellspacing="0" border="0" width="100%">
            <thead>
                <th style="width:50px">ID</th>
                <th style="width:100px">Host</th>
                <th style="width:75px">User</th>
                <th style="width:100px">Database</th>
                <th style="width:100px">Command</th>
                <th style="width:75px">State</th>
                <th style="width:50px">Time</th>
                <th>Info</th>
            </thead>
    ';

    while ($row = mysql_fetch_assoc($rcd)){
       if($row['Time'] > 100)
          $cls = " class='kld'";
       else
          $cls = "";
       
       echo '
           <tr'.$cls.'>
               <td>'.($row['Id']?$row['Id']:'&nbsp;').'</td>
               <td>'.($row['Host']?$row['Host']:'&nbsp;').'</td>
               <td>'.($row['User']?$row['User']:'&nbsp;').'</td>
               <td>'.($row['db']?$row['db']:'&nbsp;').'</td>
               <td>'.($row['Command']?$row['Command']:'&nbsp;').'</td>
               <td>'.($row['State']?$row['State']:'&nbsp;').'</td>
               <td>'.($row['Time']?$row['Time']:'&nbsp;').'</td>
               <td>'.($row['Info']?$row['Info']:'&nbsp;').'</td>
           </tr>
       ';
    }

    echo '</table>';
?>