On Thu, Aug 18, 2016 at 3:55 PM, Игорь Пашев <pashev.i...@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
>
_______________________________________________
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

Reply via email to