maria-discuss team mailing list archive

[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';

Best,
Nirbhay


>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>