redis读写能力为2W/s
mysql读能力5K/s、写能力为3K/s
数据上看redis性能碾压mysql
当然从字面上不能很好的感受到性能差距,接下来用一个demo来做个实际的对比。
一:demo
1.创建springboot项目
pom.xml中配置
<dependency>
<!--改版本 使得driverclass不报红-->
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.38</version>
</dependency>
application.yml
配置连接linux中mysql和redis
server:
port: 9000
spring:
datasource:
driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql://192.168.56.100:3306/shoppings
username: root
password: root
redis:
database: 0
host: 192.168.56.100
port: 6379
password:
controller包
InitCtrl
package cn.kgc.demo.controller;
import cn.kgc.demo.entity.Goods;
import cn.kgc.demo.services.GoodsService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util