SQL_STATE: 70100  SUM_ERROR_RAISED: 1 SUM_ERROR_HANDLED: 0 FIRST_SEEN: 2016-06-28 11:01:49 LAST_SEEN: 2016-06-28 11:01:49 

Each error summary table has one or more grouping columns to indicate how the table aggregates errors: 

• events_errors_summary_by_account_by_error  has USER , HOST , and ERROR_NUMBER  columns. Each row summarizes events for a given account (user and host combination) and error. 

• events_errors_summary_by_host_by_error  has HOST  and ERROR_NUMBER  columns. Each row summarizes events for a given host and error. 

• events_errors_summary_by_thread_by_error  has THREAD_ID  and ERROR_NUMBER  columns. Each row summarizes events for a given thread and error. 

• events_errors_summary_by_user_by_error  has USER  and ERROR_NUMBER  columns. Each row summarizes events for a given user and error. 

• events_errors_summary_global_by_error  has an ERROR_NUMBER  column. Each row summarizes events for a given error. 

Each error summary table has these summary columns containing aggregated values: 

• SUM_ERROR_RAISED 

This column aggregates the number of times the error occurred. 

• SUM_ERROR_HANDLED 

This column aggregates the number of times the error was handled by an SQL exception handler. 

• FIRST_SEEN , LAST_SEEN 

Timestamp indicating when the error was first seen and most recently seen. 

A NULL  row in each error summary table is used to aggregate statistics for all errors that lie out of range of the instrumented errors. For example, if MySQL Server errors lie in the range from M  to N  and an error is raised with number Q  not in that range, the error is aggregated in the NULL  row. The NULL  row is the row with ERROR_NUMBER=0 , ERROR_NAME=NULL , and SQLSTATE=NULL . 

The error summary tables have these indexes: 

• events_errors_summary_by_account_by_error : 

•Primary key on ( USER , HOST , ERROR_NUMBER ) 

• events_errors_summary_by_host_by_error : 

•Primary key on ( HOST , ERROR_NUMBER ) 

• events_errors_summary_by_thread_by_error : 

•Primary key on ( THREAD_ID , ERROR_NUMBER ) 

• events_errors_summary_by_user_by_error : 

•Primary key on ( USER , ERROR_NUMBER ) 

