[MXS-2783] Protocol level compression Created: 2019-11-28  Updated: 2023-04-04  Resolved: 2023-04-04

Status: Closed
Project: MariaDB MaxScale
Component/s: N/A
Affects Version/s: None
Fix Version/s: N/A

Type: New Feature Priority: Major
Reporter: Sergey Smirnov Assignee: Todd Stoffel (Inactive)
Resolution: Won't Do Votes: 0
Labels: Performance

Sprint: MXS-SPRINT-143, MXS-SPRINT-144, MXS-SPRINT-145, MXS-SPRINT-149, MXS-SPRINT-150, MXS-SPRINT-151

 Description   

Hello!
My maxscale version is 2.3.11-1.x86_64

When I use direct connection, like this
mysql -h <SERVER_IP> -u <DB> -P<PORT> -p -C -e "\s"
I have in my output:

Protocol:               Compressed

When I try it through maxscale, I can't see "Compressed" in my output. How can I get compression with maxscale?

I have problem like this link on my php application:
https://jira.mariadb.org/browse/MXS-702

when I try use compression with mysqli code from description -> I get freez
when I try use PDO with strace:

sendto(3, "\r\0\0\0\0\0\0\t\0\0\0\3SELECT 1", 20, MSG_DONTWAIT, NULL, 0) = 20
poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=3, revents=POLLIN}])
recvfrom(3, "\30\0\0\1\377\27\4#08S01Unknown command", 78, MSG_DONTWAIT, NULL, NULL) = 28
poll([{fd=3, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928^Cstrace: Process 7937 detached

I think PDO use mysqlnd, but I can't understand why compression not work with native mysql client.

Can you explain for me this sentance:

Compression is not included in the server handshake.

https://mariadb.com/kb/en/mariadb-maxscale-23-limitations-and-known-issues-within-mariadb-maxscale/
I can't understand it.



 Comments   
Comment by markus makela [ 2019-11-29 ]

Protocol level compression is currently not supported by MaxScale. If you think this is a feature that is important, please let us know and we'll change this issue into a feature request.

Comment by Sergey Smirnov [ 2019-11-29 ]

Can you change issue type to feature request, please?

Generated at Thu Feb 08 04:16:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.