MySQL paging or scrolling

We can use the following to prevent query results from scrolling to the end of the results;

\P /usr/bin/less

or alternatively;

pager less -S

This will act like grepping a file to less (cat somefile | less)

\n or nopager will return to normal.

Additionally, we can use the \G at the end of a query to output results vertically, say we have too many columns. For example show slave status\G;