Skip to main content

Stored Procedure 개요

카카오클라우드 MySQL에서 제공하는 기본 저장 프로시저를 통해 인스턴스 그룹을 관리할 수 있습니다.

안내

저장 프로시저(Stored Procedure)는 kr-central-2에 한해 제공됩니다.
프로시저 내에서 별도로 Role을 생성할 수 없습니다. 사용자는 직접 Role을 생성해야 하며, 해당 Role에 대한 권한 부여 및 사용자 매핑은 프로시저를 통해 수행할 수 있습니다.

수정 불가능한 파라미터

다음 파라미터는 프로시저 기반 수정이 불가능합니다.

NoNameCmd-LineOption FileSystem VarVar ScopeDynamic변경 불가 선정 사유
1activate_all_roles_on_loginYes     Yes     Yes       Global       YesAdmin 역할
2admin_addressYesYesYesGlobalNoAdmin 역할
3admin_portYesYesYesGlobalNoAdmin 역할
4admin_ssl_caYesYesYesGlobalYesAdmin 역할
5admin_ssl_capathYesYesYesGlobalYesAdmin 역할
6admin_ssl_certYesYesYesGlobalYesAdmin 역할
7admin_ssl_cipherYesYesYesGlobalYesAdmin 역할
8admin_ssl_crlYesYesYesGlobalYesAdmin 역할
9admin_ssl_crlpathYesYesYesGlobalYesAdmin 역할
10admin_ssl_keyYesYesYesGlobalYesAdmin 역할
11admin_tls_ciphersuitesYesYesYesGlobalYesAdmin 역할
12admin_tls_versionYesYesYesGlobalYesAdmin 역할
13audit_log_buffer_sizeYesYesYesGlobalNo감사 관련
14audit_log_compressionYesYesYesGlobalNo감사 관련
15audit_log_connection_policyYesYesYesGlobalYes감사 관련
16audit_log_current_sessionYesBothNo감사 관련
17audit_log_databaseYesYesYesGlobalNo감사 관련
18audit_log_disableYesYesYesGlobalYes감사 관련
19audit_log_encryptionYesYesYesGlobalNo감사 관련
20audit_log_exclude_accountsYesYesYesGlobalYes감사 관련
21audit_log_fileYesYesYesGlobalNo감사 관련
22audit_log_filter_idYesBothNo감사 관련
23audit_log_flushYesGlobalYes감사 관련
24audit_log_flush_interval_secondsYesYesGlobalNo감사 관련
25audit_log_formatYesYesYesGlobalNo감사 관련
26audit_log_format_unix_timestampYesYesYesGlobalYes감사 관련
27audit_log_include_accountsYesYesYesGlobalYes감사 관련
28audit_log_max_sizeYesYesYesGlobalYes감사 관련
29audit_log_password_history_keep_daysYesYesYesGlobalYes감사 관련
30audit_log_policyYesYesYesGlobalNo감사 관련
31audit_log_prune_secondsYesYesYesGlobalYes감사 관련
32audit_log_read_buffer_sizeYesYesYesVariesVaries감사 관련
33audit_log_rotate_on_sizeYesYesYesGlobalYes감사 관련
34audit_log_statement_policyYesYesYesGlobalYes감사 관련
35audit_log_strategyYesYesYesGlobalNo감사 관련
36authentication_fido_rp_idYesYesYesGlobalYes인증 관련
37authentication_kerberos_service_key_tabYesYesYesGlobalNo인증 관련
38authentication_kerberos_service_principalYesYesYesGlobalYes인증 관련
39authentication_ldap_sasl_auth_method_nameYesYesYesGlobalYes인증 관련
40authentication_ldap_sasl_bind_base_dnYesYesYesGlobalYes인증 관련
41authentication_ldap_sasl_bind_root_dnYesYesYesGlobalYes인증 관련
42authentication_ldap_sasl_bind_root_pwdYesYesYesGlobalYes인증 관련
43authentication_ldap_sasl_ca_pathYesYesYesGlobalYes인증 관련
44authentication_ldap_sasl_group_search_attrYesYesYesGlobalYes인증 관련
45authentication_ldap_sasl_group_search_filterYesYesYesGlobalYes인증 관련
46authentication_ldap_sasl_init_pool_sizeYesYesYesGlobalYes인증 관련
47authentication_ldap_sasl_log_statusYesYesYesGlobalYes인증 관련
48authentication_ldap_sasl_max_pool_sizeYesYesYesGlobalYes인증 관련
49authentication_ldap_sasl_referralYesYesYesGlobalYes인증 관련
50authentication_ldap_sasl_server_hostYesYesYesGlobalYes인증 관련
51authentication_ldap_sasl_server_portYesYesYesGlobalYes인증 관련
52authentication_ldap_sasl_tlsYesYesYesGlobalYes인증 관련
53authentication_ldap_sasl_user_search_attrYesYesYesGlobalYes인증 관련
54authentication_ldap_simple_auth_method_nameYesYesYesGlobalYes인증 관련
55authentication_ldap_simple_bind_base_dnYesYesYesGlobalYes인증 관련
56authentication_ldap_simple_bind_root_dnYesYesYesGlobalYes인증 관련
57authentication_ldap_simple_bind_root_pwdYesYesYesGlobalYes인증 관련
58authentication_ldap_simple_ca_pathYesYesYesGlobalYes인증 관련
59authentication_ldap_simple_group_search_attrYesYesYesGlobalYes인증 관련
60authentication_ldap_simple_group_search_filterYesYesYesGlobalYes인증 관련
61authentication_ldap_simple_init_pool_sizeYesYesYesGlobalYes인증 관련
62authentication_ldap_simple_log_statusYesYesYesGlobalYes인증 관련
63authentication_ldap_simple_max_pool_sizeYesYesYesGlobalYes인증 관련
64authentication_ldap_simple_referralYesYesYesGlobalYes인증 관련
65authentication_ldap_simple_server_hostYesYesYesGlobalYes인증 관련
66authentication_ldap_simple_server_portYesYesYesGlobalYes인증 관련
67authentication_ldap_simple_tlsYesYesYesGlobalYes인증 관련
68authentication_ldap_simple_user_search_attrYesYesYesGlobalYes인증 관련
69authentication_policyYesYesYesGlobalYes인증 관련
70authentication_windows_log_levelYesYesYesGlobalNo인증 관련
71authentication_windows_use_principal_nameYesYesYesGlobalNo인증 관련
72auto_generate_certsYesYesYesGlobalNoSSL 관련
73auto_increment_incrementYesYesYesBothYes순환(소스 간) 복제 관련
74auto_increment_offsetYesYesYesBothYes순환(소스 간) 복제 관련
75avoid_temporal_upgradeYesYesYesGlobalYesALTER Table 명령문이 5.6.4 이전 형식인 임시 열을 암시적으로 업그레이드하는지 여부를 제어
76basedirYesYesYesGlobalNoMySQL installation base directory.
77bind_addressYesYesYesGlobalNoTCP/IP 연결 관련
78binlog_formatYesYesYesBothYesManaged 관련
79core_fileYesGlobalNoManaged 관련
80create_admin_listener_threadYesYesYesGlobalNoManaged 관련
81datadirYesYesYesGlobalNoManaged 관련
82daemon_memcached_enable_binlogYesYesYesGlobalNoMemcached 관련
83daemon_memcached_engine_lib_nameYesYesYesGlobalNoMemcached 관련
84daemon_memcached_engine_lib_pathYesYesYesGlobalNoMemcached 관련
85daemon_memcached_optionYesYesYesGlobalNoMemcached 관련
86daemon_memcached_r_batch_sizeYesYesYesGlobalNoMemcached 관련
87daemon_memcached_w_batch_sizeYesYesYesGlobalNoMemcached 관련
88general_log_fileYesYesYesGlobalYesManaged 관련
89group_replication_advertise_recovery_endpointsYesYesYesGlobalYesgroup_replication 관련
90group_replication_allow_local_lower_version_joinYesYesYesGlobalYesgroup_replication 관련
91group_replication_auto_increment_incrementYesYesYesGlobalYesgroup_replication 관련
92group_replication_autorejoin_triesYesYesYesGlobalYesgroup_replication 관련
93group_replication_bootstrap_groupYesYesYesGlobalYesgroup_replication 관련
94group_replication_clone_thresholdYesYesYesGlobalYesgroup_replication 관련
95group_replication_communication_debug_optionsYesYesYesGlobalYesgroup_replication 관련
96group_replication_communication_max_message_sizeYesYesYesGlobalYesgroup_replication 관련
97group_replication_communication_stackYesGlobalNogroup_replication 관련
98group_replication_components_stop_timeoutYesYesYesGlobalYesgroup_replication 관련
99group_replication_compression_thresholdYesYesYesGlobalYesgroup_replication 관련
100group_replication_consistencyYesYesYesBothYesgroup_replication 관련
101group_replication_enforce_update_everywhere_checksYesYesYesGlobalYesgroup_replication 관련
102group_replication_exit_state_actionYesYesYesGlobalYesgroup_replication 관련
103group_replication_flow_control_applier_thresholdYesYesYesGlobalYesgroup_replication 관련
104group_replication_flow_control_certifier_thresholdYesYesYesGlobalYesgroup_replication 관련
105group_replication_flow_control_hold_percentYesYesYesGlobalYesgroup_replication 관련
106group_replication_flow_control_max_quotaYesYesYesGlobalYesgroup_replication 관련
107group_replication_flow_control_member_quota_percentYesYesYesGlobalYesgroup_replication 관련
108group_replication_flow_control_min_quotaYesYesYesGlobalYesgroup_replication 관련
109group_replication_flow_control_min_recovery_quotaYesYesYesGlobalYesgroup_replication 관련
110group_replication_flow_control_modeYesYesYesGlobalYesgroup_replication 관련
111group_replication_flow_control_periodYesYesYesGlobalYesgroup_replication 관련
112group_replication_flow_control_release_percentYesYesYesGlobalYesgroup_replication 관련
113group_replication_force_membersYesYesYesGlobalYesgroup_replication 관련
114group_replication_group_nameYesYesYesGlobalYesgroup_replication 관련
115group_replication_group_seedsYesYesYesGlobalYesgroup_replication 관련
116group_replication_gtid_assignment_block_sizeYesYesYesGlobalYesgroup_replication 관련
117group_replication_ip_allowlistYesYesYesGlobalYesgroup_replication 관련
118group_replication_ip_whitelistYesYesYesGlobalYesgroup_replication 관련
119group_replication_local_addressYesYesYesGlobalYesgroup_replication 관련
120group_replication_member_expel_timeoutYesYesYesGlobalYesgroup_replication 관련
121group_replication_member_weightYesYesYesGlobalYesgroup_replication 관련
122group_replication_message_cache_sizeYesYesYesGlobalYesgroup_replication 관련
123group_replication_paxos_single_leaderYesYesYesGlobalYesgroup_replication 관련
124group_replication_poll_spin_loopsYesYesYesGlobalYesgroup_replication 관련
125group_replication_recovery_complete_atYesYesYesGlobalYesgroup_replication 관련
126group_replication_recovery_compression_algorithmsYesYesYesGlobalYesgroup_replication 관련
127group_replication_recovery_get_public_keyYesYesYesGlobalYesgroup_replication 관련
128group_replication_recovery_public_key_pathYesYesYesGlobalYesgroup_replication 관련
129group_replication_recovery_reconnect_intervalYesYesYesGlobalYesgroup_replication 관련
130group_replication_recovery_retry_countYesYesYesGlobalYesgroup_replication 관련
131group_replication_recovery_ssl_caYesYesYesGlobalYesgroup_replication 관련
132group_replication_recovery_ssl_capathYesYesYesGlobalYesgroup_replication 관련
133group_replication_recovery_ssl_certYesYesYesGlobalYesgroup_replication 관련
134group_replication_recovery_ssl_cipherYesYesYesGlobalYesgroup_replication 관련
135group_replication_recovery_ssl_crlYesYesYesGlobalYesgroup_replication 관련
136group_replication_recovery_ssl_crlpathYesYesYesGlobalYesgroup_replication 관련
137group_replication_recovery_ssl_keyYesYesYesGlobalYesgroup_replication 관련
138group_replication_recovery_ssl_verify_server_certYesYesYesGlobalYesgroup_replication 관련
139group_replication_recovery_tls_ciphersuitesYesYesYesGlobalYesgroup_replication 관련
140group_replication_recovery_tls_versionYesYesYesGlobalYesgroup_replication 관련
141group_replication_recovery_use_sslYesYesYesGlobalYesgroup_replication 관련
142group_replication_recovery_zstd_compression_levelYesYesYesGlobalYesgroup_replication 관련
143group_replication_single_primary_modeYesYesYesGlobalYesgroup_replication 관련
144group_replication_ssl_modeYesYesYesGlobalYesgroup_replication 관련
145group_replication_start_on_bootYesYesYesGlobalYesgroup_replication 관련
146group_replication_tls_sourceYesYesYesGlobalYesgroup_replication 관련
147group_replication_transaction_size_limitYesYesYesGlobalYesgroup_replication 관련
148group_replication_unreachable_majority_timeoutYesYesYesGlobalYesgroup_replication 관련
149group_replication_view_change_uuidYesYesYesGlobalYesgroup_replication 관련
150gtid_modeYesYesYesGlobalYesManaged 관련
151hostnameYesGlobalNoManaged 관련
152innodb_data_file_pathYesYesYesGlobalNoManaged 관련
153innodb_data_home_dirYesYesYesGlobalNoManaged 관련
154innodb_directoriesYesYesYesGlobalNoManaged 관련
155innodb_doublewrite_dirYesYesYesGlobalNoManaged 관련
156innodb_doublewrite_filesYesYesYesGlobalNoManaged 관련
157innodb_log_group_home_dirYesYesYesGlobalNoManaged 관련
158innodb_redo_log_archive_dirsYesYesYesGlobalYesManaged 관련
159innodb_temp_data_file_pathYesYesYesGlobalNoManaged 관련
160innodb_temp_tablespaces_dirYesYesYesGlobalNoManaged 관련
161innodb_tmpdirYesYesYesBothYesManaged 관련
162innodb_undo_directoryYesYesYesGlobalNoManaged 관련
163innodb_validate_tablespace_pathsYesYesYesGlobalNoManaged 관련
164keyring_aws_cmk_idYesYesYesGlobalYeskeyring 관련
165keyring_aws_conf_fileYesYesYesGlobalNokeyring 관련
166keyring_aws_data_fileYesYesYesGlobalNokeyring 관련
167keyring_aws_regionYesYesYesGlobalYeskeyring 관련
168keyring_encrypted_file_dataYesYesYesGlobalYeskeyring 관련
169keyring_encrypted_file_passwordYesYesYesGlobalYeskeyring 관련
170keyring_file_dataYesYesYesGlobalYeskeyring 관련
171keyring_hashicorp_auth_pathYesYesYesGlobalYeskeyring 관련
172keyring_hashicorp_ca_pathYesYesYesGlobalYeskeyring 관련
173keyring_hashicorp_cachingYesYesYesGlobalYeskeyring 관련
174keyring_hashicorp_commit_auth_pathYesGlobalNokeyring 관련
175keyring_hashicorp_commit_ca_pathYesGlobalNokeyring 관련
176keyring_hashicorp_commit_cachingYesGlobalNokeyring 관련
177keyring_hashicorp_commit_role_idYesGlobalNokeyring 관련
178keyring_hashicorp_commit_server_urlYesGlobalNokeyring 관련
179keyring_hashicorp_commit_store_pathYesGlobalNokeyring 관련
180keyring_hashicorp_role_idYesYesYesGlobalYeskeyring 관련
181keyring_hashicorp_secret_idYesYesYesGlobalYeskeyring 관련
182keyring_hashicorp_server_urlYesYesYesGlobalYeskeyring 관련
183keyring_hashicorp_store_pathYesYesYesGlobalYeskeyring 관련
184keyring_oci_ca_certificateYesYesYesGlobalNokeyring 관련
185keyring_oci_compartmentYesYesYesGlobalNokeyring 관련
186keyring_oci_encryption_endpointYesYesYesGlobalNokeyring 관련
187keyring_oci_key_fileYesYesYesGlobalNokeyring 관련
188keyring_oci_key_fingerprintYesYesYesGlobalNokeyring 관련
189keyring_oci_management_endpointYesYesYesGlobalNokeyring 관련
190keyring_oci_master_keyYesYesYesGlobalNokeyring 관련
191keyring_oci_secrets_endpointYesYesYesGlobalNokeyring 관련
192keyring_oci_tenancyYesYesYesGlobalNokeyring 관련
193keyring_oci_userYesYesYesGlobalNokeyring 관련
194keyring_oci_vaults_endpointYesYesYesGlobalNokeyring 관련
195keyring_oci_virtual_vaultYesYesYesGlobalNokeyring 관련
196keyring_okv_conf_dirYesYesYesGlobalYeskeyring 관련
197keyring_operationsYesGlobalYeskeyring 관련
198lc_messages_dirYesYesYesGlobalNoManaged 관련
199licenseYesGlobalNoManaged 관련
200log_binYesGlobalNoManaged 관련
201log_bin_basenameYesGlobalNoManaged 관련
202log_bin_indexYesYesYesGlobalNoManaged 관련
203log_errorYesYesYesGlobalNoManaged 관련
204ndb_allow_copying_alter_tableYesYesYesBothYesNDB 관련
205ndb_applier_allow_skip_epochYesYesYesGlobalNoNDB 관련
206ndb_autoincrement_prefetch_szYesYesYesBothYesNDB 관련
207ndb_batch_sizeYesYesYesGlobalNoNDB 관련
208ndb_blob_read_batch_bytesYesYesYesBothYesNDB 관련
209ndb_blob_write_batch_bytesYesYesYesBothYesNDB 관련
210ndb_clear_apply_statusYesYesGlobalYesNDB 관련
211ndb_cluster_connection_poolYesYesYesGlobalNoNDB 관련
212ndb_cluster_connection_pool_nodeidsYesYesYesGlobalNoNDB 관련
213ndb_conflict_roleYesYesYesGlobalYesNDB 관련
214ndb_data_node_neighbourYesYesYesGlobalYesNDB 관련
215ndb_dbg_check_sharesYesYesYesBothYesNDB 관련
216ndb_default_column_formatYesYesYesGlobalYesNDB 관련
217ndb_default_column_formatYesYesYesGlobalYesNDB 관련
218ndb_deferred_constraintsYesYesYesBothYesNDB 관련
219ndb_deferred_constraintsYesYesYesBothYesNDB 관련
220ndb_distributionYesYesYesGlobalYesNDB 관련
221ndb_distributionYesYesYesGlobalYesNDB 관련
222ndb_eventbuffer_free_percentYesYesYesGlobalYesNDB 관련
223ndb_eventbuffer_max_allocYesYesYesGlobalYesNDB 관련
224ndb_extra_loggingYesYesYesGlobalYesNDB 관련
225ndb_force_sendYesYesYesBothYesNDB 관련
226ndb_fully_replicatedYesYesYesBothYesNDB 관련
227ndb_index_stat_enableYesYesYesBothYesNDB 관련
228ndb_index_stat_optionYesYesYesBothYesNDB 관련
229ndb_join_pushdownYesBothYesNDB 관련
230ndb_log_apply_statusYesYesYesGlobalNoNDB 관련
231ndb_log_apply_statusYesYesYesGlobalNoNDB 관련
232ndb_log_binYesYesBothNoNDB 관련
233ndb_log_binlog_indexYesYesGlobalYesNDB 관련
234ndb_log_empty_epochsYesYesYesGlobalYesNDB 관련
235ndb_log_empty_epochsYesYesYesGlobalYesNDB 관련
236ndb_log_empty_updateYesYesYesGlobalYesNDB 관련
237ndb_log_empty_updateYesYesYesGlobalYesNDB 관련
238ndb_log_exclusive_readsYesYesYesBothYesNDB 관련
239ndb_log_exclusive_readsYesYesYesBothYesNDB 관련
240ndb_log_fail_terminateYesYesYesGlobalNoNDB 관련
241ndb_log_origYesYesYesGlobalNoNDB 관련
242ndb_log_origYesYesYesGlobalNoNDB 관련
243ndb_log_transaction_compressionYesYesYesGlobalYesNDB 관련
244ndb_log_transaction_compression_level_zstdYesYesYesGlobalYesNDB 관련
245ndb_log_transaction_dependencyYesYesYesGlobalNoNDB 관련
246ndb_log_transaction_idYesYesYesGlobalNoNDB 관련
247ndb_log_transaction_idYesGlobalNoNDB 관련
248ndb_log_update_as_writeYesYesYesGlobalYesNDB 관련
249ndb_log_update_minimalYesYesYesGlobalYesNDB 관련
250ndb_log_updated_onlyYesYesYesGlobalYesNDB 관련
251ndb_metadata_checkYesYesYesGlobalYesNDB 관련
252ndb_metadata_check_intervalYesYesYesGlobalYesNDB 관련
253ndb_metadata_syncYesGlobalYesNDB 관련
254ndb_optimization_delayYesYesYesGlobalYesNDB 관련
255ndb_optimized_node_selectionYesYesYesGlobalNoNDB 관련
256ndb_read_backupYesYesYesGlobalYesNDB 관련
257ndb_recv_thread_activation_thresholdYesYesYesGlobalYesNDB 관련
258ndb_recv_thread_cpu_maskYesYesYesGlobalYesNDB 관련
259ndb_replica_batch_sizeYesYesYesGlobalYesNDB 관련
260ndb_replica_blob_write_batch_bytesYesYesYesGlobalYesNDB 관련
261Ndb_replica_max_replicated_epochYesGlobalNoNDB 관련
262ndb_report_thresh_binlog_epoch_slipYesYesYesGlobalYesNDB 관련
263ndb_report_thresh_binlog_mem_usageYesYesYesGlobalYesNDB 관련
264ndb_row_checksumYesBothYesNDB 관련
265ndb_schema_dist_lock_wait_timeoutYesYesYesGlobalYesNDB 관련
266ndb_schema_dist_timeoutYesYesYesGlobalNoNDB 관련
267ndb_schema_dist_timeoutYesYesYesGlobalNoNDB 관련
268ndb_schema_dist_upgrade_allowedYesYesYesGlobalNoNDB 관련
269ndb_show_foreign_key_mock_tablesYesYesYesGlobalYesNDB 관련
270ndb_slave_conflict_roleYesYesYesGlobalYesNDB 관련
271Ndb_system_nameYesGlobalNoNDB 관련
272ndb_table_no_loggingYesSessionYesNDB 관련
273ndb_table_temporaryYesSessionYesNDB 관련
274ndb_use_copying_alter_tableYesBothNoNDB 관련
275ndb_use_exact_countYesBothYesNDB 관련
276ndb_use_transactionsYesYesYesBothYesNDB 관련
277ndb_versionYesGlobalNoNDB 관련
278ndb_version_stringYesGlobalNoNDB 관련
279ndb_wait_connectedYesYesYesGlobalNoNDB 관련
280ndb_wait_setupYesYesYesGlobalNoNDB 관련
281pid_fileYesYesYesGlobalNoManaged 관련
282plugin_dirYesYesYesGlobalNoManaged 관련
283relay_logYesYesYesGlobalNoManaged 관련
284relay_log_basenameYesGlobalNoManaged 관련
285relay_log_indexYesYesYesGlobalNoManaged 관련
286relay_log_info_fileYesYesYesGlobalNoManaged 관련
287replica_load_tmpdirYesYesYesGlobalNoManaged 관련
288rpl_semi_sync_master_enabledYesYesYesGlobalYessemi_sync 관련
289rpl_semi_sync_master_timeoutYesYesYesGlobalYessemi_sync 관련
290rpl_semi_sync_master_trace_levelYesYesYesGlobalYessemi_sync 관련
291rpl_semi_sync_master_wait_for_slave_countYesYesYesGlobalYessemi_sync 관련
292rpl_semi_sync_master_wait_no_slaveYesYesYesGlobalYessemi_sync 관련
293rpl_semi_sync_master_wait_pointYesYesYesGlobalYessemi_sync 관련
294rpl_semi_sync_replica_enabledYesYesYesGlobalYessemi_sync 관련
295rpl_semi_sync_replica_trace_levelYesYesYesGlobalYessemi_sync 관련
296rpl_semi_sync_slave_enabledYesYesYesGlobalYessemi_sync 관련
297rpl_semi_sync_slave_trace_levelYesYesYesGlobalYessemi_sync 관련
298rpl_semi_sync_source_enabledYesYesYesGlobalYessemi_sync 관련
299rpl_semi_sync_source_timeoutYesYesYesGlobalYessemi_sync 관련
300rpl_semi_sync_source_trace_levelYesYesYesGlobalYessemi_sync 관련
301rpl_semi_sync_source_wait_for_replica_countYesYesYesGlobalYessemi_sync 관련
302rpl_semi_sync_source_wait_no_replicaYesYesYesGlobalYessemi_sync 관련
303rpl_semi_sync_source_wait_pointYesYesYesGlobalYessemi_sync 관련
304secure_file_privYesYesYesGlobalNoManaged 관련
305server_idYesYesYesGlobalYesManaged 관련
306server_id_bitsYesYesYesGlobalNoManaged 관련
307server_uuidYesGlobalNoManaged 관련
308slave_Load_tmpdirYesYesYesGlobalNoManaged 관련
309slave_parallel_typeYesYesYesGlobalYesManaged 관련
310slave_parallel_workersYesYesYesGlobalYesManaged 관련
311slave_preserve_commit_orderYesYesYesGlobalYesManaged 관련
312slow_query_logYesYesYesGlobalYesManaged 관련
313slow_query_log_fileYesYesYesGlobalYesManaged 관련
314socketYesYesYesGlobalNoManaged 관련
315sql_log_binYesSessionYesManaged 관련
316sql_log_offYesBothYesManaged 관련
317super_read_onlyYesYesYesGlobalYesManaged 관련
318sync_master_infoYesYesYesGlobalYesManaged 관련
319sync_relay_logYesYesYesGlobalYesManaged 관련
320sync_relay_log_infoYesYesYesGlobalYesManaged 관련
321sync_source_infoYesYesYesGlobalYesManaged 관련
322tmpdirYesYesYesGlobalNoManaged 관련

기본 저장 프로시저 제공 항목

분류용도프로시저 명칭
구성 옵션구성 옵션 변경mnms_set_configuration
세션 관리세션 중지mnms_kill
쿼리 중지mnms_kill_query
계정 생성 및 권한계정 생성mnms_create_user
계정 삭제mnms_drop_user
권한 부여mnms_grant_right_user
권한 취소mnms_revoke_right_user
Role 관리Role 권한 부여mnms_grant_right_role
Role 권한 취소mnms_revoke_right_role
계정 Role 부여mnms_grant_role_user
계정 Role 취소mnms_revoke_role_user