<fmt:message key="server.db

<%-- - $Revision: 27964 $ - $Date: 2006-03-02 09:27:01 -0800 (Thu, 02 Mar 2006) $ - - Copyright (C) 1999-2004 Jive Software. All rights reserved. - This software is the proprietary information of Jive Software. Use is subject to license terms. --%> <%@ page import="java.text.*" errorPage="error.jsp" %> <%@ page import="org.jivesoftware.database.DbConnectionManager"%> <%@ page import="org.jivesoftware.util.JiveGlobals"%> <%@ page import="org.jivesoftware.database.ProfiledConnection"%> <%@ page import="org.jivesoftware.database.ProfiledConnectionEntry"%> <%@ page import="org.jivesoftware.util.ParamUtils"%> <%@ page import="org.jivesoftware.util.LocaleUtils"%> <%@ taglib uri="http://java.sun.com/jstl/core_rt" prefix="c" %> <%@ taglib uri="http://java.sun.com/jstl/fmt_rt" prefix="fmt" %> <%! // Global methods, vars // Default refresh values static final int[] REFRESHES = {10,30,60,90}; %> <% // 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(); // Reload the page without params. response.sendRedirect("server-db-stats.jsp"); } // Enable/disable stats if ("true".equals(enableStats)) { DbConnectionManager.setProfilingEnabled(true); } else if ("false".equals(enableStats)) { DbConnectionManager.setProfilingEnabled(false); } boolean showQueryStats = DbConnectionManager.isProfilingEnabled(); // Number intFormat for pretty printing of large number values and decimals: NumberFormat intFormat = NumberFormat.getInstance(JiveGlobals.getLocale()); DecimalFormat decFormat = new DecimalFormat("#,##0.00"); %> <fmt:message key="server.db_stats.title" /> <% // Enable refreshing if specified if (refresh >= 10) { %> <% } %>

<% if (showQueryStats) { %>

	<%= intFormat.format(ProfiledConnection.getQueryCount(ProfiledConnection.Type.select)) %>
	<%= intFormat.format(ProfiledConnection.getTotalQueryTime(ProfiledConnection.Type.select)) %>
	<%= decFormat.format(ProfiledConnection.getAverageQueryTime(ProfiledConnection.Type.select)) %>
	<%= decFormat.format(ProfiledConnection.getQueriesPerSecond(ProfiledConnection.Type.select)) %>
	<% ProfiledConnectionEntry[] list = ProfiledConnection.getSortedQueries(ProfiledConnection.Type.select, doSortByTime); if (list == null \|\| list.length < 1) { out.println(LocaleUtils.getLocalizedString("server.db_stats.no_queries")); } else { %>

<% out.println(""); out.println(""); out.println(""); out.println(""); for (int i = 0; i < ((list.length > 20) ? 20 : list.length); i++) { ProfiledConnectionEntry pce = list[i]; out.println(""); out.println(""); out.println(""); out.println(""); } out.println("

" + LocaleUtils.getLocalizedString("server.db_stats.query") + "	" + LocaleUtils.getLocalizedString("server.db_stats.count") + "	" + LocaleUtils.getLocalizedString("server.db_stats.time") + "	" + LocaleUtils.getLocalizedString("server.db_stats.average_time") + "
" + pce.sql + "	" + intFormat.format(pce.count) + "	" + intFormat.format(pce.totalTime) + "	" + intFormat.format(pce.totalTime/pce.count) + "

"); } %>

	<%= intFormat.format(ProfiledConnection.getQueryCount(ProfiledConnection.Type.insert)) %>
	<%= intFormat.format(ProfiledConnection.getTotalQueryTime(ProfiledConnection.Type.insert)) %>
	<%= decFormat.format(ProfiledConnection.getAverageQueryTime(ProfiledConnection.Type.insert)) %>
	<%= decFormat.format(ProfiledConnection.getQueriesPerSecond(ProfiledConnection.Type.insert)) %>
	<% list = ProfiledConnection.getSortedQueries(ProfiledConnection.Type.insert, doSortByTime); if (list == null \|\| list.length < 1) { out.println(LocaleUtils.getLocalizedString("server.db_stats.no_queries")); } else { %>

<% out.println(""); out.println(""); out.println(""); out.println(""); for (int i = 0; i < ((list.length > 10) ? 10 : list.length); i++) { ProfiledConnectionEntry pce = list[i]; out.println(""); out.println(""); out.println(""); out.println(""); } out.println("

" + LocaleUtils.getLocalizedString("server.db_stats.query") + "	" + LocaleUtils.getLocalizedString("server.db_stats.count") + "	" + LocaleUtils.getLocalizedString("server.db_stats.time") + "	" + LocaleUtils.getLocalizedString("server.db_stats.average_time") + "
" + pce.sql + "	" + intFormat.format(pce.count) + "	" + intFormat.format(pce.totalTime) + "	" + intFormat.format(pce.totalTime/pce.count) + "

"); } %>

	<%= intFormat.format(ProfiledConnection.getQueryCount(ProfiledConnection.Type.update)) %>
	<%= intFormat.format(ProfiledConnection.getTotalQueryTime(ProfiledConnection.Type.update)) %>
	<%= decFormat.format(ProfiledConnection.getAverageQueryTime(ProfiledConnection.Type.update)) %>
	<%= decFormat.format(ProfiledConnection.getQueriesPerSecond(ProfiledConnection.Type.update)) %>
	<% list = ProfiledConnection.getSortedQueries(ProfiledConnection.Type.update, doSortByTime); if (list == null \|\| list.length < 1) { out.println(LocaleUtils.getLocalizedString("server.db_stats.no_queries")); } else { %>

" + LocaleUtils.getLocalizedString("server.db_stats.query") + "	" + LocaleUtils.getLocalizedString("server.db_stats.count") + "	" + LocaleUtils.getLocalizedString("server.db_stats.time") + "	" + LocaleUtils.getLocalizedString("server.db_stats.average_time") + "
" + pce.sql + "	" + intFormat.format(pce.count) + "	" + intFormat.format(pce.totalTime) + "	" + intFormat.format(pce.totalTime/pce.count) + "

"); } %>

	<%= intFormat.format(ProfiledConnection.getQueryCount(ProfiledConnection.Type.delete)) %>
	<%= intFormat.format(ProfiledConnection.getTotalQueryTime(ProfiledConnection.Type.delete)) %>
	<%= decFormat.format(ProfiledConnection.getAverageQueryTime(ProfiledConnection.Type.delete)) %>
	<%= decFormat.format(ProfiledConnection.getQueriesPerSecond(ProfiledConnection.Type.delete)) %>
	<% list = ProfiledConnection.getSortedQueries(ProfiledConnection.Type.delete, doSortByTime); if (list == null \|\| list.length < 1) { out.println(LocaleUtils.getLocalizedString("server.db_stats.no_queries")); } else { %>

" + LocaleUtils.getLocalizedString("server.db_stats.query") + "	" + LocaleUtils.getLocalizedString("server.db_stats.count") + "	" + LocaleUtils.getLocalizedString("server.db_stats.time") + "	" + LocaleUtils.getLocalizedString("server.db_stats.average_time") + "
" + pce.sql + "	" + intFormat.format(pce.count) + "	" + intFormat.format(pce.totalTime) + "	" + intFormat.format(pce.totalTime/pce.count) + "

"); } %>

<% } %>