hard to read history file

[monty solomon]

In Percona Server 5.6 the history file is no longer easy to read.

# cat .mysql_history
_HiStOrY_V2_
select\040now();
show\040slave\040status\134G
show\040processlist;
use\040information_schema
show\040tables;
SHOW\040ENGINE\040INNODB\040STATUS\134G

Server version: 5.6.16-64.1-56-log Percona Server (GPL), Release 64.1, Revision 563

Linux 2.6.32-431.el6.x86_64 #1 SMP Fri Nov 22 03:15:09 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux

CentOS release 6.5 (Final)

[monty solomon (monty+launchpad)]

Here is the same history file from Percona 5.5

$ cat .mysql_history
select now();
show slave status\G
show processlist;
use information_schema
show tables;
SHOW ENGINE INNODB STATUS\G

Server version: 5.5.36-34.1-log Percona Server (GPL), Release rel34.1, Revision 642

[Valerii Kravchuk (valerii-kravchuk)]

This is easy to reproduce with Percona Server 5.6:

[openxs@chief 5.6]$ tail -10 ~/.mysql_history
select\040version();
show\040variables\040like\040'char%';
show\040create\040table\040test3\134G
alter\040table\040test3\040modify\040test_column\040varchar(10)\040charset\040utf8mb4;
show\040create\040table\040test3\134G
insert\040into\040test2\040values(unhex('f09f9884'));
insert\040into\040test3\040values(unhex('f09f9884'));
select\040*\040from\040test3;
select\040now();
select\040now(),\040now();

But it seems the problem is inherited from upstream MySQL 5.6. Had you reported it upstream already?

[Valerii Kravchuk (valerii-kravchuk)]

I've reported upstream bug for this:

http://bugs.mysql.com/bug.php?id=72108

Please, check it and add comments there if needed.

[monty solomon (monty+launchpad)]

It appears that upstream stopped using readline.

Can readline be added to Percona Server?

[Laurynas Biveinis (laurynas-biveinis)]

Monty -

Please follow bug 1266386 re. readline.

[Laurynas Biveinis (laurynas-biveinis)]

http://bugs.mysql.com/bug.php?id=68925

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-2066