sys Schema Object Index View Name Description statements_with_errors_or_warnings ,  x $statements_with_errors_or_warnings Statements that have produced errors or warnings statements_with_full_table_scans ,  x $statements_with_full_table_scans Statements that have done full table scans statements_with_runtimes_in_95th_percentile , x $statements_with_runtimes_in_95th_percentile Statements with highest average runtime statements_with_sorting ,  x $statements_with_sorting Statements that performed sorts statements_with_temp_tables ,  x $statements_with_temp_tables Statements that used temporary tables user_summary ,  x$user_summary User statement and connection activity user_summary_by_file_io ,  x $user_summary_by_file_io File I/O, grouped by user user_summary_by_file_io_type ,  x $user_summary_by_file_io_type File I/O, grouped by user and event user_summary_by_stages ,  x $user_summary_by_stages Stage events, grouped by user user_summary_by_statement_latency ,  x $user_summary_by_statement_latency Statement statistics, grouped by user user_summary_by_statement_type ,  x $user_summary_by_statement_type Statements executed, grouped by user and statement version Current  sys  schema and MySQL server versions wait_classes_global_by_avg_latency ,  x $wait_classes_global_by_avg_latency Wait class average latency, grouped by event class wait_classes_global_by_latency ,  x $wait_classes_global_by_latency Wait class total latency, grouped by event class waits_by_host_by_latency ,  x $waits_by_host_by_latency Wait events, grouped by host and event waits_by_user_by_latency ,  x $waits_by_user_by_latency Wait events, grouped by user and event waits_global_by_latency ,  x $waits_global_by_latency Wait events, grouped by event x$ps_digest_95th_percentile_by_avg_us Helper view for 95th-percentile views x$ps_digest_avg_latency_distribution Helper view for 95th-percentile views x$ps_schema_table_statistics_io Helper view for table-statistics views x$schema_flattened_keys Helper view for  schema_redundant_indexes Table 28.3 sys Schema Stored Procedures Procedure Name Description create_synonym_db() Create synonym for schema diagnostics() Collect system diagnostic information execute_prepared_stmt() Execute prepared statement 5136