Скачать или смотреть Daily commands for MySQL Administration Part 4 HD Audio

Related Videos
======================================================================================================
Most widely used Daily common commands in MySQL Part 1 HD Audio -
   • Daily commands for MySQL Administration Pa...  

Most widely used Daily common commands in MySQL Part 2 HD Audio -
   • Daily commands for MySQL Administration Pa...  

Most widely used Daily common commands in MySQL Part 3 HD Audio -
   • Daily commands for MySQL Administration Pa...  

Most widely used Daily common commands in MySQL Part 4 HD Audio -
   • Daily commands for MySQL Administration Pa...  

🔔 Like , Share & Subscribe for more videos like this
   / @databasecastle  

Most Widely used Commands by MySQL DBA Part 4
-----------------------------------------------------------------------------------------
SHOW VARIABLES LIKE '%wait_timeout%';
show variables;
SELECT @@key_buffer_size;
--- To set the value of a GLOBAL variable, use one of the following syntaxes:
SHOW VARIABLES LIKE '%max_conn%';
SET GLOBAL max_connections=200;
SET @@global.max_connections=300;
SET GLOBAL max_connections=151;
--- To set the value of a SESSION variable, use one of the following syntaxes:
show global variables like '%sort_buffer_size%';
SET SESSION sort_buffer_size=262144;
SET @@session.sort_buffer_size=262144;
SET sort_buffer_size=262144;

--- To retrieve the value of a GLOBAL variable, use one of the following statements:
SELECT @@global.sort_buffer_size;
SHOW GLOBAL VARIABLES like 'sort_buffer_size';

--- To retrieve the value of a SESSION variable, use one of the following statements:
SELECT @@sort_buffer_size;
SELECT @@session.sort_buffer_size;
SHOW SESSION VARIABLES like 'sort_buffer_size';
--- Start/Stop/Restart/Status/Reload MySQL Service
service mysqld status
service mysqld reload
service mysqld restart
service mysqld stop
service mysqld start

service mariadb status
service mariadb reload
service mariadb restart
service mariadb stop
service mariadb start