Scribd
Upload
5 views13 pages

MySQL Global System Variables Guide

Global variables apply to all connections related to a specific server. They can be set using SET GLOBAL and affect the operation of the entire server. Only predefined system variables can be set globally, like max_connections which sets the maximum number of connections, and max_join_size which sets the maximum memory for joins per connection.

Uploaded by

Sai Swaroop Mandal
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views13 pages

MySQL Global System Variables Guide

Global variables apply to all connections related to a specific server. They can be set using SET GLOBAL and affect the operation of the entire server. Only predefined system variables can be set globally, like max_connections which sets the maximum number of connections, and max_join_size which sets the maximum memory for joins per connection.

Uploaded by

Sai Swaroop Mandal
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Global Variables

Global Variables

global variables

global variables apply to all connections related to a specific server


Global Variables
Global Variables

“Var” “Var”
“Var” “Var”
“Var” “Var”
“Var”
“Var” “Var”
Global Variables

SET GLOBAL var_name = value;


Global Variables

SET GLOBAL var_name = value;

SET @@global.var_name = value;


Global Variables
you cannot set just any variable as global
Global Variables
you cannot set just any variable as global
- a specific group of pre-defined variables in MySQL is suitable for
this job. They are called system variables
Global Variables
you cannot set just any variable as global
- a specific group of pre-defined variables in MySQL is suitable for
this job. They are called system variables
Global Variables
you cannot set just any variable as global
- a specific group of pre-defined variables in MySQL is suitable for
this job. They are called system variables

.max_connections()
Global Variables
you cannot set just any variable as global
- a specific group of pre-defined variables in MySQL is suitable for
this job. They are called system variables

.max_connections()

.max_join_size()
Global Variables
you cannot set just any variable as global
- a specific group of pre-defined variables in MySQL is suitable for
this job. They are called system variables

.max_connections() - indicates the maximum number of connections


to a server that can be established at a
certain point in time

.max_join_size()
Global Variables
you cannot set just any variable as global
- a specific group of pre-defined variables in MySQL is suitable for
this job. They are called system variables

.max_connections() - indicates the maximum number of connections


to a server that can be established at a
certain point in time

.max_join_size() - sets the maximum memory space allocated for


the joins created by a certain connection

You might also like