In MySQL 8.0.0, the Performance Schema can now instrument server errors. There are 5 new summary tables introduced:
1 2 3 4 5 6 7 8 9 10 11 |
mysql> show tables like "%by_error%"; +-------------------------------------------+ | Tables_in_performance_schema (%by_error%) | +-------------------------------------------+ | events_errors_summary_by_account_by_error | | events_errors_summary_by_host_by_error | | events_errors_summary_by_thread_by_error | | events_errors_summary_by_user_by_error | | events_errors_summary_global_by_error | +-------------------------------------------+ 5 rows in set (0.02 sec) |
As names suggest, statistics of errors in these tables are aggregated by error.…