Skip to content
This repository was archived by the owner on Aug 28, 2024. It is now read-only.

Conversation

@JesperWisborgKrogh
Copy link
Contributor

Adds two views: metrics and metrics_56. The difference betweem the metrics and the metrics_56 views are whether the global status is taken from performance_schema.global_status instead of
from the Information Schema.Use the metrics view if the MySQL version is 5.7.6 or later and show_compatibility_56 = OFF. Otherwise use metrics_56.
See also https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_show_compatibility_56

The views provide a union of the following information:

  • performance_schema.global_status (information_schema.GLOBAL_STATUS for metrics_56)
  • information_schema.INNODB_METRICS
  • Performance Schema global memory usage information
  • Current time

Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

It would be nice to explain in what case PARTIAL can be returned (looks like "a subset of memory instruments are enabled in Performance schema").

@MarkLeith
Copy link
Member

Nice, couple of small clean up things and good to go.

One related, but not stopping comment - it seems like the "yes/no/partial" enablement checking could be extracted out to a function, and could be generally useful in the future for other wait classes etc. too perhaps.

@JesperWisborgKrogh
Copy link
Contributor Author

Fixed the year in the copyright headers and adding description of what PARTIAL means for the Enabled column.

I like the idea of a function to calculate the yes/no/partial enablement, but will leave that for later.

MarkLeith added a commit that referenced this pull request Jun 3, 2015
@MarkLeith MarkLeith merged commit 9ff4cf6 into mysql:development Jun 3, 2015
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

2 participants