价格差不多自建mysql与RDS对比

最近买了1200M的 RDS
测试自建mysql数据库,与RDS性能
对比如下(两台数据库codes表都是5000条一模一样的数据)
1,用独立ECS(2核cpu,4G内存)自建mysql
另外一台内网远程链接这台数据库,测试结果:

• Code Load (0.6ms)  SELECT  `codes`.* FROM `codes`  LIMIT 10
• Code Load (0.9ms)  SELECT  `codes`.* FROM `codes`  LIMIT 100
• Code Load (1.2ms)  SELECT  `codes`.* FROM `codes`  LIMIT 200
• Code Load (1.4ms)  SELECT  `codes`.* FROM `codes`  LIMIT 500
• Code Load (2.3ms)  SELECT  `codes`.* FROM `codes`  LIMIT 1000
• Code Load (3.6ms)  SELECT  `codes`.* FROM `codes`  LIMIT 2000
• Code Load (7.1ms)  SELECT  `codes`.* FROM `codes`  LIMIT 5000

• Code Load (4.1ms)  SELECT  `codes`.* FROM `codes`  LIMIT 10
• Code Load (5.6ms)  SELECT  `codes`.* FROM `codes`  LIMIT 100
• Code Load (7.9ms)  SELECT  `codes`.* FROM `codes`  LIMIT 200
• Code Load (259.9ms)  SELECT  `codes`.* FROM `codes`  LIMIT 500
• Code Load (492.5ms)  SELECT  `codes`.* FROM `codes`  LIMIT 1000
• Code Load (830.9ms)  SELECT  `codes`.* FROM `codes`  LIMIT 2000
• Code Load (2323.9ms)  SELECT  `codes`.* FROM `codes`  LIMIT 5000