【04】jmeter基础篇-Mysql数据库压测

一、Jmeter-JDBC request连接Mysql简介

 

 

 

 

 

 

 

 

二、 Jmeter-JDBC request压测Mysql遇到问题

如果运行的时候提示“Cannot create PoolableConnectionFactory (Could not create connection to database server.)”则说明版本太低，

需要在https://mvnrepository.com/artifact/mysql/mysql-connector-java下载最新版本

 

 

 

 

错误2：如果更新了mysql的jar包后，报错提示“Cannot create PoolableConnectionFactory (The server time zone value '???��������??��??' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.)”，则需要把mysql的url地址后面加“?serverTimezone=UTC”

 

三、 Jmeter-JDBC request压测Mysql常用的命令

1、select查询

2、update语句

 

 2、select语句