maria-discuss team mailing list archive

[Игорь Пашев <pashev.igor@xxxxxxxxx>]

2016-08-18 23:40 GMT+03:00 Nirbhay Choubey <nirbhay@xxxxxxxxxxx>:
>
>
> On Thu, Aug 18, 2016 at 3:55 PM, Игорь Пашев <pashev.igor@xxxxxxxxx> 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!