Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

3 Answers 3

up vote 2 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 at 15:23

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

share|improve this answer

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 at 15:20

Your Answer

 
discard

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.