What storage engines are supported by RDS for MySQL?
The InnoDB engine is recommended. For RDS for MySQL databases, only the InnoDB engine supports complete backup, restoration, and other services.
Alternatively, you can log in to the database and execute the show engines; command to view the storage engines supported by the database or refer to the following figure for selection.
What types of storage does RDS for MySQL use?
RDS for MySQL uses two types of storage: Elastic Volume Service (EVS) and Object-Oriented Storage (OOS). Neither method occupies the database space of the user when storing the backup data.
RDS for MySQL uses EVS for storage. For details about EVS, see eSurfing Cloud-EVS.
For details about OOS, see eSurfing Cloud-Object Storage.
Does RDS for MySQL support stored procedures and functions?
Yes, RDS for MySQL supports stored procedures and functions. For details about how to create stored procedures and functions, see the MySQL official documentation.
Stored procedures are a set of precompiled SQL statements that can be stored in a database and executed repeatedly. They are often used to perform complex database operations, such as inserting, updating, deleting data, and so on. The stored procedures can receive parameters and return one or more result sets.
Functions are a special type of stored procedures that return a value and can receive zero or more input parameters. Unlike stored procedures, functions cannot execute data definition statements (such as CREATE, ALTER, and DROP) or transaction control statements (such as COMMIT and ROLLBACK).
What should I do if my data exceeds the maximum storage capacity of an RDS for MySQL instance?
Insufficient storage space in RDS for MySQL will affect the use of the instance. It is recommended that you:
Clear useless data in time.
If your instance has insufficient storage space over time, it is recommended that you initiate Storage Space Scaling on the Console page. For details about how to scale up the storage space, see User Guide-Instance Management-Storage Space Scaling.
How do I view the storage space usage of RDS for MySQL?
Log in to the MySQL Console page of eSurfing Cloud.
Click the name of the instance you want to view and jump to the Instance Details page.
On the Instance Details page, you can view the size and usage of the storage space of the instance.
