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