×
Community Blog General Testing on RDS - Part1: Write Performance Competition: 1C1G RDS MySQL vs 2C4G on-premise MySQL

General Testing on RDS - Part1: Write Performance Competition: 1C1G RDS MySQL vs 2C4G on-premise MySQL

In part 1 of this video tutorial, we will compare with the write performance on an ECS of 1C1G RDS MySQL and 2C4G on-premise MySQL.

In this video tutorial, you will be able to see which one is faster to accomplish 10,000 records insert using the same method, the on-premise MySQL running on an ECS of 2 vCPU 4GB RAM or the RDS MySQL of 1 vCPU 1GB RAM?

Here are the codes to create stored procedures that mentioned in the video.

DROP PROCEDURE IF EXISTS proc_initData;
#create a stored producer for 10,000 records generation
DELIMITER $
CREATE PROCEDURE proc_initData()
BEGIN
    DECLARE i INT DEFAULT 1;
    WHILE i 《= 10000 DO
        INSERT INTO speed_test_cloud(name,createTime) values('hello',NOW());
        SET i = i+1;
    END WHILE;
END $

#call the PROCEDURE to generate test data
CALL proc_initData();

Video Demo

If you want to try it on your own, here are the latest offers and free trials you can apply.
https://www.alibabacloud.com/product/databases

👉️ Part 2 of this tutorial series: https://www.alibabacloud.com/blog/general-testing-on-rds---part2-write-performance-competition-find-the-truth_599529

0 0 0
Share on

ApsaraDB

261 posts | 23 followers

You may also like

Comments