querystats.jsp

来自「jive的源码」· JSP 代码 · 共 417 行 · 第 1/2 页

</table>
</td></tr>
</table>

</ul>

<font size="-1"><b>Update Query Statistics</b></font>

<ul>

<table bgcolor="<%= tblBorderColor %>" cellpadding="0" cellspacing="0" border="0" width="600">
<tr><td>
<table bgcolor="<%= tblBorderColor %>" cellpadding="3" cellspacing="1" border="0" width="100%">
<tr bgcolor="#ffffff">
    <td><font size="-1">Total # of updates</font></td>
    <td><font size="-1"><%= ProfiledConnection.getQueryCount(ProfiledConnection.UPDATE) %></font></td>
</tr>
<tr bgcolor="#ffffff">
    <td><font size="-1">Total time for all updates (ms)</font></td>
    <td><font size="-1"><%= ProfiledConnection.getTotalQueryTime(ProfiledConnection.UPDATE) %></font></td>
</tr>
<tr bgcolor="#ffffff">
    <td><font size="-1">Average time for all updates (ms)</font></td>
    <td><font size="-1"><%= buildStringValue(ProfiledConnection.getAverageQueryTime(ProfiledConnection.UPDATE),3) %></font></td>
</tr>
<tr bgcolor="#ffffff">
    <td><font size="-1">Updates per second</font></td>
    <td><font size="-1"><%= buildStringValue(ProfiledConnection.getQueriesPerSecond(ProfiledConnection.UPDATE),3) %></font></td>
</tr>
<tr bgcolor="#ffffff">
    <td><font size="-1">10 Most common updates</font></td>
    <td bgcolor="#ffffff"><%
                list = ProfiledConnection.getSortedQueries(ProfiledConnection.UPDATE, sortByTime);

                if (list == null || list.length < 1) {
                    out.println("<font size=\"-1\">No queries</font>");
                }
                else { %>
            &nbsp;
     </td>
</tr>
</table>
</td></tr>
</table>

<br>

<table bgcolor="<%= tblBorderColor %>" cellpadding="0" cellspacing="0" border="0" width="600">
<tr><td>
<table bgcolor="<%= tblBorderColor %>" cellpadding="3" cellspacing="0" border="0" width="100%">
<tr bgcolor="#ffffff"><td>
<%
            out.println("<table width=\"100%\" cellpadding=\"3\" cellspacing=\"1\" border=\"0\" bgcolor=\"" + tblBorderColor + "\"><tr><td bgcolor=\"#ffffff\" align=\"middle\"><font size=\"-1\"><b>Query</b></font></td>");
            out.println("<td bgcolor=\"#ffffff\"><font size=\"-1\"><b><a href=\"javascript:location.href='querystats.jsp?sortByTime=false';\">Count</a></b></font></td>");
            out.println("<td bgcolor=\"#ffffff\"><font size=\"-1\"><b>Total Time (ms)</b></font></td>");
            out.println("<td bgcolor=\"#ffffff\"><font size=\"-1\"><b><a href=\"javascript:location.href='querystats.jsp?sortByTime=true';\">Average Time</a> (ms)</b></font></td></tr>");

            alternate = 0;

            for (int i = 0; i < ((list.length > 10) ? 10 : list.length); i++) {
                ProfiledConnectionEntry pce = list[i];
                out.println("<tr><td bgcolor=\"" + ((alternate%2 == 0) ? "#dddddd" : "#ffffff") + "\"><font size=\"-1\">" + pce.sql + "</font></td>");
                out.println("<td bgcolor=\"" + ((alternate%2 == 0) ? "#dddddd" : "#ffffff") + "\"><font size=\"-1\">" + pce.count + "</font></td>");
                out.println("<td bgcolor=\"" + ((alternate%2 == 0) ? "#dddddd" : "#ffffff") + "\"><font size=\"-1\">" + pce.totalTime + "</font></td>");
                out.println("<td bgcolor=\"" + ((alternate++%2 == 0) ? "#dddddd" : "#ffffff") + "\"><font size=\"-1\">" + pce.totalTime/pce.count + "</font></td></tr>");
            }
            out.println("</table>");
        }
    %></td>
</tr>
</table>
</td></tr>
</table>

</ul>

<font size="-1"><b>Delete Query Statistics</b></font>

<ul>

<table bgcolor="<%= tblBorderColor %>" cellpadding="0" cellspacing="0" border="0" width="600">
<tr><td>
<table bgcolor="<%= tblBorderColor %>" cellpadding="3" cellspacing="1" border="0" width="100%">
<tr bgcolor="#ffffff">
    <td><font size="-1">Total # of deletes</font></td>
    <td><font size="-1"><%= ProfiledConnection.getQueryCount(ProfiledConnection.DELETE) %></font></td>
</tr>
<tr bgcolor="#ffffff">
    <td><font size="-1">Total time for all deletes (ms)</font></td>
    <td><font size="-1"><%= ProfiledConnection.getTotalQueryTime(ProfiledConnection.DELETE) %></font></td>
</tr>
<tr bgcolor="#ffffff">
    <td><font size="-1">Average time for all deletes (ms)</font></td>
    <td><font size="-1"><%= buildStringValue(ProfiledConnection.getAverageQueryTime(ProfiledConnection.DELETE),3) %></font></td>
</tr>
<tr bgcolor="#ffffff">
    <td><font size="-1">Deletes per second</font></td>
    <td><font size="-1"><%= buildStringValue(ProfiledConnection.getQueriesPerSecond(ProfiledConnection.DELETE),3) %></font></td>
</tr>
<tr bgcolor="#ffffff">
    <td><font size="-1">10 Most common deletes</font></td>
    <td bgcolor="#ffffff"><%
                list = ProfiledConnection.getSortedQueries(ProfiledConnection.DELETE, sortByTime);

                if (list == null || list.length < 1) {
                    out.println("<font size=\"-1\">No queries</font>");
                }
                else { %>
            &nbsp;
     </td>
</tr>
</table>
</td></tr>
</table>

<br>

<table bgcolor="<%= tblBorderColor %>" cellpadding="0" cellspacing="0" border="0" width="600">
<tr><td>
<table bgcolor="<%= tblBorderColor %>" cellpadding="3" cellspacing="0" border="0" width="100%">
<tr bgcolor="#ffffff"><td>
<%
            out.println("<table width=\"100%\" cellpadding=\"3\" cellspacing=\"1\" border=\"0\" bgcolor=\"" + tblBorderColor + "\"><tr><td bgcolor=\"#ffffff\" align=\"middle\"><font size=\"-1\"><b>Query</b></font></td>");
            out.println("<td bgcolor=\"#ffffff\"><font size=\"-1\"><b><a href=\"javascript:location.href='querystats.jsp?sortByTime=false';\">Count</a></b></font></td>");
            out.println("<td bgcolor=\"#ffffff\"><font size=\"-1\"><b>Total Time (ms)</b></font></td>");
            out.println("<td bgcolor=\"#ffffff\"><font size=\"-1\"><b><a href=\"javascript:location.href='querystats.jsp?sortByTime=true';\">Average Time</a> (ms)</b></font></td></tr>");

            alternate = 0;

            for (int i = 0; i < ((list.length > 10) ? 10 : list.length); i++) {
                ProfiledConnectionEntry pce = list[i];
                out.println("<tr><td bgcolor=\"" + ((alternate%2 == 0) ? "#dddddd" : "#ffffff") + "\"><font size=\"-1\">" + pce.sql + "</font></td>");
                out.println("<td bgcolor=\"" + ((alternate%2 == 0) ? "#dddddd" : "#ffffff") + "\"><font size=\"-1\">" + pce.count + "</font></td>");
                out.println("<td bgcolor=\"" + ((alternate%2 == 0) ? "#dddddd" : "#ffffff") + "\"><font size=\"-1\">" + pce.totalTime + "</font></td>");
                out.println("<td bgcolor=\"" + ((alternate++%2 == 0) ? "#dddddd" : "#ffffff") + "\"><font size=\"-1\">" + pce.totalTime/pce.count + "</font></td></tr>");
            }
            out.println("</table>");
        }
    %></td>
</tr>
</table>
</td></tr>
</table>

</ul>

<ul>
<table bgcolor="<%= tblBorderColor %>" cellpadding="0" cellspacing="0" border="0" width="300">
<tr><td>
<table bgcolor="<%= tblBorderColor %>" cellpadding="3" cellspacing="1" border="0" width="100%">
<tr bgcolor="#ffffff">
    <td colspan="2">
        <form action="querystats.jsp">
        <input type="hidden" name="doClear" value="true">
        <input type="submit" value="Clear Query Statistics">
        </form></td>
</tr>
</table>
</td></tr>
</table>

</ul>

<p>
<b>Query Statistics</b><p>

<% } %>


Enable query statistics to trace all database queries made by Jive Forums. This can
be useful to debug issues and monitor database performance. However, it's not recommended that
you leave query statistics permanently running, as they will cause performance to degrade slightly.

<ul>

<form action="querystats.jsp">
<table bgcolor="<%= tblBorderColor %>" cellpadding="0" cellspacing="0" border="0" width="300">
<tr><td>
<table bgcolor="<%= tblBorderColor %>" cellpadding="3" cellspacing="1" border="0" width="100%">
<tr bgcolor="#ffffff">
    <td align="center" <%= ((doLog) ? "bgcolor=\"#99cc99\"":"") %>>
    <font size="-1">
        <input type="radio" name="doLog" value="true" id="rb01" <%= ((doLog) ? "checked":"") %>>
        <label for="rb01"><%= ((doLog) ? "<b>On</b>":"On") %></label>
    </font>
    </td>
    <td align="center" <%= ((!doLog) ? "bgcolor=\"#cc6666\"":"") %>>
    <font size="-1">
        <input type="radio" name="doLog" value="false" id="rb02" <%= ((!doLog) ? "checked":"") %>>
        <label for="rb02"><%= ((!doLog) ? "<b>Off</b>":"Off") %></label>
    </font>
    </td>
    <td align="center">
        <input type="submit" value="Update">
    </td>
</tr>
</table>
</td></tr>
</table>
</form>

</ul>

</body>
</html>