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

[4 Mar 2014 13:36] Van Stokes
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.
[22 Jul 2014 19:55] Sveta Smirnova
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.
[23 Aug 2014 1:00] Bugs System
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".