\G like vertical output in MySQL Workbench for show engine innodb status

show engine innodb status; is unusable in MySQL Workbench, as shown here:

=====================================120329 12:39:32 INNODB MONITOR OUTPUT=====================================Per second averages calculated from the last 17 seconds-----------------BACKGROUND THREAD-----------------srv_master_thread loops: 192438...

However show engine innodb status \G is great on the mysql command line client.

Is there any \G equivalent on MySQL workbench or better way to get this information?

KCD

Posted 2012-03-28T23:56:23.973

Reputation: 390

Answers

Once you execute show engine innodb status;

float the mouse over the Status field
right click for a popup menu
click 'Open Value in Viewer'
When the viewer opens up, you can
- Scroll through the Viewer
- Click Save Button in the lower left corner to save to a Text File

RolandoMySQLDBA

Posted 2012-03-28T23:56:23.973

Reputation: 2 675

3Unnecessarily cumbersome way to do it. Better follow answer of Roman or Everaldo – Christopher Lörken – 2014-05-27T15:23:44.127

Or you can just press Ctrl+Alt+Enter or choose 'Query → 'Execute Current Statement (Vertical output)'

Roman

Posted 2012-03-28T23:56:23.973

Reputation: 51

On MySQL Workbench 6 you can use Query -> Execute Current Statement (Vertical Text Output) like I explained in MySQL Workbench Vertical Output (Portuguese). You can also use keyboard shortcut Alt+Cmd+Enter (on Mac).

Everaldo Canuto

Posted 2012-03-28T23:56:23.973

Reputation: 21

This should be the accepted answer. Run query with Alt+Cmd+Enter on Mac, or Ctrl+Alt+Enter on other systems and you see everything as with \G – Christopher Lörken – 2014-05-27T15:20:25.800