Permalink
Commits on Jul 7, 2016
Commits on Jul 1, 2016
Commits on Jun 21, 2016
  1. Bug #23621189 PS_TRACE_STATEMENT_DIGEST FAILS AT EXPLAIN OR NO FOUND …

    …QUERIES
    
    The ps_trace_statement_digest() procedure did not handle some conditions:
    
      * Queries (such as SHOW) that does not support EXPLAIN
      * Queries where one or more tables is not fully qualified as the table
        cannot be found when attempting to EXPLAIN it
      * When no queries with the specified digest is found during the
        monitored period
    
    These issues have been fixed and a new test case,
    sysschema.pr_ps_trace_statement_digest, has been added.
    JesperWisborgKrogh committed Jun 21, 2016
  2. Bug 22988461 - INCORRECT CALCULATION FOR PAGES_HASHED, PAGES_OLD

    Remove the check of wether the percentage of old pages found in the sys schema
    views is less that @@global.innodb_old_blocks_pct as it's too unstable due to
    randomness of the data.
    JesperWisborgKrogh committed Jun 21, 2016
Commits on Jun 15, 2016
  1. Update main LICENSE copyright year, fix the github repository pointer…

    … for the mysql_sys_schema.sql file generation script.
    MarkLeith committed Jun 15, 2016
Commits on Jun 3, 2016
  1. Wrap the quote_identifier function body within BEGIN .. END, to ensur…

    …e that it is dumped/reloaded consistently (without this, on reload within the mysqldump test, the trailing semi-colon from the function body was removed on reload otherwise).
    MarkLeith committed Jun 3, 2016
Commits on Jun 1, 2016
  1. Bug #23290879 SYSSCHEMA.PR_STATEMENT_PERFORMANCE_ANALYZER TEST FAILIN…

    …G ON PB2 ON WINDOW
    
    Disable the test on Windows only
    MarkLeith committed Jun 1, 2016
Commits on May 26, 2016
  1. Bug #21512106 FORMAT_PATH() DOES NOT CONSIDER DIRECTORY BOUNDARIES

    Properly check directory boundaries on all variables now. If the variable does not include a path separator at the end of it, add one for comparison.
    
    NOTE: This stops the case of converting Windows paths to /, and now correctly shows \ for Windows hosts.
    
    Also added replacement for the basedir variable, and added a proper unit test that validates all variables are parsed correctly (though this requires disabling the test on Windows, as the path separator is now correctly shown as \ on that host too now).
    MarkLeith committed May 26, 2016
Commits on May 25, 2016
  1. Bug #23335880 - PS_SETUP_SHOW_ENABLED AND PS_SETUP_SHOW_DISABLED AND …

    …COMPANY ISSUES
    
    Fixes several issues in the six stored procedures to show the enabled or disabled
    Performance Schema setup:
    
      * Enabled and disabled accounts are shown as host@user
      * Disabled users in ps_setup_show_disabled are called enabled_users
      * There is no explicit ordering; this can cause random changes in the output
        which also affects testing, e.g. the sysschem.pr_ps_setup_show_enabled test
        is randomly failing
      * Disabled users is only available for 5.7.6+
      * setup_actors are not filtered either (all rows returned whether the actor is
        enabled or disabled)
    
    Also added several tests and improved the existing.
    JesperWisborgKrogh committed May 24, 2016
  2. Bug #22011361 - SYS.CREATE_SYNONYM_DB() DOES NOT LIKE RESERVED-WORD D…

    …B NAMES
    
    Fix so the sys.create_synonym_db() procedure can handle schemas and table
    name that are reserved names or contains one or more `s (backticks).
    
    This also adds the sys.quote_identifier() function which is now used by
    sys.create_synonym_db() to ensure the schema and table names are quoted
    correctly.
    JesperWisborgKrogh committed May 23, 2016
Commits on May 23, 2016
  1. Bug #22988461 - INCORRECT CALCULATION FOR PAGES_HASHED, PAGES_OLD

    Post push updating the year in the copyright header.
    JesperWisborgKrogh committed May 23, 2016
  2. Bug #22066096 PS_SETUP_SHOW_ENABLED() SHOWS TOO MANY OBJECTS

    Post push test stabilisation fix. Order the output for thread info by thread name, to make the output more deterministic in test. Also fix a bug in the output column name within the companion ps_setup_show_disabled routine.
    MarkLeith committed May 23, 2016
Commits on May 19, 2016
  1. Bug 22988461 - INCORRECT CALCULATION FOR PAGES_HASHED, PAGES_OLD

    The views:
    
       * innodb_buffer_stats_by_schema
       * innodb_buffer_stats_by_table
    
    used COUNT(IF(...), 1, 0) to sum up the number of hashed and old pages.
    However COUNT(0) will increment the counter, so the counts have been changed
    to COUNT(IF(...), 1, NULL) as NULL will not increment the counter. This solution
    is preferred over SUM(IF(...), 1, 0) as SUM returns a decimal instead of an
    integer.
    
    Also added test cases to ensure the percentage of old pages found is less
    than @@global.innodb_old_blocks_pct as a check that not all pages are included
    in the count.
    JesperWisborgKrogh committed May 17, 2016
Commits on May 18, 2016
  1. Bug #22848110 MAX_LATENCY IS NOT CORRECT FOR SYS.HOST_SUMMARY_BY_STAT…

    …EMENT_LATENCY VIEW
    
    Fix test and update metadata (decimal(42,0) -> bigint(20) unsigned type change) in README.
    MarkLeith committed May 18, 2016
Commits on May 17, 2016
  1. Bug #22848110 MAX_LATENCY IS NOT CORRECT FOR SYS.HOST_SUMMARY_BY_STAT…

    …EMENT_LATENCY VIEW
    
    Use MAX() rather than SUM() for the max_latency columns within host_summary_by_statement_latency / x$host_summary_by_statement_latency.
    MarkLeith committed May 17, 2016
  2. Bug #22066096 PS_SETUP_SHOW_ENABLED() SHOWS TOO MANY OBJECTS

    Added missing filter for objects that are explicitly enabled.
    MarkLeith committed May 17, 2016
Commits on May 16, 2016
  1. Bug #21970078 SYSSCHEMA.V_HOST_SUMMARY FAILS DUE TO DIVISION BY 0

    Protect from division by 0 in the same way as the user_summary view currently uses
    MarkLeith committed May 16, 2016
  2. Bug #21970078 SYSSCHEMA.V_HOST_SUMMARY FAILS DUE TO DIVISION BY 0

    Protect from division by 0 in the same way as the user_summary view currently uses
    MarkLeith committed May 16, 2016
Commits on May 12, 2016
  1. Sync the changes made for WL# 8196: TLS1.2 support (adding the Tls_ve…

    …rsion column to the output of the slave_master_info table within the diagnostics procedure) back to this tree.
    MarkLeith committed May 12, 2016
Commits on May 9, 2016
  1. Bug#21663578 INSTABILITY IN SYSSCHEMA.V_SCHEMA_TABLES_WITH_FULL_TABLE…

    …_SCANS
    
    Added wait conditions for the underlying performance schema data to be updated.
    MarkLeith committed May 9, 2016
Commits on Nov 10, 2015
  1. Merge pull request #97 from JesperWisborgKrogh/dev/20151102_pr_statem…

    …ent_performance_analyzer1
    
    Bug 21845866: Changing the pr_statement_performance_analyzer test to …
    MarkLeith committed Nov 10, 2015
Commits on Nov 6, 2015
  1. Merge pull request #96 from JesperWisborgKrogh/dev/20151101_diagnostics

    Fixing documentation for the diagnostics() procedure. Setting in_auto…
    MarkLeith committed Nov 6, 2015
Commits on Nov 1, 2015
  1. Bug 21845866: Changing the pr_statement_performance_analyzer test to …

    …reduce the possibility of the Performance Schema data not being available when it's assigned to the variables used in replace_result.
    JesperWisborgKrogh committed Nov 1, 2015
  2. Fixing documentation for the diagnostics() procedure. Setting in_auto…

    …_config does not add a requirement to be SUPER; that is always required to avoid replicating temporary tables
    JesperWisborgKrogh committed Nov 1, 2015
Commits on Oct 19, 2015
  1. Fix typo.

    MarkLeith committed Oct 19, 2015
  2. Merge pull request #95 from JesperWisborgKrogh/dev/20151019_docs

    Dev/20151019 docs
    MarkLeith committed Oct 19, 2015
  3. Update the documentation for ps_setup_save() to include information a…

    …bout the parameter specifying the timeout
    JesperWisborgKrogh committed Oct 19, 2015