SET PERSIST max_connections = 1000;
SET @@PERSIST.max_connections = 1000;
SET PERSIST_ONLY back_log = 100;
SET @@PERSIST_ONLY.back_log = 100;
//mysql-auto.cnf에서 모든 SYSTEM 변수 제거
RESET PERSIST;
-- 형식
RESET PERSIST system_var_name;
RESET PERSIST IF EXISTS system_var_name;
-- example
RESET PERSIST mandatory_roles ;
RESET PERSIST IF EXISTS mandatory_roles;
-- pesist 설정이 된 변수만 조회
SELECT * FROM performance_schema.persisted_variables;
-- pesist 설정이 된 변수와 정보를 함께 조회
SELECT * FROM performance_schema.variables_info;
SELECT * FROM performance_schema.variables_info WHERE variable_name LIKE 'max_conn%'
-- output
-- +-----------------+-----------------+----------------------------------------------------+-----------+-----------+
-- | VARIABLE_NAME | VARIABLE_SOURCE | VARIABLE_PATH | MIN_VALUE | MAX_VALUE |
-- +-----------------+-----------------+----------------------------------------------------+-----------+-----------+
-- | max_connections | PERSISTED | C:\Users\bhsatish\mysql-trunk\data\mysqld-auto.cnf | 1 | 100000 |
-- +-----------------+-----------------+----------------------------------------------------+-----------+-----------+
{
"Version": 1,
"mysql_server": {
"max_connections": {
"Value": "1000",
"Metadata": {
"Timestamp": 1.519921706e+15,
"User": "root",
"Host": "localhost"
}
},
"autocommit": {
"Value": "ON",
"Metadata": {
"Timestamp": 1.519921707e+15,
"User": "root",
"Host": "localhost"
}
}
}
}
SET PERSIST max_connections = 1000;
SET @@PERSIST.max_connections = 1000;
SET PERSIST_ONLY back_log = 100;
SET @@PERSIST_ONLY.back_log = 100;
//mysql-auto.cnf에서 모든 SYSTEM 변수 제거
RESET PERSIST;
-- 형식
RESET PERSIST system_var_name;
RESET PERSIST IF EXISTS system_var_name;
-- example
RESET PERSIST mandatory_roles ;
RESET PERSIST IF EXISTS mandatory_roles;
-- pesist 설정이 된 변수만 조회
SELECT * FROM performance_schema.persisted_variables;
-- pesist 설정이 된 변수와 정보를 함께 조회
SELECT * FROM performance_schema.variables_info;
SELECT * FROM performance_schema.variables_info WHERE variable_name LIKE 'max_conn%'
-- output
-- +-----------------+-----------------+----------------------------------------------------+-----------+-----------+
-- | VARIABLE_NAME | VARIABLE_SOURCE | VARIABLE_PATH | MIN_VALUE | MAX_VALUE |
-- +-----------------+-----------------+----------------------------------------------------+-----------+-----------+
-- | max_connections | PERSISTED | C:\Users\bhsatish\mysql-trunk\data\mysqld-auto.cnf | 1 | 100000 |
-- +-----------------+-----------------+----------------------------------------------------+-----------+-----------+
{
"Version": 1,
"mysql_server": {
"max_connections": {
"Value": "1000",
"Metadata": {
"Timestamp": 1.519921706e+15,
"User": "root",
"Host": "localhost"
}
},
"autocommit": {
"Value": "ON",
"Metadata": {
"Timestamp": 1.519921707e+15,
"User": "root",
"Host": "localhost"
}
}
}
}
SET PERSIST max_connections = 1000;
SET @@PERSIST.max_connections = 1000;
SET PERSIST_ONLY back_log = 100;
SET @@PERSIST_ONLY.back_log = 100;
//mysql-auto.cnf에서 모든 SYSTEM 변수 제거
RESET PERSIST;
-- 형식
RESET PERSIST system_var_name;
RESET PERSIST IF EXISTS system_var_name;
-- example
RESET PERSIST mandatory_roles ;
RESET PERSIST IF EXISTS mandatory_roles;
-- pesist 설정이 된 변수만 조회
SELECT * FROM performance_schema.persisted_variables;
-- pesist 설정이 된 변수와 정보를 함께 조회
SELECT * FROM performance_schema.variables_info;
SELECT * FROM performance_schema.variables_info WHERE variable_name LIKE 'max_conn%'
-- output
-- +-----------------+-----------------+----------------------------------------------------+-----------+-----------+
-- | VARIABLE_NAME | VARIABLE_SOURCE | VARIABLE_PATH | MIN_VALUE | MAX_VALUE |
-- +-----------------+-----------------+----------------------------------------------------+-----------+-----------+
-- | max_connections | PERSISTED | C:\Users\bhsatish\mysql-trunk\data\mysqld-auto.cnf | 1 | 100000 |
-- +-----------------+-----------------+----------------------------------------------------+-----------+-----------+
{
"Version": 1,
"mysql_server": {
"max_connections": {
"Value": "1000",
"Metadata": {
"Timestamp": 1.519921706e+15,
"User": "root",
"Host": "localhost"
}
},
"autocommit": {
"Value": "ON",
"Metadata": {
"Timestamp": 1.519921707e+15,
"User": "root",
"Host": "localhost"
}
}
}
}