Jmeter连接mysql成功

1 下载,mysql-connector-odbc-5.3.4-winx64.msi 进行安装  《转载》

2 安装后, copy “C:ProgramFiles (x86)MySQLMySQL Connector J mysql-connector-java-5.1.33-bin.jar”to  ..apache-jmeter-2.9lib

3 增加环境变量,Add CLASSPATH=.;...;%JMETER_HOME%libmysql-connector-java-5.1.33-bin.jar;

4 配置数据源,mysqlsource

wKioL1iDXvKzb1J8AABjJ7h0YKQ065.png-wh_50

5 jmeter设置,增加配置元件jdbc con,增加采集器jdbc req,增加响应断言,增加监听器查看结果树;运行jmeter;查看结果;

jdbc connection configuration  

wKiom1iDXyCTEJgQAABhqhbsiUw606.png-wh_50


jdbc request

wKiom1iDX13hXiF5AAA8u7io8fw089.png-wh_50


查看结果树

wKioL1iDX26xcraHAABrwWsAGKg324.png-wh_50



另:查询结果数据过多时,出现错误日志:java head space    OutOfMemoryError



原文地址:https://www.cnblogs.com/finer/p/11895368.html