How mysql/mysql-sys works
MySQL sys schema is an administrator-facing collection of SQL views, functions, and procedures for inspecting database usage. The principal workflow is an administrator querying a sys view for formatted summaries of Performance Schema and Information Schema data. Other documented capabilities include Performance Schema setup and tracing, statement analysis and diagnostics, and persistent configuration. The tree supports grouping these modules by domain, but no source excerpts were provided, so undocumented calls and data dependencies are omitted; edges cite README statements only.
Main entry points: sys_config.sql sys_config · p_s Performance summaries · i_s Schema and InnoDB views · diagnostics.sql Diagnostics
Components 16
Usage reporting
- Performance summaries
views/p_s - Schema and InnoDB views
views/i_s - Version view
views/version.sql
Performance management
- Instrumentation setup
procedures - Statement and thread tracing
procedures - Performance helpers
functions
Diagnostics and analysis
- Statement analyzer
procedures/statement_performance_analyzer.sql - Diagnostics
procedures/diagnostics.sql
Configuration and helpers
- sys_config
tables/sys_config.sql - Config defaults
tables/sys_config_data.sql - Config user triggers
triggers - Configuration lookup
functions/sys_get_config.sql - Formatting and utility functions
functions
Other components
- Administrator
- Performance Schema
- Information Schema
Connections 16
- Administrator → Performance summaries: queries
README.md - Administrator → Schema and InnoDB views: queries
README.md - Administrator → Version view: queries
README.md - Administrator → Instrumentation setup: runs
README.md - Administrator → Statement and thread tracing: runs
README.md - Administrator → Statement analyzer: runs
README.md - Administrator → Diagnostics: runs
README.md - Administrator → Performance helpers: uses
README.md - Administrator → Formatting and utility functions: uses
README.md - Administrator → sys_config: configures
README.md - Configuration lookup → sys_config: reads
README.md - Config user triggers → sys_config: maintains user
README.md - Diagnostics → Information Schema: may scan
README.md - Performance summaries → Performance Schema: summarizes
README.md - Schema and InnoDB views → Information Schema: reports
README.md - sys_config → Config defaults: persists options
README.md