RDS MySQL 함수 확인
RDS에 기본적으로 생성되어있는 MySQL RDS 관리용 함수 목록 확인.
(가끔 이름이 헷갈려서..)
SELECT
ROUTINE_NAME
FROM
information_Schema.routines
WHERE
routine_schema = 'mysql'
AND routine_name LIKE 'rds_%';
+--------------------------------------------+
| ROUTINE_NAME |
+--------------------------------------------+
| rds_assign_gtids_to_anonymous_transactions |
| rds_collect_global_status_history |
| rds_disable_gsh_collector |
| rds_disable_gsh_rotation |
| rds_enable_gsh_collector |
| rds_enable_gsh_rotation |
| rds_external_master |
| rds_external_source |
| rds_import_binlog_ssl_material |
| rds_kill |
| rds_kill_query |
| rds_next_master_log |
| rds_next_source_log |
| rds_remove_binlog_ssl_material |
| rds_reset_external_master |
| rds_reset_external_source |
| rds_rotate_general_log |
| rds_rotate_global_status_history |
| rds_rotate_slow_log |
| rds_set_configuration |
| rds_set_external_master |
| rds_set_external_master_with_auto_position |
| rds_set_external_source |
| rds_set_external_source_with_auto_position |
| rds_set_gsh_collector |
| rds_set_gsh_rotation |
| rds_set_master_auto_position |
| rds_set_source_auto_position |
| rds_show_configuration |
| rds_skip_repl_error |
| rds_skip_transaction_with_gtid |
| rds_start_replication |
| rds_stop_replication |
+--------------------------------------------+
33 rows in set (0.01 sec)
mysql> 각 함수에 대한 설명은 https://docs.aws.amazon.com/ko_kr/AmazonRDS/latest/UserGuide/Appendix.MySQL.SQLRef.html 페이지에서 확인 가능