Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Make flag CLIENT_FOUND_ROWS configurable per user #887

Closed
renecannao opened this issue Jan 18, 2017 · 1 comment
Closed

Make flag CLIENT_FOUND_ROWS configurable per user #887

renecannao opened this issue Jan 18, 2017 · 1 comment

Comments

@renecannao
Copy link
Contributor

This is an improvement over #445 .
In #445 , a new global variable mysql-client_found_rows was added, and it defaults to true to work with ORM likes SQLAlchemy and django .

ProxySQL can be more granular and have CLIENT_FOUND_ROWS enabled or disabled on a per user basis.

Note: according to the documentation, COM_CHANGE_USER doesn't allow to change capabilities, therefore CLIENT_FOUND_ROWS cannot be changed on an already established connection.
To implement this feature, we first need to enhance the connection pool in order to try to find a connection with the closest attributes possible, like for example same user.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant