head.daveops.net

Snippets for yer computer needs

MySQL - Configuration

Variables

-- session variables
SHOW SESSION VARIABLES;
SET SESSION sort_buffer_size=1000000;
-- global variables
SHOW GLOBAL VARIABLES;
SET GLOBAL sort_buffer_size=1000000;

Get timezone config

SELECT @@global.time_zone, @@session.time_zone;