[Maria-discuss] Query the list of dynamic variables
If there are way to query the list of dynamic variables, e. i. variables that can be changed globally without restarting the server?
On Thu, Aug 18, 2016 at 3:55 PM, Игорь Пашев <pashev.igor@gmail.com> wrote:
If there are way to query the list of dynamic variables, e. i. variables that can be changed globally without restarting the server?
In 10.1, you can try I_S.system_variables, something like : SELECT VARIABLE_NAME FROM INFORMATION_SCHEMA.SYSTEM_VARIABLES WHERE READ_ONLY='NO' AND VARIABLE_SCOPE !='SESSION ONLY'; Best, Nirbhay
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
2016-08-18 23:40 GMT+03:00 Nirbhay Choubey <nirbhay@mariadb.com>:
On Thu, Aug 18, 2016 at 3:55 PM, Игорь Пашев <pashev.igor@gmail.com> wrote:
If there are way to query the list of dynamic variables, e. i. variables that can be changed globally without restarting the server?
In 10.1, you can try I_S.system_variables, something like :
SELECT VARIABLE_NAME FROM INFORMATION_SCHEMA.SYSTEM_VARIABLES WHERE READ_ONLY='NO' AND VARIABLE_SCOPE !='SESSION ONLY';
Great! 10.1 is the very branch I care about. Thank you!
participants (2)
-
Nirbhay Choubey -
Игорь Пашев