dolt icon indicating copy to clipboard operation
dolt copied to clipboard

Improve Dolt sysvar support

Open timsehn opened this issue 2 years ago • 2 comments

There are many MySQL of system variables like @@max_user_connections, @@max_connections, @@port. A full list can be found here:

https://dev.mysql.com/doc/refman/8.0/en/dynindex-sysvar.html

Dolt does not set many of these and for some returns non-sensical values. For instance we always return 3306 for @@port even if you've set a different port (#5898).

We need to run a project tio go through that very long list, set the ones we can, and finally document what we support and do not support under:

https://docs.dolthub.com/sql-reference/sql-support

timsehn avatar May 26 '23 17:05 timsehn

Probably first step here is to do read-only support for most of these variables and then do a pass on editing them actually changes the behavior of the running server.

timsehn avatar May 30 '23 20:05 timsehn

@@max_connections returns the correct value but changing its value on a running server doesn't change the behavior. You have to set @@persist.max_connections and then restart the server for changes to take effect.

zachmu avatar Dec 13 '23 21:12 zachmu