Database Management
MySQL
Subjective
Oct 01, 2025
What are MySQL performance schema and sys schema?
Detailed Explanation
Performance Schema:
• Runtime performance monitoring
• Low-level instrumentation data
• Memory, I/O, lock statistics
Sys Schema:
• User-friendly views of Performance Schema
• Pre-built queries for common tasks
• Easier performance analysis
Example:
SELECT * FROM sys.schema_table_statistics;
SELECT * FROM performance_schema.events_waits_summary_global_by_event_name;
Discussion (0)
No comments yet. Be the first to share your thoughts!
Share Your Thoughts