Bug #73787 Dashboard does not work when InnoDB engine is disabled
Submitted: 2 Sep 2014 23:26 Modified: 3 Sep 2014 4:21
Reporter: Dimitriy A Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S3 (Non-critical)
Version:6.1.7.11891 build 1788 OS:Any
Assigned to: CPU Architecture:Any
Tags: dashboard

[2 Sep 2014 23:26] Dimitriy A
Description:
When going to the Performance Dashboard in MySQL Workbench, I get the following error message:
"An unhandled exception occured ('Innodb_buffer_pool_read_requests'). Please refer to the log files for details."

Here is a snippet from the log file:
15:11:23 [ERR][wb_admin_main.py:tab_changed:202]: Unhandled exception in Admin for <wb_admin_performance_dashboard.WbAdminDashboard; proxy of <Swig Object of type 'mforms::Box *' at 0x0C0CF980> >: Traceback (most recent call last):
  File "C:\Program Files\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_main.py", line 199, in tab_changed
    panel.page_activated()
  File "C:\Program Files\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_utils.py", line 170, in page_activated
    self.create_ui()
  File "C:\Program Files\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_performance_dashboard.py", line 575, in create_ui
    self.refresh()
  File "C:\Program Files\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_performance_dashboard.py", line 600, in refresh
    w.process(status_variables, timestamp)
  File "C:\Program Files\MySQL\MySQL Workbench 6.1 CE\workbench\graphics\charting.py", line 281, in process
    self.set(self.calc.handle(data, timestamp))
  File "C:\Program Files\MySQL\MySQL Workbench 6.1 CE\modules\wb_admin_performance_dashboard.py", line 212, in handle
    value = eval(self.expr % values)
KeyError: 'Innodb_buffer_pool_read_requests'

How to repeat:
Connect to a database, which has InnoDB engine disabled along with all related InnoDB plugins.

Suggested fix:
Allow to use the dashboard with MyISAM databases or provide an appropriate error message.
[3 Sep 2014 4:21] Alfredo Kojima
InnoDB is a requirement for the dashboard, as most of the stats displayed there are InnoDB specific.