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

Question

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?

score 11 · Answer 1 · edited Apr 18 '14 at 12:37

11

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

edited Apr 18 '14 at 12:37

Sathyajith Bhat

62,374

answered Apr 18 '14 at 11:08

Roman

111

score 6 · Answer 2 · answered Sep 26 '13 at 16:16

6

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).

answered Sep 26 '13 at 16:16

Everaldo Canuto

161
1
1

score 4 · Accepted Answer · answered Apr 13 '12 at 17:31

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

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

3 Answers3