Provides a way to determine where the database is spending the most time
replacement for SHOW FULL PROCESSLIST
statistics about classes of queries over time
has aggregate data for wait events grouped by the event name
related to the wait/io/table/sql/handler in the events_waits_summary_global_by_event_name table. These provide information about the amount of time spent per table split by the time spent for reads, writes, fetch, insert, update, or delete.
shows how much time is spent on actual file I/O and how much data is accessed. very useful for determining where time is spent doing disk I/O and which files have the most data accesses on disk.
Using performance_schema to monitor DDL related changes
Using performance_schema to monitor replication metrics
Enabling performance schema on GCP CloudSQL
Performance schema is not enabled by default on CloudSQL. This needs to be enabled but it cannot be enabled via the web console and instead needs to be done with gcloud.
When setting the flags remember to set all the existing flags on the instance at the same time like so
gcloud sql instances patch [INSTANCE_NAME] --database-flags general_log=on,skip_show_database=on,wait_timeout=200000,performance_schema=on