Community

Blog Events Webinars Tutorials Forum
  1. Blog
  2. Events
  3. Webinars
  4. Tutorials
  5. Forum
Create Account
×
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

MySQL Database performance Cloud Database Tutorials ApsaraDB RDS for MySQL Write Performance
0 1 0
Share on

Read previous post:

The Basic Use of RDS (Part 4): Introduction To ApsaraDB RDS MySQL Series

Read next post:

General Testing on RDS - Part2: Write Performance Competition: Find The Truth

ApsaraDB

443 posts | 93 followers

You may also like

Comments

ApsaraDB

443 posts | 93 followers

Related Products

More Posts by ApsaraDB

See All