sys Schema Views The total time waiting for locks by timed occurrences of the statement. The total number of rows returned by occurrences of the statement. The average number of rows returned per occurrence of the statement. The total number of rows read from storage engines by occurrences of the statement. The average number of rows read from storage engines per occurrence of the statement. The total number of rows affected by occurrences of the statement. The average number of rows affected per occurrence of the statement. The total number of internal in-memory temporary tables created by occurrences of the statement. The total number of internal on-disk temporary tables created by occurrences of the statement. The total number of rows sorted by occurrences of the statement. The total number of sort merge passes by occurrences of the statement. The statement digest. The time at which the statement was first seen. The time at which the statement was most recently seen. These views display normalized statements that have produced errors or warnings. By default, rows are sorted by descending error and warning counts. 28.4.3.36 The statements_with_errors_or_warnings and x $statements_with_errors_or_warnings Views 5170 • last_seen • first_seen • digest • sort_merge_passes • rows_sorted • tmp_disk_tables • tmp_tables • rows_affected_avg • rows_affected • rows_examined_avg • rows_examined • rows_sent_avg • rows_sent