Interface SqlQueryMXBean

  • All Known Implementing Classes:
    SqlQueryMXBeanImpl

    @Deprecated
    public interface SqlQueryMXBean
    Deprecated.
    Temporary monitoring solution.
    An MX bean allowing to monitor and tune SQL queries.
    • Method Detail

      • getLongQueryWarningTimeout

        @MXBeanDescription("Timeout in milliseconds after which long query warning will be printed.")
        long getLongQueryWarningTimeout()
        Deprecated.
        Returns:
        Timeout in milliseconds after which long query warning will be printed.
      • setLongQueryWarningTimeout

        @MXBeanDescription("Sets timeout in milliseconds after which long query warning will be printed.")
        @MXBeanParametersNames("longQueryWarningTimeout")
        @MXBeanParametersDescriptions("Timeout in milliseconds after which long query warning will be printed.")
        void setLongQueryWarningTimeout​(@MXBeanParameter(name="longQueryWarningTimeout",description="Timeout in milliseconds after which long query warning will be printed.")
                                        long longQueryWarningTimeout)
        Deprecated.
        Sets timeout in milliseconds after which long query warning will be printed.
        Parameters:
        longQueryWarningTimeout - Timeout in milliseconds after which long query warning will be printed.
      • getLongQueryTimeoutMultiplier

        @MXBeanDescription("Long query timeout multiplier. The warning will be printed after: timeout, timeout * multiplier, timeout * multiplier * multiplier, etc. If the multiplier <= 1, the warning message is printed once.")
        int getLongQueryTimeoutMultiplier()
        Deprecated.
        Returns:
        Long query timeout multiplier.
      • setLongQueryTimeoutMultiplier

        @MXBeanDescription("Sets long query timeout multiplier. The warning will be printed after: timeout, timeout * multiplier, timeout * multiplier * multiplier, etc. If the multiplier <= 1, the warning message is printed once.")
        @MXBeanParametersNames("longQueryTimeoutMultiplier")
        @MXBeanParametersDescriptions("Long query timeout multiplier.")
        void setLongQueryTimeoutMultiplier​(int longQueryTimeoutMultiplier)
        Deprecated.
        Sets long query timeout multiplier. The warning will be printed after: - timeout; - timeout * multiplier; - timeout * multiplier * multiplier; - etc. If the multiplier <= 1, the warning message is printed once.
        Parameters:
        longQueryTimeoutMultiplier - Long query timeout multiplier.
      • getResultSetSizeThreshold

        @MXBeanDescription("Threshold for the number of rows of the result, when count of fetched rows is bigger than the thresholdwarning will be printed.")
        long getResultSetSizeThreshold()
        Deprecated.
        Returns:
        Threshold for the number of rows of the result, when count of fetched rows is bigger than the threshold warning will be printed.
      • setResultSetSizeThreshold

        @MXBeanDescription("Sets threshold for the number of rows of the result, when count of fetched rows is bigger than the threshold warning will be printed")
        @MXBeanParametersNames("rsSizeThreshold")
        @MXBeanParametersDescriptions("Threshold for the number of rows of the result, when count of fetched rows is bigger than the threshold warning will be printed.")
        void setResultSetSizeThreshold​(long rsSizeThreshold)
        Deprecated.
        Sets threshold result's row count, when count of fetched rows is bigger than the threshold warning will be printed.
        Parameters:
        rsSizeThreshold - Threshold result's row count, when count of fetched rows is bigger than the threshold warning will be printed.
      • getResultSetSizeThresholdMultiplier

        @MXBeanDescription("Gets result set size threshold multiplier. The warning will be printed when size of result set is bugger than: threshold, threshold * multiplier, threshold * multiplier * multiplier, etc. If the multiplier <= 1, the warning message is printed once during query execution and the next one on the query end.")
        int getResultSetSizeThresholdMultiplier()
        Deprecated.
        Gets result set size threshold multiplier. The warning will be printed after: - size of result set > threshold; - size of result set > threshold * multiplier; - size of result set > threshold * multiplier * multiplier; - etc. If the multiplier <= 1, the warning message is printed once during query execution and the next one on the query end.
        Returns:
        Result set size threshold multiplier.
      • setResultSetSizeThresholdMultiplier

        @MXBeanDescription("Sets result set size threshold multiplier. The warning will be printed when size of result set is bugger than: threshold, threshold * multiplier, threshold * multiplier * multiplier,etc. If the multiplier <= 1, the warning message is printed once.")
        @MXBeanParametersNames("rsSizeThresholdMultiplier")
        @MXBeanParametersDescriptions("TResult set size threshold multiplier.")
        void setResultSetSizeThresholdMultiplier​(int rsSizeThresholdMultiplier)
        Deprecated.
        Sets result set size threshold multiplier.
        Parameters:
        rsSizeThresholdMultiplier - Result set size threshold multiplier.