Manual MySQL Variable Configuration

SET GLOBAL autocommit = ON;

SET SESSION autocommit = OFF;

SET GLOBAL autocommit = DEFAULT;

SET GLOBAL max_connections = 90;

SET GLOBAL max_connections = DEFAULT;

SET GLOBAL tmp_table_size = 36700160;

SET GLOBAL tmp_table_size = 35 * 1024 * 1024;

Here are some examples of Manually setting MySQL Variables

You need to know what you are doing before issuing one of these commands, yous should research the impact or run the command on a test server first