querystats.jsp

jive3论坛开源 最新 有版主功能 jive3论坛开源 最新 有版主功能 jive3论坛开源 最新 有版主功能

<%--
  - $RCSfile: querystats.jsp,v $
  - $Revision: 1.4 $
  - $Date: 2003/05/18 21:17:10 $
  -
  - Copyright (C) 2002-2003 Jive Software. All rights reserved.
  -
  - This software is the proprietary information of Jive Software. Use is subject to license terms.
--%>

<%@ page import="java.sql.*,
                 com.jivesoftware.util.ParamUtils,
                 com.jivesoftware.base.database.*,
                 java.text.*"
    errorPage="error.jsp"
%>

<%@ include file="global.jsp" %>

<%! // Global methods, vars

    // Default refresh values
    static final int[] REFRESHES = {10,30,60,90};
%>

<%  // Permission check
    if (!isSystemAdmin) {
        throw new UnauthorizedException("You don't have admin privileges to perform this operation.");
    }

    // Get parameters
    boolean doClear = request.getParameter("doClear") != null;
    String enableStats = ParamUtils.getParameter(request,"enableStats");
    int refresh = ParamUtils.getIntParameter(request,"refresh", -1);
    boolean doSortByTime = ParamUtils.getBooleanParameter(request,"doSortByTime");

    // Var for the alternating colors
    int rowColor = 0;

    // clear the statistics
    if (doClear) {
        ProfiledConnection.resetStatistics();
    }

    // Enable/disable stats
    if ("true".equals(enableStats)) {
        ConnectionManager.setProfilingEnabled(true);
    }
    else if ("false".equals(enableStats)) {
        ConnectionManager.setProfilingEnabled(false);
    }

    boolean showQueryStats = ConnectionManager.isProfilingEnabled();

    // Number intFormat for pretty printing of large number values and decimals:
    NumberFormat intFormat = NumberFormat.getInstance(JiveGlobals.getLocale());
    DecimalFormat decFormat = new DecimalFormat("#,##0.00");
%>

<%@ include file="header.jsp" %>

<%  // Enable refreshing if specified
    if (refresh >= 10) {
%>
    <meta http-equiv="refresh" content="<%= refresh %>;URL=querystats.jsp?refresh=<%= refresh %>">

<%  } %>

<%  // Title of this page and breadcrumbs
    String title = "Query Statistics";
    String[][] breadcrumbs = {
        {"Main", "main.jsp"},
        {title, "querystats.jsp"}
    };
%>
<%@ include file="title.jsp" %>

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.

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

<form action="querystats.jsp">
<ul>
    <table cellpadding="3" cellspacing="1" border="0">
    <tr>
        <td>
            <input type="radio" name="enableStats" value="true" id="rb01" <%= ((showQueryStats) ? "checked":"") %>>
            <label for="rb01"><%= ((showQueryStats) ? "<b>Enabled</b>":"Enabled") %></label>
        </td>
        <td>
            <input type="radio" name="enableStats" value="false" id="rb02" <%= ((!showQueryStats) ? "checked":"") %>>
            <label for="rb02"><%= ((!showQueryStats) ? "<b>Disabled</b>":"Disabled") %></label>
        </td>
        <td>
            <input type="submit" name="" value="Update">
        </td>
    </tr>
    </table>
</ul>
</form>

<%  if (showQueryStats) { %>

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

    <form action="querystats.jsp">
    <ul>
        <table cellpadding="3" cellspacing="1" border="0">
        <tr>
            <td>
                Refresh:
                <select size="1" name="refresh" onchange="this.form.submit();">
                <option value="none">None

                <%  for (int j=0; j<REFRESHES.length; j++) {
                        String selected = ((REFRESHES[j] == refresh) ? " selected" : "");
                %>
                    <option value="<%= REFRESHES[j] %>"<%= selected %>
                     ><%= REFRESHES[j] %> seconds

                <%  } %>
                </select>
            </td>
            <td>
                <input type="submit" name="" value="Set">
            </td>
            <td>|</td>
            <td>
                <input type="submit" name="" value="Update Now">
            </td>
            <td>|</td>
            <td>
                <input type="submit" name="doClear" value="Clear All Stats">
            </td>
        </tr>
        </table>
    </ul>
    </form>

    <br>

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

    <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>Total # of selects</td>
        <td><%= intFormat.format(ProfiledConnection.getQueryCount(ProfiledConnection.SELECT)) %></td>
    </tr>
    <tr bgcolor="#ffffff">
        <td>Total time for all selects (ms)</td>
        <td><%= intFormat.format(ProfiledConnection.getTotalQueryTime(ProfiledConnection.SELECT)) %></td>
    </tr>
    <tr bgcolor="#ffffff">
        <td>Average time for all selects (ms)</td>
        <td><%= decFormat.format(ProfiledConnection.getAverageQueryTime(ProfiledConnection.SELECT)) %></td>
    </tr>
    <tr bgcolor="#ffffff">
        <td>Selects per second</td>
        <td><%= decFormat.format(ProfiledConnection.getQueriesPerSecond(ProfiledConnection.SELECT)) %></td>
    </tr>
    <tr bgcolor="#ffffff">
        <td>20 Most common selects</td>
        <td bgcolor="#ffffff"><%
                    ProfiledConnectionEntry[] list = ProfiledConnection.getSortedQueries(ProfiledConnection.SELECT, doSortByTime);

                    if (list == null || list.length < 1) {
                        out.println("No queries");
                    }
                    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\"><b>Query</b></td>");
            out.println("<td bgcolor=\"#ffffff\"><b><a href=\"javascript:location.href='querystats.jsp?doSortByTime=false&refresh=" + refresh + "';\">Count</a></b></td>");
            out.println("<td bgcolor=\"#ffffff\"><b>Total Time (ms)</b></td>");
            out.println("<td bgcolor=\"#ffffff\"><b><a href=\"javascript:location.href='querystats.jsp?doSortByTime=true&refresh=" + refresh + "';\">Average Time</a> (ms)</b></td></tr>");

            for (int i = 0; i < ((list.length > 20) ? 20 : list.length); i++) {
                ProfiledConnectionEntry pce = list[i];
                out.println("<tr><td bgcolor=\"" + ((rowColor%2 == 0) ? "#dddddd" : "#ffffff") + "\">" + pce.sql + "</td>");
                out.println("<td bgcolor=\"" + ((rowColor%2 == 0) ? "#dddddd" : "#ffffff") + "\">" + intFormat.format(pce.count) + "</td>");
                out.println("<td bgcolor=\"" + ((rowColor%2 == 0) ? "#dddddd" : "#ffffff") + "\">" + intFormat.format(pce.totalTime) + "</td>");
                out.println("<td bgcolor=\"" + ((rowColor++%2 == 0) ? "#dddddd" : "#ffffff") + "\">" + intFormat.format(pce.totalTime/pce.count) + "</td></tr>");
            }
            out.println("</table>");
        }
     %></td>
    </tr>
    </table>
    </td></tr>
    </table>

    </ul>

    <b>INSERT Query Statistics</b>