To use less command to vie the output of a mysql result you could use:

mysql> \P less


mysql> pager less

Then run something like:

mysql> show engine innodb status\G

In some cases you may need to search for something in specific for this grep could be used, for example:

mysql> \P grep -A7 "ROW OPERATIONS"
PAGER set to 'grep -A7 "ROW OPERATIONS"'

Then when running the command it will only return 7 lines after "ROW OPERATIONS"


To disable the pager type \n:

mysql> \n
Pager disabled.
Time: 0.000s