Debian Codegraph @

mysql-test/suite/perfschema/r/start_server_no_errors.result

raw
1 SHOW GLOBAL VARIABLES LIKE "performance_schema_error_size";
2 Variable_name Value
3 performance_schema_error_size 0
4 TRUNCATE TABLE performance_schema.events_errors_summary_global_by_error;
5 TRUNCATE TABLE performance_schema.events_errors_summary_by_thread_by_error;
6 TRUNCATE TABLE performance_schema.events_errors_summary_by_user_by_error;
7 TRUNCATE TABLE performance_schema.events_errors_summary_by_host_by_error;
8 TRUNCATE TABLE performance_schema.events_errors_summary_by_account_by_error;
9 USE no_db;
10 ERROR 42000: Unknown database 'no_db'
11 SELECT * FROM no_table;
12 ERROR 42S02: Table 'test.no_table' doesn't exist
13 ####################################
14 # Fetching Errors' Stastics
15 ####################################
16 SELECT * FROM performance_schema.events_errors_summary_global_by_error WHERE SUM_ERROR_HANDLED>0 OR SUM_ERROR_RAISED>0;
17 ERROR_NUMBER ERROR_NAME SQL_STATE SUM_ERROR_RAISED SUM_ERROR_HANDLED FIRST_SEEN LAST_SEEN
18 SELECT * FROM performance_schema.events_errors_summary_by_thread_by_error WHERE SUM_ERROR_HANDLED>0 OR SUM_ERROR_RAISED>0;
19 THREAD_ID ERROR_NUMBER ERROR_NAME SQL_STATE SUM_ERROR_RAISED SUM_ERROR_HANDLED FIRST_SEEN LAST_SEEN
20 SELECT * FROM performance_schema.events_errors_summary_by_user_by_error WHERE SUM_ERROR_HANDLED>0 OR SUM_ERROR_RAISED>0;
21 USER ERROR_NUMBER ERROR_NAME SQL_STATE SUM_ERROR_RAISED SUM_ERROR_HANDLED FIRST_SEEN LAST_SEEN
22 SELECT * FROM performance_schema.events_errors_summary_by_host_by_error WHERE SUM_ERROR_HANDLED>0 OR SUM_ERROR_RAISED>0;
23 HOST ERROR_NUMBER ERROR_NAME SQL_STATE SUM_ERROR_RAISED SUM_ERROR_HANDLED FIRST_SEEN LAST_SEEN
24 SELECT * FROM performance_schema.events_errors_summary_by_account_by_error WHERE SUM_ERROR_HANDLED>0 OR SUM_ERROR_RAISED>0;
25 USER HOST ERROR_NUMBER ERROR_NAME SQL_STATE SUM_ERROR_RAISED SUM_ERROR_HANDLED FIRST_SEEN LAST_SEEN