Performance Schema

GPTKB entity

Statements (96)
Predicate Object
gptkbp:instanceOf MySQL feature
gptkbp:canBeDisabled at server startup
gptkbp:canQuery SELECT statements
gptkbp:dataSource SQL tables
gptkbp:documentedIn https://dev.mysql.com/doc/refman/8.0/en/performance-schema.html
gptkbp:hasFeature at server startup
https://www.w3.org/2000/01/rdf-schema#label Performance Schema
gptkbp:introducedIn gptkb:MySQL_5.5
gptkbp:isConfigurableVia my.cnf
server variables
gptkbp:notableCollection threads
hosts
users
memory usage
accounts
user statistics
stage events
file summary
wait events
connection statistics
events stages current
events stages history
events stages summary
events stages summary by account
events stages summary by host
events stages summary by program
events stages summary by thread
events stages summary by user
events statements current
events statements history
events statements summary
events statements summary by account
events statements summary by host
events statements summary by program
events statements summary by thread
events statements summary by user
events transactions current
events transactions history
events transactions summary
events transactions summary by account
events transactions summary by host
events transactions summary by program
events transactions summary by thread
events transactions summary by user
events waits current
events waits history
events waits summary
events waits summary by account
events waits summary by host
events waits summary by program
events waits summary by thread
events waits summary by user
file I/O statistics
host statistics
memory summary
metadata lock information
mutex statistics
replication statistics
setup actors
setup consumers
setup instruments
setup objects
setup timers
stage timing
statement digest
statement events
statement histogram
stored program statistics
table I/O statistics
table lock statistics
table summary
thread statistics
transaction events
gptkbp:partOf gptkb:MySQL
gptkbp:provides low-level performance metrics
gptkbp:purpose monitoring MySQL server performance
gptkbp:storage performance_schema database
gptkbp:supportedBy gptkb:MySQL_Enterprise_Monitor
gptkb:Zabbix
gptkb:MySQL_Workbench
gptkb:phpMyAdmin
gptkb:Percona_Monitoring_and_Management
Grafana dashboards
Prometheus exporters
other third-party tools
gptkbp:usedBy gptkb:DBAs
developers
monitoring tools
performance analysts
gptkbp:usedFor identifying bottlenecks
troubleshooting performance issues
analyzing query execution
auditing server activity
monitoring resource usage
gptkbp:bfsParent gptkb:MySQL_5.5_and_later
gptkbp:bfsLayer 7