Percona's mysql client horizontally wraps long queries, how to disable

MySQL & MariaDB
7

Ahah! Okay I’ve cracked it. The installed libcurses on my system searches all of:

  • /etc/terminfo/
  • /lib/terminfo/
  • /usr/share/terminfo/

On Debian/Ubuntu, most of the terminfo files appear to be in /lib/terminfo

The percona mysql only searches:

  • /etc/terminfo/
  • /usr/share/terminfo/

So it’s not finding any of the terminfo data, and so horizontal scroll is being used instead of the expected vertical scroll!

This fixes it for me:

TERMINFO_DIRS=/etc/terminfo:/lib/terminfo:/usr/share/terminfo ./bin/mysql ...