MySQL on Amazon RDS SQL reference

This appendix describes system stored procedures that are available for Amazon RDS instances running the MySQL DB engine.

Overview

The following system stored procedures are supported for Amazon RDS DB instances running MySQL. The master user must run these procedures.

Replication

• mysql.rds_set_master_auto_position

• mysql.rds_set_external_master

• mysql.rds_set_external_master_with_delay

• mysql.rds_set_external_master_with_auto_position

• mysql.rds_reset_external_master

• mysql.rds_import_binlog_ssl_material

• mysql.rds_remove_binlog_ssl_material

• mysql.rds_set_source_delay

• mysql.rds_start_replication

• mysql.rds_start_replication_until

• mysql.rds_start_replication_until_gtid

• mysql.rds_stop_replication

• mysql.rds_skip_transaction_with_gtid

• mysql.rds_skip_repl_error

• mysql.rds_next_master_log

InnoDB cache warming

• mysql.rds_innodb_buffer_pool_dump_now

• mysql.rds_innodb_buffer_pool_load_now

• mysql.rds_innodb_buffer_pool_load_abort

Managing additional configuration (for example, binlog file retention)

• mysql.rds_set_configuration

• mysql.rds_show_configuration

Ending a session or query

• mysql.rds_kill

• mysql.rds_kill_query

Logging

• mysql.rds_rotate_general_log

• mysql.rds_rotate_slow_log

Managing the global status history

• mysql.rds_enable_gsh_collector

• mysql.rds_set_gsh_collector

• mysql.rds_disable_gsh_collector

• mysql.rds_collect_global_status_history

• mysql.rds_enable_gsh_rotation

• mysql.rds_set_gsh_rotation

• mysql.rds_disable_gsh_rotation

• mysql.rds_rotate_global_status_history

SQL reference conventions

Following, you can find explanations for the conventions that are used to describe the syntax of the system stored procedures and tables described in the SQL reference section.

Character	Description
UPPERCASE	Words in uppercase are keywords.
[ ]	Square brackets indicate optional arguments.
{ }	Braces indicate that you are required to choose one of the arguments inside the braces.
|	Pipes separate arguments that you can choose.
italics	Words in italics indicate placeholders. You must insert the appropriate value in place of the word in italics.
…	An ellipsis indicates that you can repeat the preceding element.
'	Words in single quotes indicate that you must type the quotes.