MySQL Bugs: #71925: CLI slow/non-responsive when using --compress option

Bug #71925	CLI slow/non-responsive when using --compress option
Submitted:	4 Mar 2014 13:36	Modified:	22 Aug 2014 19:55
Reporter:	Van Stokes	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S3 (Non-critical)
Version:	5.5.35	OS:	Linux (Ubuntu 12.04 x86_64)
Assigned to:		CPU Architecture:	Any

Description:
When using the --compress option with the MySQL 5.5.35 command line client and connecting a 5.6.14 host, the client hangs for long periods or never responds with the results. The MySQL server shows that the query ran and returned results and the connection ended normally. 

Executing the command from a 5.6.14 client does NOT yield this problem.

How to repeat:
MySQL Server: 5.6.14 on Ubuntu host myhost.mydomain.com
MySQL Client: 5.5.35 on Ubuntu client
OS: Ubuntu 12.04.03 x64 (both server and client)

Our query returned 8K rows. Here is the command line syntax we used:

This command HANGS:

$ mysql --compress --host=myhost.mydomain.com -B -p mydatabase < query.sql | sed 's/"//g' | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > results.csv

This command works as expected (note that --compress is omitted):

$ mysql --host=myhost.mydomain.com -B -p mydatabase < query.sql | sed 's/"//g' | sed 's/\t/","/g;s/^/"/;s/$/"/;s/\n//g' > results.csv

Suggested fix:
Enable the mysql 5.5.x client to properly connect to a 5.6.x host using the --compress option.

Thank you for the report.

I cannot repeat described behavior. Please try with current version 5.5.38 and if problem still exists provide content of query.sql and dump of all tables involved.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".