Bug #71207 Please, add MySQL sys schema to the official MySQL server distribution

• Submitted: 22 Dec 2013 18:26
• Modified: 3 Apr 2015 13:16
• Reporter: Valeriy Kravchuk
• Status: Closed
• Category: MySQL Server: Performance Schema
• Severity: S4 (Feature request)
• Version: 5.6+
• OS: Any
• CPU Architecture: Any
• Tags: ps_helper

[22 Dec 2013 18:26] Valeriy Kravchuk

Description:
ps_helper (http://www.markleith.co.uk/ps_helper/) is a great set of views and procedures that simplify use of PERFORMANCE_SCHEMA. 

As it is created and maintained by Oracle employee, I wonder why not to add it to the official distribution, as one of SQL scripts or, even better, as a standard database installed with mysql_install_db.

How to repeat:
Try to work with PERFORMANCE_SCHEMA without ps_helper or some custom set of views and stored routines on top of it. Make your own conclusions on how valuable the tools is, then start to wonder why it has to be downloaded and installed separately.

Suggested fix:
Add ps_helper to the official MySQL server distribution.

[22 Dec 2013 18:28] Valeriy Kravchuk

Surely MySQL manual then should cover ps_helper in details.

[10 Mar 2014 10:04] Mark Leith

Verifying, thanks for the feature request.

[8 Jan 2015 10:52] Mark Leith

Updated synopsis to reflect the new name of the old ps_helper project - now the sys schema project.

[3 Apr 2015 13:16] Paul DuBois

Noted in 5.7.7 changelog.

The MySQL sys schema is now installed by default during data
directory installation. This is a set of objects that provides
convenient access to data collected by the Performance Schema.

For upgrades, mysql_upgrade installs the sys schema if it is not
installed, and upgrades it to the current version otherwise. To
enable this behavior to be suppressed, mysql_upgrade now has a
--skip-sys-schema option.