Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 3 down vote accepted

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
share|improve this answer
Unnecessarily cumbersome way to do it. Better follow answer of Roman or Everaldo – Christopher Lörken May 27 '14 at 15:23

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

share|improve this answer
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 May 27 '14 at 15:20

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

share|improve this answer
Thanks! ⌥⌘⏎ for Mac – corretge Dec 5 '14 at 9:10

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.