Ask a question that no one can answer today.

[zisain]

It seems that all the secondary development based on Debian system cannot use shift+pageup/pagedown in the TTY interface to turn pages up and down, including the current pve7.2. Who knows why? But all RedHat based products can turn pages, CentOS, Oracle Linux, rockylinux, almalinux

reason:
Sometimes, when operating the database in the Intranet environment, the page cannot be turned, and there is no graphical interface, which will bring great inconvenience to the operation

 

[t.lamprecht]

It seems that all the secondary development based on Debian system cannot use shift+pageup/pagedown in the TTY interface to turn pages up and down, including the current pve7.2. Who knows why?

The reason is that the soft scrollback functionality got removed for the 5.9 kernel due to bugs that couldn't be easily fixed as that code and special cases required were quite "nasty".

https://git.kernel.org/pub/scm/linu.../?id=50145474f6ef4a9c19205b173da6264a644c7489
https://www.phoronix.com/scan.php?page=news_item&px=Linux-5.9-Drops-Soft-Scrollback

But all RedHat based products can turn pages, CentOS, Oracle Linux, rockylinux, almalinux

Those are either still using an old(er) kernel base version as 5.9, or patched something in themselves again. Check their kernel package source code if you want to know for sure.

Sometimes, when operating the database in the Intranet environment, the page cannot be turned, and there is no graphical interface, which will bring great inconvenience to the operation

I recommend using screen or even more powerfull/modern tmux to get that functionality in user space (where it's much simpler to handle than kernel directly). FWIW, those tools can do also much more than just scrollback, e.g., multiple panes without re-login on another TTY.

https://github.com/tmux/tmux/wiki/Getting-Started

With tmux you can get into the scroll back/copy mode by using CTRL + B (default tmux control prefix) and then PG_UP

 

[zisain]

The reason is that the soft scrollback functionality got removed for the 5.9 kernel due to bugs that couldn't be easily fixed as that code and special cases required were quite "nasty".

https://git.kernel.org/pub/scm/linu.../?id=50145474f6ef4a9c19205b173da6264a644c7489
https://www.phoronix.com/scan.php?page=news_item&px=Linux-5.9-Drops-Soft-Scrollback


Those are either still using an old(er) kernel base version as 5.9, or patched something in themselves again. Check their kernel package source code if you want to know for sure.


I recommend using screen or even more powerfull/modern tmux to get that functionality in user space (where it's much simpler to handle than kernel directly). FWIW, those tools can do also much more than just scrollback, e.g., multiple panes without re-login on another TTY.

https://github.com/tmux/tmux/wiki/Getting-Started

With tmux you can get into the scroll back/copy mode by using CTRL + B (default tmux control prefix) and then PG_UP

Thank my friend very much. This question has been bothering me since debian10. Now I finally have a detailed answer.
In fact, my working environment is a little special. The server is in a completely isolated state. It is stipulated that it cannot turn on SSH and has no GUI. It can only work under the VGA display of this machine So many times when querying mysql, you can only turn the page up and down Unless I know the column name and the required parameters to find the specified data This requires a long command input, which will become very cumbersome.

 

[t.lamprecht]

It is stipulated that it cannot turn on SSH and has no GUI. It can only work under the VGA display of this machine So many times when querying mysql, you can only turn the page up and down Unless I know the column name and the required parameters to find the specified data This requires a long command input, which will become very cumbersome.

Yeah, that indeed sounds like a bit of a PITA. FYI, tmux or screen don't need any GUI they can work with the "low level" Linux TTY/console just fine, so I'd defnitively check those out if not already done.

Both are available as Debian package to just install with apt install and neither has any network capabilities, so they shouldn't interfere with the strict policies on that host.

 

[zisain]

Yeah, that indeed sounds like a bit of a PITA. FYI, tmux or screen don't need any GUI they can work with the "low level" Linux TTY/console just fine, so I'd defnitively check those out if not already done.

Both are available as Debian package to just install with apt install and neither has any network capabilities, so they shouldn't interfere with the strict policies on that host.

Thank my friend very much. TMUX is great. It successfully solves my needs.