Missing performance reports in MySQL Workbench

[Leo Lam]

Hi

I have just setup the performance schema (sys) in MySQL Workbench using the setup button in the Performance Reports page.

The setup seems completed.

I have my Performance Schema Setup stopwatch, but I dont have any report listed in the Performance Reports (blank page).

Is there any help to resolve the problem?

Best,

Leo

The following is the output of the script captured in MySQL Workbench.

================================================================================

Thread started
Thread started
Thread started
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\wb_admin_perfschema.py", line 127, in update_ui
self.owner.page_activated()
File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\wb_admin_perfschema.py", line 331, in page_activated
self.create_ui()
File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\wb_admin_perfschema_reports.py", line 470, in create_ui
while res.nextRow():
AttributeError: 'NoneType' object has no attribute 'nextRow'
The following views are not handled set(['waits_global_by_latency', 'x$user_summary_by_file_io_type', 'wait_classes_global_by_avg_latency', 'x$host_summary_by_statement_type', 'x$statements_with_full_table_scans', 'x$host_summary_by_stages', 'io_global_by_file_by_bytes', 'innodb_buffer_stats_by_schema', 'x$statements_with_sorting', 'x$ps_schema_table_statistics_io', 'io_global_by_wait_by_latency', 'processlist', 'statements_with_runtimes_in_95th_percentile', 'x$processlist', 'x$user_summary', 'user_summary_by_file_io_type', 'x$ps_digest_95th_percentile_by_avg_us', 'host_summary', 'io_global_by_wait_by_bytes', 'schema_index_statistics', 'schema_table_statistics', 'io_global_by_file_by_latency', 'user_summary_by_stages', 'ps_check_lost_instrumentation', 'x$user_summary_by_stages', 'innodb_buffer_stats_by_table', 'statement_analysis', 'user_summary_by_file_io', 'latest_file_io', 'x$ps_digest_avg_latency_distribution', 'x$user_summary_by_statement_type', 'user_summary_by_statement_latency', 'host_summary_by_file_io_type', 'x$statements_with_temp_tables', 'x$latest_file_io', 'x$host_summary_by_statement_latency', 'x$user_summary_by_file_io', 'user_summary_by_statement_type', 'host_summary_by_statement_type', 'x$waits_by_host_by_latency', 'x$user_summary_by_statement_latency', 'host_summary_by_stages', 'x$host_summary_by_file_io', 'host_summary_by_statement_latency', 'waits_by_user_by_latency', 'schema_table_statistics_with_buffer', 'user_summary', 'host_summary_by_file_io', 'wait_classes_global_by_latency', 'waits_by_host_by_latency', 'x$host_summary', 'x$statements_with_errors_or_warnings', 'x$host_summary_by_file_io_type', 'io_by_thread_by_latency'])
default
disabled
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\wb_admin_perfschema_instrumentation.py", line 122, in mouse_click
self.callback(self.hovering_state)
File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\wb_admin_perfschema_instrumentation.py", line 248, in change_instrumentation
self.owner.rebuild_ui(False)
File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\wb_admin_perfschema_instrumentation.py", line 1447, in rebuild_ui
self.data_collection = SetupDataCollection(self, self.config_data.sections['consumers'], self.config_data.variables)
File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\wb_admin_perfschema_instrumentation.py", line 443, in __init__
self.create_ui()
File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\wb_admin_perfschema_instrumentation.py", line 587, in create_ui
self.global_check = self.create_dc_checkbox(self, self.get_var_name_and_label('global_instrumentation', -1))
File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\wb_admin_perfschema_instrumentation.py", line 465, in create_dc_checkbox
checkbox.set_active(self._data[var_lbl[0]].enabled)
KeyError: 'global_instrumentation'
["\n UPDATE performance_schema.setup_instruments\n SET ENABLED = IF(NAME IN ('wait/lock/table/sql/handler','idle') OR NAME LIKE 'wait/io/file/%' OR NAME LIKE 'wait/io/table/%' OR NAME LIKE 'statement/%', 'YES', 'NO'),\n TIMED = ENABLED\n ", "\n UPDATE performance_schema.setup_consumers\n SET ENABLED = IF(NAME IN ('events_statements_current','global_instrumentation','thread_instrumentation','statements_digest'), 'YES', 'NO')\n "]
default
fully
["\n UPDATE performance_schema.setup_instruments\n SET ENABLED = IF(NAME IN ('wait/lock/table/sql/handler','idle') OR NAME LIKE 'wait/io/file/%' OR NAME LIKE 'wait/io/table/%' OR NAME LIKE 'statement/%', 'YES', 'NO'),\n TIMED = ENABLED\n ", "\n UPDATE performance_schema.setup_consumers\n SET ENABLED = IF(NAME IN ('events_statements_current','global_instrumentation','thread_instrumentation','statements_digest'), 'YES', 'NO')\n "]
default
default
default
default
disabled
Traceback (most recent call last):
File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\wb_admin_perfschema_instrumentation.py", line 122, in mouse_click
self.callback(self.hovering_state)
File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\wb_admin_perfschema_instrumentation.py", line 248, in change_instrumentation
self.owner.rebuild_ui(False)
File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\wb_admin_perfschema_instrumentation.py", line 1447, in rebuild_ui
self.data_collection = SetupDataCollection(self, self.config_data.sections['consumers'], self.config_data.variables)
File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\wb_admin_perfschema_instrumentation.py", line 443, in __init__
self.create_ui()
File "C:\Program Files\MySQL\MySQL Workbench 6.2 CE\modules\wb_admin_perfschema_instrumentation.py", line 564, in create_ui
if self.owner.target_version.is_supported_mysql_version_at_least(5, 6, 3):
AttributeError: 'NoneType' object has no attribute 'is_supported_mysql_version_at_least'